Beispiel #1
0
        private void InitComboBoxData()
        {
            IList<sd_gtsb> list = Client.ClientHelper.PlatformSqlMap.GetListByWhere<sd_gtsb>("where gtid in(select gtid from sd_gt where linecode in (select linecode from sd_xl where OrgCode='" + rowData.OrgID + "'))");
            foreach (sd_gtsb pt in list)
            {
                comboBoxEdit5.Properties.Items.Add(pt.sbName);
                comboBoxEdit2.Properties.Items.Add(pt.sbType);
                comboBoxEdit1.Properties.Items.Add(pt.sbModle);
            }
            ComboBoxHelper.FillCBoxByDyk("送电电力安全工具试验记录", "工具名称", comboBoxEdit5.Properties);
           // ComboBoxHelper.FillCBoxByDyk("14电力安全工具试验记录", "编号", comboBoxEdit3.Properties);
            ComboBoxHelper.FillCBoxByDyk("送电电力安全工具试验记录", "试验周期", comboBoxEdit7.Properties);
           // ComboBoxHelper.FillCBoxByDyk("14电力安全工具试验记录", "试验项目", comboBoxEdit4.Properties);
            IList<PJ_dyk> dic = new List<PJ_dyk>();
            PJ_dyk di = new PJ_dyk();
            di.nr = "工频耐压";
            
            dic.Add(di);
            di = new PJ_dyk();
            di.nr = "绝缘电阻";
            dic.Add(di);
            di = new PJ_dyk();
            di.nr = "成组绝缘电阻";
            dic.Add(di);
            di = new PJ_dyk();
            di.nr = "直流电阻";
            dic.Add(di);

            ////this.InitionData(this.cltOrderState, "DicItemCnName", "DicItemCode", "请选择", "类型名称", dic);
            this.InitionData(this.comboBoxEdit4, "nr", "nr", "请选择", "实验项目", dic);

          }
Beispiel #2
0
        void ucTop_AfterEdit(PJ_dyk obj)
        {
            //ucBottom.ParentObj = obj;
            //splitCC1.Panel2.Text = "内容所在类别:" + (obj != null ? obj.dx : "");
            Client.ClientHelper.PlatformSqlMap.GetList("SelectOneStr", string.Format("UPDATE  dbo.PJ_dyk SET dx='{0}',sx='{1}' WHERE ParentID='{2}'", obj.dx, obj.sx, obj.ID));

            ucBottom.ParentObj = obj;
        }
Beispiel #3
0
        void btnOK_Click(object sender, EventArgs e)
        {
            List<string> list = new List<string>();
            List<PJ_dyk> list2 = new List<PJ_dyk>();
            this.getCheckList(this.treeList1.Nodes, list);
            long xhidex = 0;
            IList<PJ_dyk> li = MainHelper.PlatformSqlMap.GetList<PJ_dyk>("SelectPJ_dykList", " where ParentID='" + parentObj.bh + "'  order by id desc");
            if (li.Count > 0)
                xhidex = (Convert.ToInt64(li[0].bh) + 1);
            else
            {
                xhidex = (Convert.ToInt64(parentObj.bh) * 100 + 1);
            }
            foreach (string str in list)
            {
                PJ_dyk dyk = new PJ_dyk();
                TreeListNode td = treeList1.FindNodeByKeyID(str);



                dyk.ID = Convert.ToString(xhidex);
                dyk.bh = dyk.ID;
                xhidex++;
                Thread.Sleep(new TimeSpan(100000));//0.1毫秒
                dyk.ParentID = parentObj.ID;
                dyk.dx = parentObj.dx;
                dyk.nr = td["nr"].ToString();
                dyk.sx = td["sx"].ToString();
                list2.Add(dyk);
            }
            try
            {
                List<SqlQueryObject> list3 = new List<SqlQueryObject>();
                if (list2.Count > 0)
                {
                    SqlQueryObject obj3 = new SqlQueryObject(SqlQueryType.Insert, list2.ToArray());
                    list3.Add(obj3);
                }

                MainHelper.PlatformSqlMap.ExecuteTransationUpdate(list3);
            }
            catch (Exception exception)
            {
                MainHelper.ShowWarningMessageBox(exception.Message);
               
            }
            this.DialogResult = DialogResult.OK;
        }
Beispiel #4
0
 void ucTop_FocusedRowChanged(object sender, PJ_dyk obj) {
     ucBottom.ParentObj = obj;
     splitCC1.Panel2.Text = "内容所在类别:" + (obj != null ? obj.dx : "");
 }
Beispiel #5
0
        void gridViewOperation_AfterAdd(PJ_dyk obj)
        {
            //if (obj.bh != "")
            //{
            //    //obj.ID = obj.bh;
            //    Client.ClientHelper.PlatformSqlMap.GetList("SelectOneStr", string.Format("UPDATE  dbo.PJ_dyk SET ID='{0}' WHERE ID='{1}'", obj.bh, obj.ID));
            //    obj.ID = obj.bh;

            //}
            //if (parentObj != null)
            //    RefreshData(" where parentid='" + parentObj.ID + "'");
        }
