重写 SelectionRenderer后选中spread的一行，背景没有变色，不生效，如何处理？

收藏

本帖最后由 dapsjj 于 2016-11-7 09:00 编辑

重写 SelectionRenderer后选中spread的一行，不生效，请问哪里有问题？想让鼠标左键选中spread的一行后，这行数据变为蓝色，代码如下，但是发现选中一行后没有反应，背景没有变为蓝色？请问哪里不对？我选中了下图红框中的的数据，但是背景没有变色。33，34行。213-221行是变背景色的代码。

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Runtime.Remoting.Messaging;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MY.BLL;
using MY.Common;
namespace PcSystemMain
{
public partial class frmGetActualProduction : Form
{
#region
private string connPCDB = null;
private CommonPara cp = new CommonPara();
private string flag = "";//初始化被选中的记录的标志位空
private int checked_count = 0;//计算被选中的checkbox的数量
private int bin = -1;
#endregion
private delegate bool DoWorkDelegate();
public frmGetActualProduction()
{
InitializeComponent();
this.loadingPanel1.OnRotateStateChanged += new LoadingPanel.RotateStateChangedHandler(loadingPanel1_OnRotateStateChanged);
SelectionRenderer sr = new SelectionRenderer();
sprshow.SelectionRenderer = sr;
}
private void cmdExit_Click(object sender, EventArgs e)
{
this.Close();
}
private void frmGetActualProduction_Load(object sender, EventArgs e)
{
try
{
connPCDB = cp.GetConString();
SqlHelper sh = new SqlHelper(connPCDB);
DataSet ds = sh.ExecuteDatasetSQL("SELECT c1,c2,0 as c3, c4 FROM tabel1 ");
setSpreadData(ds.Tables[0]);
}
catch (Exception)
{
}
}
private void setSpreadData(DataTable spdt)
{
if (this.sprshow.ActiveSheet.RowCount > 0)
{
this.sprshow.ActiveSheet.Rows.Count = 0;
}
this.sprshow.ActiveSheet.Rows.Count = spdt.Rows.Count;
DataRowCollection rows = spdt.Rows;
int rowCount = rows.Count;
int nowRow = 0;
for (int i = 0; i < rowCount; i++)
{
sprshow.ActiveSheet.Cells[nowRow, 0].Value = rows[i]["A"].ToString();
sprshow.ActiveSheet.Cells[nowRow, 1].Value = rows[i]["B"].ToString();
sprshow.ActiveSheet.Cells[nowRow, 2].Value = rows[i]["C"].ToString();
sprshow.ActiveSheet.Cells[nowRow, 3].Value = rows[i]["D"].ToString();
nowRow++;
}
}
private void sprshow_ButtonClicked(object sender, FarPoint.Win.Spread.EditorNotifyEventArgs e)
{
checked_count = 0;
for (int i = 0; i < sprshow.Sheets[0].Rows.Count; i++)
{
if (checked_count <= 1)
{
flag = sprshow.Sheets[0].Cells[i, 2].Value.ToString();//复选框是否被选中
if (flag == "True")//"True"为选中,"0"为未选中。
{
int col4_value = int.Parse(sprshow.Sheets[0].Cells[i, 3].Value.ToString());//第4列
if (col4_value == 1)
{
sprshow.Sheets[0].Cells[i, 2].Value = 0;//清除被选的状态
bin = int.Parse(sprshow.Sheets[0].Cells[i, 0].Value.ToString());
MessageBox.Show(bin);
break;
}
else
{
checked_count++;
}
}
}
else
{
MessageBox.Show("只能选一个.");
checked_count = 0;
break;
}
}
}
void loadingPanel1_OnRotateStateChanged()
{
this.Invoke(new Action(delegate()
{
this.sprshow.Visible = !this.sprshow.Visible;
this.Cmdchace.Enabled = !this.Cmdchace.Enabled;
this.cmdGetActualProduction.Enabled = !this.cmdGetActualProduction.Enabled;
this.cmdExit.Enabled = !this.cmdExit.Enabled;
}));
}
private bool DoWork()
{
System.Threading.Thread.Sleep(10000);
return true;
}
private void DoWorkCallBack(IAsyncResult ar)
{
AsyncResult result = (AsyncResult)ar;
DoWorkDelegate caller = (DoWorkDelegate)result.AsyncDelegate;
bool bResult = caller.EndInvoke(ar);
this.loadingPanel1.Stop();
}
private void cmdGetActualProduction_Click(object sender, EventArgs e)
{
if (MessageBox.Show("", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.Cancel)
{
return;
}
else { //点击的是"OK"按钮
int count = 0;//计算被选择的复选框数量
string status = "";
for (int i = 0; i < sprshow.Sheets[0].Rows.Count; i++)
{
status = sprshow.Sheets[0].Cells[i, 2].Value.ToString();//复选框是否被选中
if (status == "True")//"True"为选中,"0"为未选中。
{
count++;
}
}
if (count == 0)
{
MessageBox.Show("请选择.");
return;
}
else if (count > 1)
{
MessageBox.Show("只能选一个.");
return;
}
else//count == 1
{
try
{
connPCDB = cp.GetConString();
SqlHelper sh = new SqlHelper(connPCDB);
sh.Param = sh.GetNewParam();
sh.Param.AddParam("@intBin", SqlDbType.Int, bin);
DataSet ds = sh.ExecuteDatasetSP("AcquireMeterActualResults", ref sh.Param, 3000);
}
catch (Exception)
{
}
}
}
}
private void Cmdchace_Click(object sender, EventArgs e)
{
for (int i = 0; i < sprshow.Sheets[0].Rows.Count; i++) {
int col4_value = int.Parse(sprshow.Sheets[0].Cells[i, 3].Value.ToString());//第4列
if (col4_value==1)
{
for (int j = 0; j <= i;j++ )
{
sprshow.Sheets[0].Cells[j, 2].Value = 0;
}
MessageBox.Show("不能全选.");
break;
}
sprshow.Sheets[0].Cells[i, 2].Value = true;
}
}
}
public class SelectionRenderer : FarPoint.Win.Spread.ISelectionRenderer
{
public void PaintSelection(Graphics g, int x, int y, int width, int height)
{
SolidBrush selectionBrush = new SolidBrush(Color.Blue);
g.FillRectangle(selectionBrush, x, y, width, height);
selectionBrush.Dispose();
}
}
}

复制代码

dexteryao · dexteryao

放到 frmGetActualProduction 构造函数中就可以

dexteryao · dexteryao

您好，问题收到，测试后给您回复

dexteryao · dexteryao

我看你只是点击了一个单元格。如果需要点击一个单元格选中整行需要再加上

fpSpread1.ActiveSheet.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Row;

dapsjj · dapsjj

dexteryao 发表于 2016-11-8 12:17
我看你只是点击了一个单元格。如果需要点击一个单元格选中整行需要再加上

fpSpread1.Activ ...

您好，您这句代码应该加到哪里？

dapsjj · dapsjj

最终代码为：

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Runtime.Remoting.Messaging;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MY.BLL;
using MY.Common;
namespace PcSystemMain
{
public partial class frmGetActualProduction : Form
{
#region
private string connPCDB = null;
private CommonPara cp = new CommonPara();
private string flag = "";//初始化被选中的记录的标志位空
private int checked_count = 0;//计算被选中的checkbox的数量
private int bin = -1;
#endregion
private delegate bool DoWorkDelegate();
public frmGetActualProduction()
{
InitializeComponent();
this.loadingPanel1.OnRotateStateChanged += new LoadingPanel.RotateStateChangedHandler(loadingPanel1_OnRotateStateChanged);
SelectionRenderer sr = new SelectionRenderer();
sprshow.SelectionRenderer = sr;
sprshow.ActiveSheet.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Row;
}
private void cmdExit_Click(object sender, EventArgs e)
{
this.Close();
}
private void frmGetActualProduction_Load(object sender, EventArgs e)
{
try
{
connPCDB = cp.GetConString();
SqlHelper sh = new SqlHelper(connPCDB);
DataSet ds = sh.ExecuteDatasetSQL("SELECT c1,c2,0 as c3, c4 FROM tabel1 ");
setSpreadData(ds.Tables[0]);
}
catch (Exception)
{
}
}
private void setSpreadData(DataTable spdt)
{
if (this.sprshow.ActiveSheet.RowCount > 0)
{
this.sprshow.ActiveSheet.Rows.Count = 0;
}
this.sprshow.ActiveSheet.Rows.Count = spdt.Rows.Count;
DataRowCollection rows = spdt.Rows;
int rowCount = rows.Count;
int nowRow = 0;
for (int i = 0; i < rowCount; i++)
{
sprshow.ActiveSheet.Cells[nowRow, 0].Value = rows[i]["A"].ToString();
sprshow.ActiveSheet.Cells[nowRow, 1].Value = rows[i]["B"].ToString();
sprshow.ActiveSheet.Cells[nowRow, 2].Value = rows[i]["C"].ToString();
sprshow.ActiveSheet.Cells[nowRow, 3].Value = rows[i]["D"].ToString();
nowRow++;
}
}
private void sprshow_ButtonClicked(object sender, FarPoint.Win.Spread.EditorNotifyEventArgs e)
{
checked_count = 0;
for (int i = 0; i < sprshow.Sheets[0].Rows.Count; i++)
{
if (checked_count <= 1)
{
flag = sprshow.Sheets[0].Cells[i, 2].Value.ToString();//复选框是否被选中
if (flag == "True")//"True"为选中,"0"为未选中。
{
int col4_value = int.Parse(sprshow.Sheets[0].Cells[i, 3].Value.ToString());//第4列
if (col4_value == 1)
{
sprshow.Sheets[0].Cells[i, 2].Value = 0;//清除被选的状态
bin = int.Parse(sprshow.Sheets[0].Cells[i, 0].Value.ToString());
MessageBox.Show(bin);
break;
}
else
{
checked_count++;
}
}
}
else
{
MessageBox.Show("只能选一个.");
checked_count = 0;
break;
}
}
}
void loadingPanel1_OnRotateStateChanged()
{
this.Invoke(new Action(delegate()
{
this.sprshow.Visible = !this.sprshow.Visible;
this.Cmdchace.Enabled = !this.Cmdchace.Enabled;
this.cmdGetActualProduction.Enabled = !this.cmdGetActualProduction.Enabled;
this.cmdExit.Enabled = !this.cmdExit.Enabled;
}));
}
private bool DoWork()
{
System.Threading.Thread.Sleep(10000);
return true;
}
private void DoWorkCallBack(IAsyncResult ar)
{
AsyncResult result = (AsyncResult)ar;
DoWorkDelegate caller = (DoWorkDelegate)result.AsyncDelegate;
bool bResult = caller.EndInvoke(ar);
this.loadingPanel1.Stop();
}
private void cmdGetActualProduction_Click(object sender, EventArgs e)
{
if (MessageBox.Show("", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.Cancel)
{
return;
}
else { //点击的是"OK"按钮
int count = 0;//计算被选择的复选框数量
string status = "";
for (int i = 0; i < sprshow.Sheets[0].Rows.Count; i++)
{
status = sprshow.Sheets[0].Cells[i, 2].Value.ToString();//复选框是否被选中
if (status == "True")//"True"为选中,"0"为未选中。
{
count++;
}
}
if (count == 0)
{
MessageBox.Show("请选择.");
return;
}
else if (count > 1)
{
MessageBox.Show("只能选一个.");
return;
}
else//count == 1
{
try
{
connPCDB = cp.GetConString();
SqlHelper sh = new SqlHelper(connPCDB);
sh.Param = sh.GetNewParam();
sh.Param.AddParam("@intBin", SqlDbType.Int, bin);
DataSet ds = sh.ExecuteDatasetSP("AcquireMeterActualResults", ref sh.Param, 3000);
}
catch (Exception)
{
}
}
}
}
private void Cmdchace_Click(object sender, EventArgs e)
{
for (int i = 0; i < sprshow.Sheets[0].Rows.Count; i++) {
int col4_value = int.Parse(sprshow.Sheets[0].Cells[i, 3].Value.ToString());//第4列
if (col4_value==1)
{
for (int j = 0; j <= i;j++ )
{
sprshow.Sheets[0].Cells[j, 2].Value = 0;
}
MessageBox.Show("不能全选.");
break;
}
sprshow.Sheets[0].Cells[i, 2].Value = true;
}
}
}
public class SelectionRenderer : FarPoint.Win.Spread.ISelectionRenderer
{
public void PaintSelection(Graphics g, int x, int y, int width, int height)
{
SolidBrush selectionBrush = new SolidBrush(Color.Blue);
g.FillRectangle(selectionBrush, x, y, width, height);
selectionBrush.Dispose();
}
}
}

复制代码

dexteryao · dexteryao

还有什么问题吗

dapsjj · dapsjj

本帖最后由 dapsjj 于 2016-11-9 07:44 编辑

dexteryao 发表于 2016-11-8 15:14
还有什么问题吗

颜色太重文字被覆盖了，如第1幅图所示效果。怎么能把文字显示出来？再有就是被点的这个单元格没有变为蓝色。想要成第2幅图效果。

dexteryao · dexteryao

您好，因为spread不是一个传统的grid 控件，所以肯定是有一个activecell的，如果您的spread没有设置单元格背景色的话，可以换成下面的方式吧。

public Form1()
{
InitializeComponent();
fpSpread1.CellClick += FpSpread1_CellClick;
}
private void FpSpread1_CellClick(object sender, CellClickEventArgs e)
{
foreach(Row row in fpSpread1.ActiveSheet.Rows)
{
row.BackColor = Color.Empty;
}
fpSpread1.ActiveSheet.Rows[e.Row].BackColor = Color.SkyBlue;
}

复制代码

dapsjj · dapsjj

本帖最后由 dapsjj 于 2016-11-9 08:11 编辑

dexteryao 发表于 2016-11-8 16:52
您好，因为spread不是一个传统的grid 控件，所以肯定是有一个activecell的，如果您的spread没有设置单元格 ...

您好，spread我这边是有背景色的，如图中所示淡黄色，我试着在您提供的代码基础上加上了一句：
sprdMain.ActiveSheet.Rows[e.Row].ForeColor = Color.White;想让被点中的那一行文字的颜色变为白色，但是发现被点过的行文字的颜色变为白色后无法恢复了，如下图所示，请问怎么处理？
代码为：

private void sprdMain_CellClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
foreach (Row row in sprdMain.ActiveSheet.Rows)
{
row.BackColor = Color.Empty;
}
sprdMain.ActiveSheet.Rows[e.Row].BackColor = Color.Blue;
sprdMain.ActiveSheet.Rows[e.Row].ForeColor = Color.White;
}
}

复制代码

第一幅图片是刚加载页面时候的样子，第二副图片是鼠标点击了前2行后再点击第三行的样子。如何让前2行被点过后恢复黑色文字的状态？

		自动登录	找回密码
密码			立即注册

[已处理] 重写 SelectionRenderer后选中spread的一行，背景没有变色，不生效，如何处理？

12 个回复

评分

讲师达人

悬赏达人

元老葡萄

SpreadJS 认证

SpreadJS 高级认证

微信认证勋章