private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
Econ ec = new Econ();
ec.UID = "xxx";
System.IO.MemoryStream ms = new System.IO.MemoryStream();
try
{
fpSpread1.Save(ms, false);
ec.ExcelData = ms.GetBuffer();
Services.BaseService.Update<Econ>(ec);
}
catch (Exception ex) { MsgBox.Show(ex.Message); }
}
private void FrmLayoutContents_Load(object sender, EventArgs e)
{
numberCellTypes2.DecimalPlaces = 0;
//numberCellTypes2.FixedPoint = true;
numberCellTypes3.DecimalPlaces = 1;
numberCellTypes1.DecimalPlaces = 3;
numberCellTypes1.FixedPoint = true;
barButtonItem3.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
Econ ed=new Econ();
ed.UID="xxx";
bts = Services.BaseService.GetOneByKey<Econ>(ed).ExcelData;
//isload = 0;
InitForm();
InitData();
isloadstate = true;
treeList1.ExpandAll();
treeList1.MoveFirst();
}
private void SaveLayoutToXml()
{
string filepath1 = Path.GetTempPath();
switch (type2)
{
case "66":
if (leixing != "����")
{
LayoutList ll = this.ctrlLayoutList1.FocusedObject;
if (ll == null)
return;
//this.ctrlLine_Info1.bandedGridView2.SaveLayoutToXml(filepath1 +ll.UID +"RefreshDatalayout1.xml");
MemoryStream ms = new MemoryStream();
this.ctrlLine_Info1.bandedGridView2.SaveLayoutToStream(ms);
Econ ec = new Econ();
ec.UID = ll.UID + "RefreshDatalayout1";
ec.ExcelData = ms.ToArray();
IList<Econ> list = Services.BaseService.GetList<Econ>("SelectEconByKey", ec);
if (list.Count == 0)
Services.BaseService.Create<Econ>(ec);
else
Services.BaseService.Update<Econ>(ec);
}
else
{
//this.ctrlLine_Info1.bandedGridView2.SaveLayoutToXml(filepath1 + "RefreshDatalayout1.xml");
MemoryStream ms = new MemoryStream();
this.ctrlLine_Info1.bandedGridView2.SaveLayoutToStream(ms);
Econ ec = new Econ();
ec.UID = "RefreshDatalayout1";
ec.ExcelData = ms.ToArray();
IList<Econ> list = Services.BaseService.GetList<Econ>("SelectEconByKey", ec);
if (list.Count == 0)
Services.BaseService.Create<Econ>(ec);
else
Services.BaseService.Update<Econ>(ec);
}
break;
case "10":
if (leixing != "����")
{
LayoutList ll = this.ctrlLayoutList1.FocusedObject;
if (ll == null)
return;
//this.ctrlLine_Info1.bandedGridView2.SaveLayoutToXml(filepath1 + ll.UID + "RefreshDatalayout2.xml");
MemoryStream ms = new MemoryStream();
this.ctrlLine_Info1.bandedGridView2.SaveLayoutToStream(ms);
Econ ec = new Econ();
ec.UID = ll.UID + "RefreshDatalayout2";
ec.ExcelData = ms.ToArray();
IList<Econ> list = Services.BaseService.GetList<Econ>("SelectEconByKey", ec);
if (list.Count == 0)
Services.BaseService.Create<Econ>(ec);
else
Services.BaseService.Update<Econ>(ec);
}
else
{
//this.ctrlLine_Info1.bandedGridView2.SaveLayoutToXml(filepath1 + "RefreshDatalayout2.xml");
MemoryStream ms = new MemoryStream();
this.ctrlLine_Info1.bandedGridView2.SaveLayoutToStream(ms);
Econ ec = new Econ();
ec.UID = "RefreshDatalayout2";
ec.ExcelData = ms.ToArray();
IList<Econ> list = Services.BaseService.GetList<Econ>("SelectEconByKey", ec);
if (list.Count == 0)
Services.BaseService.Create<Econ>(ec);
else
Services.BaseService.Update<Econ>(ec);
}
break;
}
}
private void barButtonItem7_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
//if (ctrlLayoutList1.FocusedObject == null)
//{
// MsgBox.Show("û�м�¼���ڣ������Ա�����ʽ��");
// return;
//}
string filepath1 = Path.GetTempPath();
switch (type2)
{
case "66":
if (leixing != "����")
{
LayoutList ll = this.ctrlLayoutList1.FocusedObject;
if (ll == null)
return;
//this.ctrlLine_Info1.bandedGridView2.SaveLayoutToXml(filepath1 +ll.UID +"RefreshDatalayout1.xml");
MemoryStream ms = new MemoryStream();
this.ctrlLine_Info1.bandedGridView2.SaveLayoutToStream(ms);
Econ ec = new Econ();
ec.UID = ll.UID+"RefreshDatalayout1";
ec.ExcelData = ms.ToArray();
IList<Econ> list = Services.BaseService.GetList<Econ>("SelectEconByKey", ec);
if (list.Count == 0)
Services.BaseService.Create<Econ>(ec);
else
Services.BaseService.Update<Econ>(ec);
}
else
{
//this.ctrlLine_Info1.bandedGridView2.SaveLayoutToXml(filepath1 + "RefreshDatalayout1.xml");
MemoryStream ms = new MemoryStream();
this.ctrlLine_Info1.bandedGridView2.SaveLayoutToStream(ms);
Econ ec = new Econ();
ec.UID = "RefreshDatalayout1";
ec.ExcelData = ms.ToArray();
IList<Econ> list = Services.BaseService.GetList<Econ>("SelectEconByKey", ec);
if (list.Count == 0)
Services.BaseService.Create<Econ>(ec);
else
Services.BaseService.Update<Econ>(ec);
}
break;
case "10":
if (leixing != "����")
{
LayoutList ll = this.ctrlLayoutList1.FocusedObject;
if (ll == null)
return;
//this.ctrlLine_Info1.bandedGridView2.SaveLayoutToXml(filepath1 + ll.UID + "RefreshDatalayout2.xml");
MemoryStream ms = new MemoryStream();
this.ctrlLine_Info1.bandedGridView2.SaveLayoutToStream(ms);
Econ ec = new Econ();
ec.UID = ll.UID+ "RefreshDatalayout2";
ec.ExcelData = ms.ToArray();
IList<Econ> list = Services.BaseService.GetList<Econ>("SelectEconByKey", ec);
if (list.Count == 0)
Services.BaseService.Create<Econ>(ec);
else
Services.BaseService.Update<Econ>(ec);
}
else
{
//this.ctrlLine_Info1.bandedGridView2.SaveLayoutToXml(filepath1 + "RefreshDatalayout2.xml");
MemoryStream ms = new MemoryStream();
this.ctrlLine_Info1.bandedGridView2.SaveLayoutToStream(ms);
Econ ec = new Econ();
ec.UID = "RefreshDatalayout2";
ec.ExcelData = ms.ToArray();
IList<Econ> list = Services.BaseService.GetList<Econ>("SelectEconByKey", ec);
if (list.Count == 0)
Services.BaseService.Create<Econ>(ec);
else
Services.BaseService.Update<Econ>(ec);
}
break;
}
}
public bool RefreshData(string type,string con)
{
IList<Line_Info> list = new List<Line_Info>();
string conn = "";
try
{
types1 = type;
int dd = 0;
if (types2 == "220")
{ dd = 220; }
else if (types2 == "66")
{ dd = 66; }
else if (types2 == "10")
{ dd = 10; }
Line_Info li = new Line_Info();
li.DY = dd;
li.Flag = type;
string filepath1 = "";
Econ ec = new Econ();
if (types2 == "220")
{
conn = "Code='' and Flag='" + type + "'" + con;
list = Services.BaseService.GetList<Line_Info>("SelectLine_InfoByConn", conn);
CalcTotal(ref list);
//filepath1 = Path.GetTempPath()+ Path.GetFileName(FlagsType+"RefreshDatalayout1.xml");
if (FlagsType == "")
ec.UID = "RefreshDatalayout2";
else
ec.UID = FlagsType + "RefreshDatalayout2";
}
if (types2 == "66")
{
conn = "DY>10 and 10000>=DY and AreaID='" + projectid + "' "+con;// ;
list = Services.BaseService.GetList<Line_Info>("SelectLine_InfoByConn", conn);
CalcTotal(ref list);
//filepath1 = Path.GetTempPath()+ Path.GetFileName(FlagsType+"RefreshDatalayout1.xml");
if (FlagsType == "")
ec.UID = "RefreshDatalayout1";
else
ec.UID = FlagsType + "RefreshDatalayout1";
}
if (types2 == "10")
{
conn = " DY>0 and 10>=DY " + con;
list = Services.BaseService.GetList<Line_Info>("SelectLine_InfoByConn", conn);
CalcTotal(ref list);
//filepath1 = Path.GetTempPath()+ Path.GetFileName(FlagsType+"RefreshDatalayout1.xml"); //filepath1 = Path.GetTempPath()+ Path.GetFileName(FlagsType + "RefreshDatalayout2.xml");
if (FlagsType == "")
ec.UID = "RefreshDatalayout2";
else
ec.UID = FlagsType + "RefreshDatalayout2";
}
IList<Econ> listxml = Services.BaseService.GetList<Econ>("SelectEconByKey", ec);
//if (listxml.Count != 0)
//{
// MemoryStream ms = new MemoryStream(listxml[0].ExcelData);
// this.bandedGridView2.RestoreLayoutFromStream(ms);
//}
//if (types2 == "66")
//{ list = Services.BaseService.GetList<Line_Info>("SelectLine_InfoByFlagDy", li); }
//else if (types2 == "10")
//{ list = Services.BaseService.GetList<Line_Info>("SelectLine_InfoByFlagDy1", li); }
string s = " ProjectID='" + Itop.Client.MIS.ProgUID + "'";
IList list1 = Services.BaseService.GetList("SelectPS_Table_AreaWHByConn", s);
repositoryItemLookUpEdit1.DisplayMember = "Title";
repositoryItemLookUpEdit1.NullText = "";
repositoryItemLookUpEdit1.ValueMember = "ID";
repositoryItemLookUpEdit1.DataSource = list1;
//IList<Line_Info> list = Services.BaseService.GetList<Line_Info>("SelectLine_InfoByFlagDy", li);
this.gridControl.DataSource = list;
}
catch (Exception exc)
{
Debug.Fail(exc.Message);
HandleException.TryCatch(exc);
return false;
}
return true;
}
public void RefreshLayout()
{
try
{
string filepath1 = "";
Econ ec = new Econ();
if (types2 == "66")
{
//filepath1 = Path.GetTempPath()+ Path.GetFileName(FlagsType+"RefreshDatalayout1.xml");
if (FlagsType == "")
ec.UID = "RefreshDatalayout1";
else
ec.UID = FlagsType + "RefreshDatalayout1";
}
if (types2 == "10")
{
//filepath1 = Path.GetTempPath()+ Path.GetFileName(FlagsType + "RefreshDatalayout2.xml");
if (FlagsType == "")
ec.UID = "RefreshDatalayout2";
else
ec.UID = FlagsType + "RefreshDatalayout2";
}
IList<Econ> listxml = Services.BaseService.GetList<Econ>("SelectEconByKey", ec);
if (listxml.Count != 0)
{
MemoryStream ms = new MemoryStream(listxml[0].ExcelData);
this.bandedGridView2.RestoreLayoutFromStream(ms);
}
}
catch { }
}
public void RefreshLayout()
{
try
{
string filepath = "";
Econ ec = new Econ();
IList<Substation_Info> list = Services.BaseService.GetList<Substation_Info>("SelectSubstation_InfoByFlag", flags1);
if (xmlflag == "guihua")
ec.UID = xmltype;
else
{
ec.UID = xmltype + "SubstationLayOut";
}
IList<Econ> listxml = Services.BaseService.GetList<Econ>("SelectEconByKey", ec);
if (listxml.Count != 0)
{
MemoryStream ms = new MemoryStream(listxml[0].ExcelData);
this.bandedGridView1.RestoreLayoutFromStream(ms);
}
}
catch { }
}
/// <summary>
/// ˢ�±���е�����
/// </summary>
/// <returns>ture:�ɹ� false:ʧ��</returns>
public bool RefreshData1()
{
try
{
string filepath = "";
Econ ec = new Econ();
IList<Substation_Info> list = Services.BaseService.GetList<Substation_Info>("SelectSubstation_InfoByFlag", flags1);
if (xmlflag == "guihua")
ec.UID = xmltype;
else
{
ec.UID = xmltype + "SubstationLayOut";
}
IList<Econ> listxml = Services.BaseService.GetList<Econ>("SelectEconByKey", ec);
if (listxml.Count != 0)
{
MemoryStream ms = new MemoryStream(listxml[0].ExcelData);
this.bandedGridView1.RestoreLayoutFromStream(ms);
}
int i = 1;
foreach (Substation_Info info in list)
{
info.L23 = i.ToString();
i++;
double? l2 = info.L2;
double? l9 = info.L9;
double? l10 = info.L10;
try
{
if (l2 != 0)
{
l10 = l9 / l2;
info.L10 = l10;
}
}
catch { }
}
this.gridControl.DataSource = list;
}
catch (Exception exc)
{
Debug.Fail(exc.Message);
HandleException.TryCatch(exc);
return false;
}
return true;
}
private void InitData()
{
if (!isSelect)
{
switch (smmprog.ProgId)
{
case "64c9efcb-e6cc-402f-b2fc-f5f6f7d296f7":
progName = "�������Է���";
type = "fhtxfx";
break;
case "a50e1781-e470-4721-a6ee-c4b1294d6bd4":
progName = "������������";
type = "dwjcsj";
break;
case "3630adcc-9d4b-4059-b44e-4f88ccf76b43":
progName = "�����滮������";
type = "dwghjc";
break;
}
}
string s = " UID like '%|" + ProjectUID + "' and Col1='" + progName + "'";
ilist = Services.BaseService.GetList("SelectPspTypeListByWhere", s);
//ilist = Services.BaseService.GetList<PspType>();
dataTable = DataConverter.ToDataTable(ilist, typeof(PspType));
treeList1.DataSource = dataTable;
Econ ed = new Econ();
ed.UID = "yyy";
try
{
bts = Services.BaseService.GetOneByKey<Econ>(ed).ExcelData;
}
catch { }
}
private void button1_Click(object sender, EventArgs e)
{
Econ ec = new Econ();
ec.UID = "yyy";
System.IO.MemoryStream ms = new System.IO.MemoryStream();
try
{
fpSpread1.Save(ms, false);
ec.ExcelData = ms.GetBuffer();
Services.BaseService.Create<Econ>(ec);
//Services.BaseService.Update<Econ>(ec);
}
catch (Exception ex) { MsgBox.Show(ex.Message); }
}
private void InitData()
{
//if (!isSelect)
//{
// switch (smmprog.ProgId)
// {
// case "64c9efcb-e6cc-402f-b2fc-f5f6f7d296f7":
// progName = "�������Է���";
// type = "fhtxfx";
// break;
// case "a50e1781-e470-4721-a6ee-c4b1294d6bd4":
// progName = "������������";
// type = "dwjcsj";
// break;
// case "3630adcc-9d4b-4059-b44e-4f88ccf76b43":
// progName = "�����滮������";
// type = "dwghjc";
// break;
// }
//}
PspType pt = new PspType();
pt.Col1 = ProjectUID;
ilist = Services.BaseService.GetList("SelectPspTypeList", pt);
//ilist = Services.BaseService.GetList<PspType>();
dataTable = DataConverter.ToDataTable(ilist, typeof(PspType));
treeList1.DataSource = dataTable;
Econ ed = new Econ();
ed.UID = "Excel";
try
{
bts = Services.BaseService.GetOneByKey<Econ>(ed).ExcelData;
}
catch { }
}
