/// <summary>
/// 修改焦点对象
/// </summary>
public void UpdateObject()
{
//获取焦点对象
PW_tb3c obj = FocusedObject;
if (obj == null)
{
return;
}
//创建对象的一个副本
PW_tb3c objCopy = new PW_tb3c();
DataConverter.CopyTo <PW_tb3c>(obj, objCopy);
//执行修改操作
using (FrmPW3cDialog dlg = new FrmPW3cDialog())
{
dlg.Object = objCopy; //绑定副本
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
}
//用副本更新焦点对象
DataConverter.CopyTo <PW_tb3c>(objCopy, obj);
//刷新表格
gridControl.RefreshDataSource();
}
/// <summary>
/// 添加对象
/// </summary>
public void AddObject()
{
//检查对象链表是否已经加载
if (ObjectList == null)
{
return;
}
//新建对象
PW_tb3c obj = new PW_tb3c();
obj.UID = Guid.NewGuid().ToString();
//执行添加操作
using (FrmPW3cDialog dlg = new FrmPW3cDialog())
{
dlg.IsCreate = true; //设置新建标志
dlg.Object = obj;
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
}
//将新对象加入到链表中
ObjectList.Add(obj);
//刷新表格，并将焦点行定位到新对象上。
gridControl.RefreshDataSource();
GridHelper.FocuseRow(this.gridView, obj);
}
private void FrmProject_Sum_Load(object sender, EventArgs e)
{
InitRight();
this.gridBand7.Columns.Add(this.bandedGridColumn5);
this.gridBand18.Columns.Add(this.bandedGridColumn6);
DevExpress.XtraEditors.Controls.CheckedListBoxItem[] chkItems = null;
this.checkedListBoxControl1.Items.Clear();
PW_tb3c pc = new PW_tb3c();
pc.col4 = Itop.Client.MIS.ProgUID;
IList <PW_tb3c> list3 = Services.BaseService.GetList <PW_tb3c>("SelectPW_tb3cList", pc);
chkItems = new DevExpress.XtraEditors.Controls.CheckedListBoxItem[list3.Count];
for (int i = 0; i < list3.Count; i++)
{
chkItems.SetValue(new DevExpress.XtraEditors.Controls.CheckedListBoxItem(list3[i].col1), i);
//if (((Layer)tmplaylist[i]).Visible)
//{
// chkItems[i].CheckState = CheckState.Checked;
//}
}
this.checkedListBoxControl1.Items.AddRange(chkItems);
this.checkedListBoxControl1.Location = new System.Drawing.Point(0, 0);
this.checkedListBoxControl1.Name = "checkedListBoxControl1";
this.popupContainerEdit1.Properties.PopupControl = this.popupContainerControl1;
}
/// <summary>
/// 刷新表格中的数据
/// </summary>
/// <returns>ture:成功 false:失败</returns>
public bool RefreshData()
{
try
{
this.gridView.GroupPanelText = "供电分区参数设置表";
PW_tb3c p = new PW_tb3c();
p.col4 = Itop.Client.MIS.ProgUID;
IList <PW_tb3c> list = Services.BaseService.GetList <PW_tb3c>("SelectPW_tb3cList", p);
this.gridControl.DataSource = list;
}
catch (Exception exc)
{
Debug.Fail(exc.Message);
HandleException.TryCatch(exc);
return(false);
}
return(true);
}
/// <summary>
/// 删除焦点对象
/// </summary>
public void DeleteObject()
{
//获取焦点对象
PW_tb3c obj = FocusedObject;
if (obj == null)
{
return;
}
//请求确认
if (MsgBox.ShowYesNo(Strings.SubmitDelete) != DialogResult.Yes)
{
return;
}
//执行删除操作
try
{
Services.BaseService.Delete <PW_tb3c>(obj);
}
catch (Exception exc)
{
Debug.Fail(exc.Message);
HandleException.TryCatch(exc);
return;
}
this.gridView.BeginUpdate();
//记住当前焦点行索引
int iOldHandle = this.gridView.FocusedRowHandle;
//从链表中删除
ObjectList.Remove(obj);
//刷新表格
gridControl.RefreshDataSource();
//设置新的焦点行索引
GridHelper.FocuseRowAfterDelete(this.gridView, iOldHandle);
this.gridView.EndUpdate();
}
private void FrmProject_SumDialog_Load(object sender, EventArgs e)
{
PW_tb3c type = new PW_tb3c();
type.col4 = Itop.Client.MIS.ProgUID;
IList <PW_tb3c> list0 = Services.BaseService.GetList <PW_tb3c>("SelectPW_tb3cList", type);
object[] obj = new object[list0.Count];
for (int i = 0; i < list0.Count; i++)
{
obj[i] = list0[i].col1;
}
this.repositoryItemComboBox1.Items.AddRange(obj);
for (int i = 1960; i < 2040; i++)
{
repositoryItemComboBox9.Items.Add(i.ToString());
}
IList <PW_tb3a> list = new List <PW_tb3a>();
list.Add(Object);
this.vGridControl.DataSource = list;
}
//此处为动态添加数据方法
private void Sheet_AddData(FarPoint.Win.Spread.SheetView obj_sheet)
{
int startrow = 3;
int addnum = 0;
int itemcount = 0;
int firstrow = 0;
ArrayList rowsum = new ArrayList();
Itop.Domain.PWTable.PW_tb3a p = new Itop.Domain.PWTable.PW_tb3a();
p.col2 = Itop.Client.MIS.ProgUID;
IList <PW_tb3a> list = Services.BaseService.GetList <PW_tb3a>("SelectPW_tb3aBy2251", p);
PW_tb3c p3 = new PW_tb3c();
p3.col4 = Itop.Client.MIS.ProgUID;
IList <PW_tb3c> plist = Services.BaseService.GetList <PW_tb3c>("SelectPW_tb3cList", p3);
IList <PW_tb3a> alist = Services.BaseService.GetList <PW_tb3a>("SelectPW_tb3aListDIS", p);
for (int n = 0; n < plist.Count; n++)
{
rowsum.Add("");
}
bool sheetEnd = false;
for (int i = 0; i < list.Count; i++)
{
PW_tb3a obj = list[i];
PW_tb3a obj2 = new PW_tb3a();
if (i < list.Count - 1)
{
obj2 = list[i + 1];
}
else
{
sheetEnd = true;
}
itemcount = itemcount + 1;
obj_sheet.RowCount = obj_sheet.RowCount + 1;
obj_sheet.SetValue(i + addnum + startrow, 0, obj.PQName);
obj_sheet.SetValue(i + addnum + startrow, 1, obj.PQtype);
obj_sheet.SetValue(i + addnum + startrow, 2, obj.Num10);
obj_sheet.SetValue(i + addnum + startrow, 3, obj.Num3);
obj_sheet.SetValue(i + addnum + startrow, 4, obj.Num2);
obj_sheet.SetValue(i + addnum + startrow, 5, obj.Num4);
obj_sheet.SetValue(i + addnum + startrow, 6, obj.KggNum);
obj_sheet.SetValue(i + addnum + startrow, 7, obj.KG);
obj_sheet.SetValue(i + addnum + startrow, 8, obj.KgzHwNum);
obj_sheet.SetValue(i + addnum + startrow, 9, obj.Num11);
// obj_sheet.SetValue(i + 3, 10, 1);
if (obj.PQName != obj2.PQName)
{
addnum = addnum + 1;
for (int x = 0; x < rowsum.Count; x++)
{
string str = (string)rowsum[x];
str = str + Convert.ToString(i + addnum + startrow - x - 1) + ",";
rowsum[x] = str;
}
obj_sheet.RowCount = obj_sheet.RowCount + 1;
obj_sheet.SetValue(i + addnum + startrow, 0, obj.PQName);
obj_sheet.SetValue(i + addnum + startrow, 1, "小计");
int num1 = startrow + addnum + firstrow;
if (firstrow == 0)
{
num1 = num1 - 1;
}
TC.Sheet_WriteFormula_RowSum(obj_sheet, num1, 2, itemcount, 1, i + addnum + startrow, 2, 8);
obj_sheet.AddSpanCell(num1, 0, itemcount + 1, 1);
firstrow = i;
startrow = 3;
itemcount = 0;
}
if (sheetEnd)
{
int[] sum = new int[plist.Count];
rowsum.Reverse();
for (int m = 0; m < plist.Count; m++)
{
PW_tb3c _p = plist[m];
addnum = addnum + 1;
obj_sheet.RowCount = obj_sheet.RowCount + 1;
obj_sheet.SetValue(i + addnum + startrow, 0, "全市合计");
obj_sheet.SetValue(i + addnum + startrow, 1, _p.col1);
sum[m] = i + addnum + startrow;
int num1 = startrow + addnum + firstrow;
//if (firstrow == 0) { num1 = num1 - 1; }
TC.Sheet_WriteFormula_RowSum3(obj_sheet, TC.getRowList(rowsum[m].ToString()), 2, i + addnum + startrow, 2, 8);
}
addnum = addnum + 1;
obj_sheet.RowCount = obj_sheet.RowCount + 1;
obj_sheet.SetValue(i + addnum + startrow, 0, "全市合计");
obj_sheet.SetValue(i + addnum + startrow, 1, "总计");
TC.Sheet_WriteFormula_RowSum3(obj_sheet, sum, 2, i + addnum + startrow, 2, 8);
obj_sheet.AddSpanCell(sum[0], 0, sum.Length + 1, 1);
}
}
}
