private void neuFpEnter1_LeaveCell(object sender, FarPoint.Win.Spread.LeaveCellEventArgs e)
{
//if (!ValidDefaultState())
//{
// MessageBox.Show("只能有一个默认号段");
//}
}
private void fpSpread1_LeaveCell(object sender, FarPoint.Win.Spread.LeaveCellEventArgs e)
{
if (e.Column == (int)ColEnum.ColNum)
{
this.Count();
}
}
//Spread的LeaveCell事件，假如当前行第一列checkbox的状态不为选择状态，执行行刷新。
private void ss1_LeaveCell(object sender, FarPoint.Win.Spread.LeaveCellEventArgs e)
{
if (ss1_Sheet1.Cells[e.Row, 0].Text != "True")
{
//string sQuery = "{call WGC3030C.P_SONEROW ( '" + ss1_Sheet1.Cells[e.Row, 2].Text.Trim() + "')}";
//SpreadCommon.Gp_Sp_OneRowDisplay(GeneralCommon.M_CN1, sQuery, ss1, e.Row);
}
}
private void bsprGroupList_LeaveCell(object sender, FarPoint.Win.Spread.LeaveCellEventArgs e)
{
if (this.bsprGroupList.DataSet != null)
{
DataTable dt = ((DataSet)this.bsprGroupList.DataSet).Tables[0];
//Insert된 Row에 대해서 Select column Cell Lock 설정
for (int i = 0; i < dt.Rows.Count; i++)
{
if (this.bsprGroupList.ActiveSheet.Cells[i, (int)GroupColumnIndex.Insert].Value.ToString() == Definition.VARIABLE_TRUE)
{
this.bsprGroupList.ActiveSheet.Cells[i, (int)GroupColumnIndex.Select].Locked = true;
}
}
for (int i = 0; i < dt.Rows.Count; i++)
{
if (this.bsprGroupList.ActiveSheet.Cells[i, (int)GroupColumnIndex.GroupModel].Value != null)
{
this.bsprGroupList.ActiveSheet.Cells[i, (int)GroupColumnIndex.GroupModel].Value = this.bsprGroupList.ActiveSheet.Cells[i, (int)GroupColumnIndex.GroupModel].Value.ToString().ToUpper();
}
}
for (int i = 0; i < _dtGroup.Rows.Count; i++)
{
if (dt.Rows[i][COLUMN.GROUP_NAME].ToString() == _dtGroup.Rows[i][COLUMN.GROUP_NAME].ToString())
{
this.bsprGroupList.ActiveSheet.Cells[i, (int)GroupColumnIndex.Modify].Value = Definition.VARIABLE_FALSE;
}
else
{
this.bsprGroupList.ActiveSheet.Cells[i, (int)GroupColumnIndex.Modify].Value = Definition.VARIABLE_TRUE;
}
}
//for (int i = 0; i < dt.Columns.Count; i++)
//{
// for (int j = 0; j < dt.Rows.Count; j++)
// {
// //Group Name이 변경된 경우만 Modify Column에 check.
// if (dt.Rows.Count == this._dtGroup.Rows.Count)
// {
// if (dt.Rows[j][i].ToString() != this._dtGroup.Rows[j][i].ToString() && (i != (int)GroupColumnIndex.Insert && i != (int)GroupColumnIndex.Modify
// && i != (int)GroupColumnIndex.Delete && i != (int)GroupColumnIndex.Select) && dt.Rows[j][(int)GroupColumnIndex.Insert].ToString() != Definition.VARIABLE_TRUE)
// {
// this.bsprGroupList.ActiveSheet.Cells[j, (int)GroupColumnIndex.Modify].Value = Definition.VARIABLE_TRUE;
// //return;
// }
// //else
// //{
// // this.bsprGroupList.ActiveSheet.Cells[j, (int)GroupColumnIndex.Modify].Value = Definition.VARIABLE_FALSE;
// //}
// }
// }
//}
}
}
private void fpSpread1_LeaveCell(object sender, FarPoint.Win.Spread.LeaveCellEventArgs e)
{
if (e.Column == (int)ColumnSet.ColName)
{
Neusoft.HISFC.Models.Base.Spell spCode = new Neusoft.HISFC.Models.Base.Spell();
spCode = (Neusoft.HISFC.Models.Base.Spell) this.spellManager.Get(this.neuSpread1_Sheet1.Cells[e.Row, (int)ColumnSet.ColName].Text.ToString());
if (spCode == null)
{
return;
}
if (spCode.SpellCode == null || spCode.SpellCode == "")
{
return;
}
this.neuSpread1_Sheet1.Cells[e.Row, (int)ColumnSet.ColSpellCode].Value = spCode.SpellCode;
this.neuSpread1_Sheet1.Cells[e.Row, (int)ColumnSet.ColWBCode].Value = spCode.WBCode;
}
}
private void fpSpread1_LeaveCell(object sender, FarPoint.Win.Spread.LeaveCellEventArgs e)
{
}
private void fspdMc_LeaveCell(object sender, FarPoint.Win.Spread.LeaveCellEventArgs e)
{
ComSpread.Spread_LeaveCellBColor(fspdMc, e, Color.Lavender);
}
private void fpSelector_LeaveCell(object sender, FarPoint.Win.Spread.LeaveCellEventArgs e)
{
((FarPoint.Win.Spread.FpSpread)sender).ActiveSheet.Rows[e.Row].BackColor = Color.White;
}
