private void simpleButton2_Click(object sender, EventArgs e)
{
yearvalue = (int)spinEdit1.Value;
monthvalue = (int)spinEdit2.Value;
PSP_BigUser_Years biguseryear = new PSP_BigUser_Years();
// biguseryear.Year = yearvalue + "年" + monthvalue + "月";
biguseryear.Year = monthvalue.ToString();
biguseryear.Flag = flag;
biguseryear.ItemID = itemid;
try
{
if (Common.Services.BaseService.GetObject("SelectPSP_BigUser_YearsByYearFlag", biguseryear) == null)
{
try
{
Common.Services.BaseService.Create <PSP_BigUser_Years>(biguseryear);
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MsgBox.Show("出错啦：" + ex.Message);
}
}
else
{
MsgBox.Show("此年月份已经存在，请重新输入！");
}
}
catch
{
}
}
private void simpleButton2_Click(object sender, EventArgs e)
{
yearvalue = (int)spinEdit1.Value;
monthvalue = (int)spinEdit2.Value;
PSP_BigUser_Years biguseryear = new PSP_BigUser_Years();
// biguseryear.Year = yearvalue + "��" + monthvalue + "��";
biguseryear.Year = monthvalue.ToString();
biguseryear.Flag = flag;
biguseryear.ItemID = itemid;
try
{
if (Common.Services.BaseService.GetObject("SelectPSP_BigUser_YearsByYearFlag", biguseryear) == null)
{
try
{
Common.Services.BaseService.Create<PSP_BigUser_Years>(biguseryear);
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MsgBox.Show("��������" + ex.Message);
}
}
else
{
MsgBox.Show("�����·��Ѿ����ڣ����������룡");
}
}
catch
{
}
}
private void LoadData()
{
string baseyear = "";
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
PSP_BigUser_Types psp_Type = new PSP_BigUser_Types();
psp_Type.S2 = "S2 LIKE '%" + typeFlag + "%' and ItemID='" + ItemID+"'";
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_BigUser_TypesByItemID", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_BigUser_Types));
treeList1.DataSource = dataTable;
treeList1.Columns["Title"].Caption = "�����";
treeList1.Columns["Title"].Width = 180;
treeList1.Columns["Title"].OptionsColumn.AllowEdit = false;
treeList1.Columns["Title"].OptionsColumn.AllowSort = false;
treeList1.Columns["Flag"].VisibleIndex = -1;
treeList1.Columns["Flag"].OptionsColumn.ShowInCustomizationForm = false;
treeList1.Columns["Flag2"].VisibleIndex = -1;
treeList1.Columns["Flag2"].OptionsColumn.ShowInCustomizationForm = false;
treeList1.Columns["S1"].VisibleIndex = -1;
treeList1.Columns["S1"].OptionsColumn.ShowInCustomizationForm = false;
treeList1.Columns["S2"].VisibleIndex = -1;
treeList1.Columns["S2"].OptionsColumn.ShowInCustomizationForm = false;
treeList1.Columns["S3"].VisibleIndex = -1;
treeList1.Columns["S3"].OptionsColumn.ShowInCustomizationForm = false;
treeList1.Columns["S4"].VisibleIndex = -1;
treeList1.Columns["S4"].OptionsColumn.ShowInCustomizationForm = false;
treeList1.Columns["S5"].VisibleIndex = -1;
treeList1.Columns["S5"].OptionsColumn.ShowInCustomizationForm = false;
treeList1.Columns["ItemID"].VisibleIndex = -1;
treeList1.Columns["ItemID"].OptionsColumn.ShowInCustomizationForm = false;
PSP_BigUser_Years psp_Year = new PSP_BigUser_Years();
IList<PSP_BigUser_Years> listYears;
psp_Year.Flag = typeFlag;
psp_Year.ItemID= ItemID;
listYears = Common.Services.BaseService.GetList<PSP_BigUser_Years>("SelectPSP_BigUser_YearsListByFlag", psp_Year);
foreach (PSP_BigUser_Years item in listYears)
{
AddColumn(item.Year);
}
Application.DoEvents();
LoadValues(true);
treeList1.ExpandAll();
}
private void InsertSubstation_Info()
{
string columnname = "";
try
{
DataTable dts = new DataTable();
OpenFileDialog op = new OpenFileDialog();
op.Filter = "Excel�ļ�(*.xls)|*.xls";
if (op.ShowDialog() == DialogResult.OK)
{
WaitDialogForm wait = new WaitDialogForm("", "���ڵ�������, ���Ժ�...");
dts = GetExcel(op.FileName);
//DateTime s8 = DateTime.Now;
for (int i = 0; i < dts.Rows.Count; i++)
{
PSP_BigUser_Values l1 = new PSP_BigUser_Values();
int treelistid=0;
if (dts.Rows[i]["Title"] != null)
if(dts.Rows[i]["Title"].ToString()!="")
{
PSP_BigUser_Types psp_Type = new PSP_BigUser_Types();
PSP_BigUser_Types psp_Type2 = new PSP_BigUser_Types();
psp_Type.Title = dts.Rows[i]["Title"].ToString();
psp_Type.ItemID = ItemID;
if (Common.Services.BaseService.GetObject("SelectPSP_BigUser_TypesByTitleItemID", psp_Type) == null)
{
psp_Type.S2 = typeFlag.ToString();
Common.Services.BaseService.Create("InsertPSP_BigUser_Types", psp_Type);
}
else
{
psp_Type2 = (PSP_BigUser_Types)Common.Services.BaseService.GetObject("SelectPSP_BigUser_TypesByTitleItemID", psp_Type);
if (!psp_Type2.S2.Contains(typeFlag.ToString()))
{
psp_Type.ID = psp_Type2.ID;
if (psp_Type2.S2 != "")
psp_Type.S2 = psp_Type2.S2 + "," + typeFlag.ToString();
Common.Services.BaseService.Update<PSP_BigUser_Types>(psp_Type);
}
}
psp_Type = (PSP_BigUser_Types)Common.Services.BaseService.GetObject("SelectPSP_BigUser_TypesByTitleItemID", psp_Type);
if(psp_Type!=null)
treelistid=psp_Type.ID;
}
foreach (DataColumn dc in dts.Columns)
{
columnname = dc.ColumnName;
if (dts.Rows[i][dc.ColumnName].ToString() == "")
continue;
PSP_BigUser_Years biguseryear = new PSP_BigUser_Years();
if (columnname != "Title")
{
biguseryear.Year = columnname ;
biguseryear.Flag = typeFlag;
biguseryear.ItemID = ItemID;
if (Common.Services.BaseService.GetObject("SelectPSP_BigUser_YearsByYearFlag", biguseryear) == null)
{
Common.Services.BaseService.Create<PSP_BigUser_Years>(biguseryear);
// AddColumn(columnname);
}
}
switch (dc.ColumnName)
{
case "Title":
break;
default:
double LL2 = 0;
try
{
LL2 = Convert.ToDouble(dts.Rows[i][dc.ColumnName].ToString());
if (columnname != "Title")
{
l1.Value= LL2;
l1.ItemID=ItemID;
l1.TypeID=treelistid;
l1.Flag2=typeFlag;
l1.Year= columnname;
Common.Services.BaseService.Update<PSP_BigUser_Values>(l1);
}
}
catch { }
break;
}
}
}
wait.Close();
//foreach (Substation_Info lwl in lii)
//{
// Substation_Info l1 = new Substation_Info();
// // l1.AreaName = lwl.AreaName;
// l1.Title = lwl.Title;
// l1.Flag = lwl.Flag;
// //l1.L1 = lwl.L1;
// object obj = Services.BaseService.GetObject("SelectSubstation_InfoByTitleFlag", l1);
// if (obj != null)
// {
// lwl.UID = ((Substation_Info)obj).UID;
// lwl.Code = ((Substation_Info)obj).Code;
// Services.BaseService.Update("UpdateSubstation_InfoAreaName", lwl);
// }
// else
// {
// Services.BaseService.Create<Substation_Info>(lwl);
// }
//}
//this.ctrlSubstation_Info_TongLing1.RefreshData1();
wait = new WaitDialogForm("", "���ڼ�������, ���Ժ�...");
this.Cursor = Cursors.WaitCursor;
LoadData();
this.Cursor = Cursors.Default;
wait.Close();
}
}
catch (Exception ex) { MsgBox.Show(columnname + ex.Message); MsgBox.Show("�����ʽ����ȷ��"); }
}