Beispiel #6
0
 /// <summary>
 /// 新建对象设置Key值
 /// </summary>
 /// <param name="newobj"></param>
 void gridViewOperation_CreatingObjectEvent(PJ_dyk newobj)
 {
     newobj.ParentID = parentID;
     if (parentObj != null)
     {
         newobj.sx = parentObj.sx;
         newobj.dx = parentObj.dx;
     }
     else
     {
         PJ_dyk temp = gridView1.GetFocusedRow() as PJ_dyk;
         if (temp != null)
         {
             newobj.dx = temp.dx;
         }
         //var bh = MainHelper.PlatformSqlMap.GetObject("SelectOneInt", "select cast(max(bh) as int) + 1 from pj_dyk where dx='" + newobj.dx + "' and len(bh)=6");
         //if (bh != null)
         //{
         //    string str_bh = "";
         //    for (int i = 0; i < 6 - bh.ToString().Length; i++)
         //    {
         //        str_bh += "0";
         //    }
         //    newobj.bh = str_bh + bh;
         //}
         //else
         //{
         //    var bh1 = MainHelper.PlatformSqlMap.GetObject("SelectOneInt", "select cast(max(bh) as int) + 1 from pj_dyk where len(bh)=6");
         //    string str_bh = "";
         //    for (int i = 0; i < 6 - bh1.ToString().Length; i++)
         //    {
         //        str_bh += "0";
         //    }
         //    newobj.bh = str_bh + bh1;
         //}
         if (!string.IsNullOrEmpty(zjm))
             newobj.zjm = zjm;
         
     }
 }
Beispiel #7
0
        void gridViewOperation_AfterEdit(PJ_dyk obj)
        {
            //if (obj.bh != "" && obj.bh != obj.ID)
            //{
            //    //obj.ID = obj.bh;
            //    Client.ClientHelper.PlatformSqlMap.GetList("SelectOneStr", string.Format("UPDATE  dbo.PJ_dyk SET ParentID='{0}' WHERE ParentID='{1}'", obj.bh, obj.ID));

            //    Client.ClientHelper.PlatformSqlMap.GetList("SelectOneStr", string.Format("UPDATE  dbo.PJ_dyk SET ID='{0}', bh='{1}' WHERE ID='{2}'", obj.bh, obj.bh, obj.ID));
            //    obj.ID = obj.bh;
            //    MainHelper.PlatformSqlMap.Update<PJ_dyk>(obj);
            //}
        }
Beispiel #8
0
 private void btnOK_Click(object sender, EventArgs e)
 {
     if (ceQuick.Visible && ceQuick.Checked)
     {
         string[] nr = rowData.nr.Split(new string[] { "\r\n" },StringSplitOptions.None);
         string[] nr2 = rowData.nr2.Split(new string[] { "\r\n" },StringSplitOptions.None);
         string[] nr3 = rowData.nr3.Split(new string[] { "\r\n" },StringSplitOptions.None);
         string[] nr4 = rowData.nr4.Split(new string[] { "\r\n" }, StringSplitOptions.None);
         long index = Convert.ToInt64(rowData.ID);
         IList<PJ_dyk> li = MainHelper.PlatformSqlMap.GetList<PJ_dyk>("SelectPJ_dykList", " where ParentID='" + rowData.ParentID + "'  order by id desc");
         if (li.Count > 0)
             index = (Convert.ToInt64(li[0].bh) );
         else
         {
             index = (Convert.ToInt64(rowData.ParentID) * 100 + 1);
         }
         rowData.nr = nr[0];
         rowData.nr2 = nr2[0];
         rowData.nr3 = nr3[0];
         rowData.nr4 = nr4[0];
         for (int i = 1; i < nr.Length; i++)
         {
             if (nr[i] == "") continue;
             PJ_dyk dyk = new PJ_dyk();
             dyk.ID = (index + i).ToString();
             dyk.dx = rowData.dx;
             dyk.sx = rowData.sx;
             dyk.bh = dyk.ID;
             dyk.nr = nr[i];
             dyk.ParentID = rowData.ParentID;
             if ( nr2.Length >i) dyk.nr2 = nr2[i];
             if (nr3.Length > i) dyk.nr3 = nr3[i];
             if (nr4.Length > i) dyk.nr4 = nr4[i];
             MainHelper.PlatformSqlMap.Create<PJ_dyk>(dyk);
         }
     }
 }
 /// <summary>
 /// 新建对象设置Key值
 /// </summary>
 /// <param name="newobj"></param>
 void gridViewOperation_CreatingObjectEvent(PJ_dyk newobj) {
     newobj.ParentID = parentID;
     if (parentObj != null) {
         newobj.sx = parentObj.sx;
         newobj.dx = parentObj.dx;
     }
 }