void gridViewOperation_AfterDelete(PJ_18gysbpjmx obj) { IList<PJ_18gysbpjmx> list = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PJ_18gysbpjmx>(" where PJ_ID='" + PSObj.PJ_ID + "' order by xh "); List<PJ_18gysbpjmx> list2 = new List<PJ_18gysbpjmx>(); for (int i = 0; i < list.Count; i++) { list[i].xh = i; } list2.AddRange (list); try { List<SqlQueryObject> list3 = new List<SqlQueryObject>(); if (list.Count > 0) { SqlQueryObject obj3 = new SqlQueryObject(SqlQueryType.Update, list2.ToArray()); list3.Add(obj3); } MainHelper.PlatformSqlMap.ExecuteTransationUpdate(list3); RefreshData(" where PJ_ID='" + PSObj.PJ_ID + "' order by xh "); } catch (Exception exception) { MainHelper.ShowWarningMessageBox(exception.Message); } }
private bool save() { int begin = comboBoxEdit10.SelectedIndex; int end = comboBoxEdit11.SelectedIndex; bool flag = true; if(begin>end){ MsgBox.ShowWarningMessageBox("启始杆号不能大于终止杆号!"); flag = false; goto ret; } if (begin == -1) { MsgBox.ShowTipMessageBox("请选择启始杆号!"); flag = false; goto ret; } if (end == -1) { MsgBox.ShowTipMessageBox("请选择终止杆号!"); flag = false; goto ret; } if (MsgBox.ShowAskMessageBox(string.Format("删除{0}-{1}的所有{2},确定吗?",gtlist[begin].Gt.gth, gtlist[end].Gt.gth, mtype)) == DialogResult.OK) { List<string> list = new List<string>(); for (int i = begin; i <= end; i++) { PS_gt gt = gtlist[i].Gt; list.Add("'" + gt.gtID + "'"); } SqlQueryObject so1 = new SqlQueryObject(SqlQueryType.Delete, "Delete", "delete from ps_gt where gtid in ("+string.Join(",",list.ToArray())+")"); List<SqlQueryObject> listso = new List<SqlQueryObject>(); if (mtype == "杆塔") { listso.Add(so1); } SqlQueryObject so2 = new SqlQueryObject(SqlQueryType.Delete, "Delete", "delete from ps_gtsb where gtid in (" + string.Join(",", list.ToArray()) + ")"); listso.Add(so2); try { ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(listso); } catch { flag = false; } } else { flag = false; } ret: return flag; }
private void RemoveMoudle_Click(object sender, EventArgs e) { if (gridView1.FocusedRowHandle <0) return; try { DataRow udr = gridView1.GetDataRow(gridView1.FocusedRowHandle); if (udr == null) return; string umid = udr["ID"].ToString(); //mModule obj = MainHelper.PlatformSqlMap.GetOneByKey<mModule>(udr["mMouleID"]); //mUserModule um = new mUserModule(); //um.mMouleID = obj.Modu_ID; //DataRow dr = mdt.NewRow(); //dr["Modu_ID"] = obj.Modu_ID ; //dr["ModuName"] = obj.ModuName; //dr["ParentID"] = obj.ParentID; //mdt.Rows.Add(dr); udt.Rows.Remove(udr); MainHelper.PlatformSqlMap.DeleteByKey<mUserModule>(umid); IList<mUserModule> il = MainHelper.PlatformSqlMap.GetList<mUserModule>("SelectmUserModuleList", "where UserID='" + MainHelper.User.UserID + "' order by SortID"); for (int i = 0; i < il.Count; i++) { il[i].SortID = i + 1; } SqlQueryObject obj3 = new SqlQueryObject(SqlQueryType.Update,"UpdatemUserModule", il); List<SqlQueryObject> list3 = new List<SqlQueryObject>(); list3.Add(obj3); MainHelper.PlatformSqlMap.ExecuteTransationUpdate(list3); desk.iniUsualCtrl(); treeList1.Refresh(); } catch (Exception ex) { Console.WriteLine(ex.Message); } }
void copyData(LP_Temple lp, IList<LP_Temple> templeList) { if (templeList.Count == 0) return; string flowid = lp.ParentID; int i = 1; List<LP_Temple> list = new List<LP_Temple>(); string workflowid = flowid; IList<WF_WorkTask> wftli = MainHelper.PlatformSqlMap.GetList<WF_WorkTask>("SelectWF_WorkTaskList", "where WorkFlowId='" + workflowid + "' and TaskTypeId!='2' order by TaskTypeId"); foreach (WF_WorkTask wft in wftli) { //保存关联模块 WorkFlowTask.DeleteAllModle(wft.WorkTaskId); mModule mu = MainHelper.PlatformSqlMap.GetOne<mModule>("where ModuName='表单执行平台' and ModuTypes='Ebada.Scgl.Lcgl.frmLP'"); WorkFlowTask.SetTaskUserModle(mu.Modu_ID, wft.WorkFlowId, wft.WorkTaskId); //保存关联表单 WorkFlowTask.DeleteAllControls(wft.WorkTaskId); WorkFlowTask.DeleteAllTableField(wft.WorkFlowId, wft.WorkTaskId); string sqlStr = " where WorkTaskId='" + wft.WorkTaskId + "'"; MainHelper.PlatformSqlMap.DeleteByWhere<WF_WorkTaskControls>(sqlStr); WorkFlowTask.SetTaskUserCtrls(templeList[0].ParentID, workflowid, wft.WorkTaskId); } i = 1; foreach (LP_Temple obj in templeList) { obj.SortID = i; if (obj.SignImg == null) { obj.SignImg = new byte[0]; } if (obj.ImageAttachment == null) { obj.ImageAttachment = new byte[0]; } if (obj.DocContent == null) { obj.DocContent = new byte[0]; } i++; if (obj.CellName == "6.3 其他安全措施和注意事项" && obj.Status == "") { obj.Status = "填票"; } if (obj.CellName.IndexOf("终了时间") > -1) { obj.WordCount = "dd日 HH:mm"; } else if (obj.CellName.IndexOf("同意执行时间") > -1) { obj.WordCount = "MM-dd日 HH:mm"; } else if (obj.CellName.IndexOf("时间") > -1) { obj.WordCount = "yyyy-MM-dd HH:mm"; } if (obj.SqlSentence == "SelectmOrgList where parentid='0'") { obj.SqlSentence = "Select OrgName from mOrg where parentid='0'"; obj.SqlColName = ""; } if (obj.SqlSentence.IndexOf("SelectmUserList where OrgName ='@1'") > -1) { obj.SqlSentence = "Select UserName from mUser where OrgName='{1}'"; obj.SqlColName = ""; } if (lp.CellName == "电力线路第一种工作票") { //if (obj.KindTable == "") { obj.KindTable = "工作票"; } } if (lp.CellName == "电力线路第二种工作票") { //if (obj.KindTable == "") { obj.KindTable = "Sheet1"; } } if (lp.CellName == "电力线路倒闸操作票") { //if (obj.KindTable == "") { obj.KindTable = "Sheet1"; } } if (lp.CellName == "电力线路事故应急抢修单") { if (obj.KindTable == "") { obj.KindTable = "Sheet1"; } } if (obj.SqlSentence == "SelectmOrgList where parentid=(select OrgID From mOrg where OrgName='@1')") //if (obj.SqlSentence == "Select OrgName from mOrg where parentid=(select OrgID From mOrg where OrgName={1})") { obj.SqlSentence = "Select OrgName from mOrg where parentid=(select OrgID From mOrg where OrgName='{1}')"; obj.SqlColName = ""; } WF_WorkTask wt = MainHelper.PlatformSqlMap.GetOne<WF_WorkTask>( "where WorkFlowId='" + workflowid + "' and TaskCaption='" + obj.Status + "'"); if (wt == null) { continue; } WF_TableUsedField tuf = MainHelper.PlatformSqlMap.GetOne<WF_TableUsedField>("where FieldName='" + obj.CellName + "' and UserControlId='" + obj.ParentID + "'"); if (tuf == null) { WF_TableUsedField um = new WF_TableUsedField(); um.ID = um.CreateID(); um.UserControlId = obj.ParentID; um.FieldName = obj.CellName; um.FieldId = obj.LPID; um.WorkflowId = workflowid; um.WorktaskId = wt.WorkTaskId; Thread.Sleep(new TimeSpan(100000));//0.1毫秒 MainHelper.PlatformSqlMap.Create<WF_TableUsedField>(um); } list.Add(obj); } List<SqlQueryObject> list3 = new List<SqlQueryObject>(); if (list.Count > 0) { SqlQueryObject obj3 = new SqlQueryObject(SqlQueryType.Update, list.ToArray()); list3.Add(obj3); } MainHelper.PlatformSqlMap.ExecuteTransationUpdate(list3); }
public void ExportExceljhbAllSubmitToWF_ModleRecordWorkTaskIns(DateTime dt,DateTime dt2, string orgid) { string filter = ""; int i = 0; if (orgid != "") filter = " and OrgCode='" + orgid + "'"; string startday = "20"; IList list = Client.ClientHelper.PlatformSqlMap.GetList("SelectOneStr", string.Format("select nr from pj_dyk where dx='所月度停电计划' and sx like '%{0}%' and nr!=''", "申报截止日期")); if (list.Count > 0) startday = list[0].ToString(); filter = " where (TDtime between '" + dt.Year + "-" + dt.Month + "-" + dt.Day + " 00:00:00' and '" + dt2.Year + "-" + dt2.Month + "-" + dt2.Day + " 23:59:59' ) "; if (orgid != "") filter += " and OrgCode='" + orgid + "'"; if (isWorkflowCall) { filter = filter + " and (id not in (select ModleRecordID from WF_ModleRecordWorkTaskIns where WorkFlowInsId='" + WorkFlowData.Rows[0]["WorkFlowInsId"].ToString() + "') " + " or id in (select ModleRecordID from WF_ModleRecordWorkTaskIns where " + " RecordID='" + currRecord.ID + "')) " ; } IList<PJ_tdjh> datalist = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PJ_tdjh>( filter ); List<WF_ModleRecordWorkTaskIns> mrwtlist = new List<WF_ModleRecordWorkTaskIns>(); if (isWorkflowCall) { for (i = 0; i < datalist.Count; i++) { WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ID = mrwt.CreateID(); mrwt.ModleRecordID = datalist[i].ID; mrwt.RecordID = currRecord.ID; mrwt.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString(); mrwt.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); mrwt.ModleTableName = datalist[i].GetType().ToString(); mrwt.CreatTime = DateTime.Now; Thread.Sleep(new TimeSpan(100000));//0.1毫秒 mrwtlist.Add(mrwt); } } List<SqlQueryObject> list3 = new List<SqlQueryObject>(); if (mrwtlist.Count > 0) { SqlQueryObject obj3 = new SqlQueryObject(SqlQueryType.Insert, mrwtlist.ToArray()); list3.Add(obj3); } MainHelper.PlatformSqlMap.ExecuteTransationUpdate(list3); }
void gridViewOperation_AfterDelete(PJ_yfsyjl obj) { IList<PJ_yfsyjl> li = MainHelper.PlatformSqlMap.GetListByWhere<PJ_yfsyjl>(" where OrgCode='" + obj.OrgCode + "' and type='" + obj.type + "' order by xh"); int i = 1; List<PJ_yfsyjl> list = new List<PJ_yfsyjl>(); foreach (PJ_yfsyjl ob in li) { ob.xh = i; i++; list.Add(ob); } List<SqlQueryObject> list3 = new List<SqlQueryObject>(); if (list.Count > 0) { SqlQueryObject obj3 = new SqlQueryObject(SqlQueryType.Update, list.ToArray()); list3.Add(obj3); } MainHelper.PlatformSqlMap.ExecuteTransationUpdate(list3); RefreshData(" where OrgCode='" + obj.OrgCode + "' and type='" + obj.type + "' and (planExpTime like '%" + DateTime.Now.Year + "%' or planExpTime like '%" + DateTime.Now.Year + 1 + "%') "); }
public string UpdateGtOne(bd_sb data) { BD_SBTZ gt = Ebada.Client.ClientHelper.PlatformSqlMap.GetOneByKey<BD_SBTZ>(data.sbid); if (gt != null) { if (!string.IsNullOrEmpty(data.jsonData2)) { Console.WriteLine("data.jsonData2;\r\n"+data.jsonData2); List<bd_sbsxz> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<bd_sbsxz>>(data.jsonData2); if (list != null) { Type t = gt.GetType(); gt.sbname = data.sbmc; foreach (var sx in list) { t.GetProperty(sx.k).SetValue(gt, sx.v,null); } int n=Client.ClientHelper.PlatformSqlMap.Update<BD_SBTZ>(gt); ncount += n>0?n:0; } } if (!string.IsNullOrEmpty(data.jsonData)) { Console.WriteLine("data.jsonData;\r\n" + data.jsonData); List<ps_gtsb> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ps_gtsb>>(data.jsonData); if (list != null) { List<SqlQueryObject> sqllist = new List<SqlQueryObject>(); SqlQueryObject sqo = new SqlQueryObject(SqlQueryType.Delete, "Delete", "delete from bd_sbtz_fssb where gtid='" + gt.sb_id + "'"); sqllist.Add(sqo); int num = 0; foreach (ps_gtsb sb in list) { num++; bd_sbtz_fssb gtsb = new bd_sbtz_fssb() { gtID = gt.sb_id, sbModle = sb.xh, sbType = sb.zldm, sbNumber = short.Parse(sb.sl), sbName = sb.zl, sbCode = num.ToString("000") }; gtsb.sbID = gt.sb_id + num.ToString("000"); sqo = new SqlQueryObject(SqlQueryType.Insert, gtsb); sqllist.Add(sqo); } Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(sqllist); } //Console.WriteLine(list != null ? list.Count : 0); } //Console.WriteLine("update {0} count {1}", gt.gtCode, n); } return ""; }
public void ExportExceljhbAllSubmitToWF_ModleRecordWorkTaskIns(string orgid, string strProject, string strfenProject) { string filter = ""; int i = 0; List<WF_ModleRecordWorkTaskIns> mrwtlist = new List<WF_ModleRecordWorkTaskIns>(); string strfirst = ""; string filter2 = ""; string filter3 = ""; string filter4 = ""; if (strProject != "全部") filter2 = " where 1=1 and ssgc='" + strProject + "' and type = '撤旧材料出库单' "; else filter2 = " where 1=1 and type = '撤旧材料出库单' "; IList mclist = ClientHelper.PlatformSqlMap.GetList("SelectOneStr", "select distinct ssgc from PJ_clcrkd " + filter2 + " order by ssgc"); foreach (string mc in mclist) { if (strfenProject == "全部") filter3 = " where 1=1 and type = '撤旧材料出库单' "; else filter3 = " where ssxm='" + strfenProject + "' and type = '撤旧材料出库单' "; IList xmlist = ClientHelper.PlatformSqlMap.GetList("SelectOneStr", "select distinct ssxm from PJ_clcrkd " + filter3 + " order by ssxm"); foreach (string xm in xmlist) { filter4 = " where 1=1 and type = '撤旧材料出库单'" + " and ssgc='" + mc + "' " + " and ssxm='" + xm + "' "; //IList sjlist = ClientHelper.PlatformSqlMap.GetList("SelectOneStr", "select distinct CONVERT(varchar(50) ,indate, 112 ) from PJ_clcrkd " + filter4 + " "); IList sjlist = ClientHelper.PlatformSqlMap.GetList("SelectOneStr", "select distinct num from PJ_clcrkd " + filter4 + " "); foreach (string sj in sjlist) { filter = " where 1=1 and type = '撤旧材料出库单'" + " and ssgc='" + mc + "' " + " and ssxm='" + xm + "' and num= '" + sj + "' "; if (isWorkflowCall) { filter = filter + " and id not in (select ModleRecordID from WF_ModleRecordWorkTaskIns where WorkFlowId='" + WorkFlowData.Rows[0]["WorkFlowId"].ToString() + "') " + " or id in (select ModleRecordID from WF_ModleRecordWorkTaskIns where " + " RecordID='" + currRecord.ID + "') " ; } IList<PJ_clcrkd> datalist = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PJ_clcrkd>( filter ); if (isWorkflowCall) { for (i = 0; i < datalist.Count; i++) { WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ID = mrwt.CreateID(); mrwt.ModleRecordID = datalist[i].ID; mrwt.RecordID = currRecord.ID; mrwt.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString(); mrwt.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); mrwt.ModleTableName = datalist[i].GetType().ToString(); mrwt.CreatTime = DateTime.Now; Thread.Sleep(new TimeSpan(100000));//0.1毫秒 mrwtlist.Add(mrwt); } } } } } List<SqlQueryObject> list3 = new List<SqlQueryObject>(); if (mrwtlist.Count > 0) { SqlQueryObject obj3 = new SqlQueryObject(SqlQueryType.Insert, mrwtlist.ToArray()); list3.Add(obj3); } MainHelper.PlatformSqlMap.ExecuteTransationUpdate(list3); }
void gridViewOperation_AfterDelete(PJ_yfsyjl obj) { if (isWorkflowCall) { MainHelper.PlatformSqlMap.DeleteByWhere<WF_ModleRecordWorkTaskIns>(" where ModleRecordID='" + obj.ID + "' and RecordID='" + currRecord.ID + "'" + " and WorkFlowId='" + WorkFlowData.Rows[0]["WorkFlowId"].ToString() + "'" + " and WorkFlowInsId='" + WorkFlowData.Rows[0]["WorkFlowInsId"].ToString() + "'" + " and WorkTaskId='" + WorkFlowData.Rows[0]["WorkTaskId"].ToString() + "'" + " and WorkTaskInsId='" + WorkFlowData.Rows[0]["WorkTaskInsId"].ToString() + "'"); } string slqwhere = " where OrgCode='" + obj.OrgCode + "' and type='" + obj.type + "' "; //if (isWorkflowCall) //{ // slqwhere = slqwhere + " and id in (select ModleRecordID from WF_ModleRecordWorkTaskIns where RecordID='" + CurrRecord.ID + "'"; // slqwhere = slqwhere + " and WorkFlowId='" + WorkFlowData.Rows[0]["WorkFlowId"].ToString() + "'" // + " and WorkFlowInsId='" + WorkFlowData.Rows[0]["WorkFlowInsId"].ToString() + "'" // + " and WorkTaskId='" + WorkFlowData.Rows[0]["WorkTaskId"].ToString() + "'" // + " and WorkTaskInsId='" + WorkFlowData.Rows[0]["WorkTaskInsId"].ToString() + "')"; //} slqwhere = slqwhere + " order by xh"; IList<PJ_yfsyjl> li = MainHelper.PlatformSqlMap.GetListByWhere<PJ_yfsyjl>(slqwhere); int i = 1; List<PJ_yfsyjl> list = new List<PJ_yfsyjl>(); foreach (PJ_yfsyjl ob in li) { ob.xh = i; i++; list.Add(ob); } List<SqlQueryObject> list3 = new List<SqlQueryObject>(); if (list.Count > 0) { SqlQueryObject obj3 = new SqlQueryObject(SqlQueryType.Update, list.ToArray()); list3.Add(obj3); } MainHelper.PlatformSqlMap.ExecuteTransationUpdate(list3); RefreshData(" where OrgCode='" + obj.OrgCode + "' and type='" + obj.type + "' "); }
public bool Save() { bool flag = true; List<string> list = new List<string>(); List<rRoleModul> list2 = new List<rRoleModul>(); //List<string> wflist1 = new List<string>(); List<WF_Operator> wflist2 = new List<WF_Operator>(); this.getCheckList(this.treeList1.Nodes, list); foreach (string str in list) { rRoleModul function = new rRoleModul(); function.RoleID = this.m_RoleID; function.Modu_ID = str; list2.Add(function); TreeListNode td = treeList1.FindNodeByKeyID(str); if (td["Description"].ToString () == "工作流") { WF_WorkTask wt = MainHelper.PlatformSqlMap.GetOneByKey<WF_WorkTask>(str); if (wt!= null) { mRole mrl = MainHelper.PlatformSqlMap.GetOneByKey<mRole>(RoleID); WF_Operator wfop = new WF_Operator(); wfop.OperatorId = Guid.NewGuid().ToString(); wfop.OperContent = RoleID; wfop.Description = mrl.RoleName; wfop.OperDisplay = mrl.RoleName; wfop.WorkFlowId = wt.WorkFlowId; wfop.WorkTaskId = wt.WorkTaskId; wfop.OperType = 5; wfop.InorExclude = true; wflist2.Add(wfop); } //wflist1.Add(" where WorkTaskId='" + str + "' and OperContent='" + RoleID + "'"); } } SqlQueryObject item = new SqlQueryObject(SqlQueryType.Delete, "DeleterRoleModulByWhere", "where RoleID='" + this.m_RoleID + "'"); SqlQueryObject item2 = new SqlQueryObject(SqlQueryType.Delete, "DeleteWF_OperatorInstanceByWhere", "where OperContent='" + this.m_RoleID + "'"); SqlQueryObject wfitem = new SqlQueryObject(SqlQueryType.Delete, "DeleteWF_OperatorByWhere", "where OperContent='" + this.m_RoleID + "'"); try { List<SqlQueryObject> list3 = new List<SqlQueryObject>(); list3.Add(item); list3.Add(item2); if (list2.Count>0) { SqlQueryObject obj3 = new SqlQueryObject(SqlQueryType.Insert, list2.ToArray()); list3.Add(obj3); } list3.Add(wfitem); if (wflist2.Count > 0) { SqlQueryObject wfobj3 = new SqlQueryObject(SqlQueryType.Insert, wflist2.ToArray()); list3.Add(wfobj3); } MainHelper.PlatformSqlMap.ExecuteTransationUpdate(list3); } catch (Exception exception) { MainHelper.ShowWarningMessageBox(exception.Message); flag = false; } return flag; }
private void IniWFData(string parentid) { List<mModule> list2 = new List<mModule>(); IList<WF_WorkFlowClass> wfcli = MainHelper.PlatformSqlMap.GetList<WF_WorkFlowClass>("SelectWF_WorkFlowClassList", "where clLevel='0' order by Caption"); foreach (WF_WorkFlowClass wfc in wfcli) { mModule md = new mModule(); md.Modu_ID = wfc.WFClassId; md.ModuName = wfc.Caption; md.ParentID = parentid; md.ModuTypes = "hide"; md.Description = "工作流"; list2.Add(md); IniWFTData(wfc.WFClassId,ref list2); ReWFData(wfc.WFClassId, ref list2); } SqlQueryObject obj3 = new SqlQueryObject(SqlQueryType.Update, "InsertWFmModule", list2.ToArray()); try { List<SqlQueryObject> list3 = new List<SqlQueryObject>(); list3.Add(obj3); MainHelper.PlatformSqlMap.ExecuteTransationUpdate(list3); } catch (Exception exception) { MainHelper.ShowWarningMessageBox(exception.Message); } }
void gridViewOperation_AfterDelete(LP_Temple obj) { string slqwhere = " where ParentID='" + obj.ParentID + "' "; slqwhere = slqwhere + " order by SortID"; IList<LP_Temple> li = MainHelper.PlatformSqlMap.GetListByWhere<LP_Temple>(slqwhere); int i = 1; List<LP_Temple> list = new List<LP_Temple>(); foreach (LP_Temple ob in li) { ob.SortID= i; if (ob.SignImg == null) { ob.SignImg = new byte[0]; } if (ob.ImageAttachment == null) { ob.ImageAttachment = new byte[0]; } if (ob.DocContent == null) { ob.DocContent = new byte[0]; } i++; list.Add(ob); } List<SqlQueryObject> list3 = new List<SqlQueryObject>(); if (list.Count > 0) { SqlQueryObject obj3 = new SqlQueryObject(SqlQueryType.Update, list.ToArray()); list3.Add(obj3); } MainHelper.PlatformSqlMap.ExecuteTransationUpdate(list3); inidata(); }
void gridViewOperation_BeforeInsert(object render, ObjectOperationEventArgs<LP_Temple> e) { //e.Value.Password = MainHelper.EncryptoPassword(e.Value.Password); string slqwhere = " where ParentID='" + e.Value.ParentID + "' and SortID =" + e.Value.SortID + " and lpid!='" + e.Value.LPID+"'"; IList<LP_Temple> li = MainHelper.PlatformSqlMap.GetListByWhere<LP_Temple>(slqwhere); if (li.Count > 0) { //li[0].SortID = e.ValueOld.SortID; //if (li[0].DocContent == null) //{ // li[0].DocContent = bt; //} //if (li[0].ImageAttachment == null) //{ // li[0].ImageAttachment = bt; //} //if (li[0].SignImg == null) //{ // li[0].SignImg = bt; //} //MainHelper.PlatformSqlMap.Update<LP_Temple>(li[0]); slqwhere = " where ParentID='" + e.Value.ParentID + "' and SortID>=" + e.ValueOld.SortID + " and lpid!='" + e.Value.LPID + "'"; slqwhere = slqwhere + " order by SortID"; li = MainHelper.PlatformSqlMap.GetListByWhere<LP_Temple>(slqwhere); int i = 1; List<LP_Temple> list = new List<LP_Temple>(); foreach (LP_Temple ob in li) { ob.SortID = ob.SortID + 1; if (ob.SignImg == null) { ob.SignImg = new byte[0]; } if (ob.ImageAttachment == null) { ob.ImageAttachment = new byte[0]; } if (ob.DocContent == null) { ob.DocContent = new byte[0]; } list.Add(ob); } List<SqlQueryObject> list3 = new List<SqlQueryObject>(); if (list.Count > 0) { SqlQueryObject obj3 = new SqlQueryObject(SqlQueryType.Update, list.ToArray()); list3.Add(obj3); MainHelper.PlatformSqlMap.ExecuteTransationUpdate(list3); } } }
private void barCopy_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { //请求确认 if (MsgBox.ShowAskMessageBox("是否确认复制去年计划生成今年计划 ?") != DialogResult.OK) { return; } IList<PJ_bpbjjhb> bjlist = Client.ClientHelper.PlatformSqlMap.GetList<PJ_bpbjjhb>("where orgcode='" + btGdsList.EditValue + "' AND jhnf='" + DateTime.Now.Year + "'"); List<PJ_bpbjjhb> list = new List<PJ_bpbjjhb>(); foreach (PJ_bpbjjhb bj in bjlist) { bj.ID = bj.CreateID(); bj.jhnf = (DateTime.Now.Year + 1).ToString(); Thread.Sleep(new TimeSpan(100000));//0.1毫秒 list.Add(bj); } List<SqlQueryObject> list3 = new List<SqlQueryObject>(); if (list.Count > 0) { SqlQueryObject obj3 = new SqlQueryObject(SqlQueryType.Insert, list.ToArray()); list3.Add(obj3); } MainHelper.PlatformSqlMap.ExecuteTransationUpdate(list3); RefreshData(" where OrgCode='" + parentID + "' "); }
void gridViewOperation_AfterDelete(PJ_18gysbpjmx obj) { if (isWorkflowCall) { MainHelper.PlatformSqlMap.DeleteByWhere<WF_ModleRecordWorkTaskIns>(" where ModleRecordID='" + obj.PJ_ID + "' and RecordID='" + currRecord.ID + "'" + " and WorkFlowId='" + WorkFlowData.Rows[0]["WorkFlowId"].ToString() + "'" + " and WorkFlowInsId='" + WorkFlowData.Rows[0]["WorkFlowInsId"].ToString() + "'" + " and WorkTaskId='" + WorkFlowData.Rows[0]["WorkTaskId"].ToString() + "'" + " and WorkTaskInsId='" + WorkFlowData.Rows[0]["WorkTaskInsId"].ToString() + "'"); } IList<PJ_18gysbpjmx> list = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PJ_18gysbpjmx>(" where PJ_ID='" + PSObj.PJ_ID + "' order by xh "); List<PJ_18gysbpjmx> list2 = new List<PJ_18gysbpjmx>(); for (int i = 0; i < list.Count; i++) { list[i].xh = i; } list2.AddRange(list); try { List<SqlQueryObject> list3 = new List<SqlQueryObject>(); if (list.Count > 0) { SqlQueryObject obj3 = new SqlQueryObject(SqlQueryType.Update, list2.ToArray()); list3.Add(obj3); } MainHelper.PlatformSqlMap.ExecuteTransationUpdate(list3); RefreshData(" where PJ_ID='" + PSObj.PJ_ID + "' order by xh "); } catch (Exception exception) { MainHelper.ShowWarningMessageBox(exception.Message); } }
protected override void OnLoad(EventArgs e) { base.OnLoad(e); InitColumns();//初始列 InitData();//初始数据 List<WF_Operator> wflist2 = new List<WF_Operator>(); IList<WF_WorkFlow> list = MainHelper.PlatformSqlMap.GetList<WF_WorkFlow>("SelectWF_WorkFlowList", "where FlowCaption like '%分析%'"); foreach (WF_WorkFlow wf in list) { IList<WF_WorkTask> list2 = MainHelper.PlatformSqlMap.GetList<WF_WorkTask>("SelectWF_WorkTaskList", "where WorkFlowId='" + wf.WorkFlowId + "' and TaskTypeId!='2' order by TaskTypeId"); foreach (WF_WorkTask wt in list2) { WF_Operator wfop = (WF_Operator)MainHelper.PlatformSqlMap.GetObject("SelectWF_OperatorList", "where WorkFlowId='" + wt.WorkFlowId + "' and WorkTaskId='" + wt.WorkTaskId + "' and OperContent='all'"); if (wfop == null) { wfop = new WF_Operator(); wfop.OperatorId = Guid.NewGuid().ToString(); wfop.OperContent = "all"; wfop.Description = "所有人"; wfop.OperDisplay = "所有人"; wfop.WorkFlowId = wt.WorkFlowId; wfop.WorkTaskId = wt.WorkTaskId; wfop.OperType = 5; wfop.InorExclude = true; wflist2.Add(wfop); } } } if (wflist2.Count > 0) { List<SqlQueryObject> list3 = new List<SqlQueryObject>(); SqlQueryObject wfobj3 = new SqlQueryObject(SqlQueryType.Insert, wflist2.ToArray()); list3.Add(wfobj3); MainHelper.PlatformSqlMap.ExecuteTransationUpdate(list3); } if (this.Site != null) return; btGdsList.Edit = DicTypeHelper.GdsDic; btGdsList.EditValueChanged += new EventHandler(btGdsList_EditValueChanged); if (MainHelper.UserOrg != null && MainHelper.UserOrg.OrgType == "1") {//如果是供电所人员,则锁定 btGdsList.EditValue = MainHelper.UserOrg.OrgCode; btGdsList.Edit.ReadOnly = true; } }
public void ExportExceljhbAllSubmitToWF_ModleRecordWorkTaskIns(string orgid) { string filter = ""; int i = 0; if (orgid != "") filter = " and OrgCode='" + orgid + "'"; if (isWorkflowCall) { filter = filter + " and (id not in (select ModleRecordID from WF_ModleRecordWorkTaskIns where " + " WorkFlowId='" + WorkFlowData.Rows[0]["WorkFlowId"].ToString() + "') " + " or id in (select ModleRecordID from WF_ModleRecordWorkTaskIns where " + " RecordID='" + currRecord.ID + "')) " ; } List<WF_ModleRecordWorkTaskIns> mrwtlist = new List<WF_ModleRecordWorkTaskIns>(); IList<PJ_yfsyjl> byqdatalist = Client.ClientHelper.PlatformSqlMap.GetList<PJ_yfsyjl>("SelectPJ_yfsyjlList", " where type='变压器' and planExpTime like '%" + DateTime.Now.Year + "%' " + filter + " order by xh "); if (isWorkflowCall) { for (i = 0; i < byqdatalist.Count; i++) { WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ID = mrwt.CreateID(); mrwt.ModleRecordID = byqdatalist[i].ID; mrwt.RecordID = currRecord.ID; mrwt.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString(); mrwt.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); mrwt.ModleTableName = byqdatalist[i].GetType().ToString(); mrwt.CreatTime = DateTime.Now; Thread.Sleep(new TimeSpan(100000));//0.1毫秒 mrwtlist.Add(mrwt); } } byqdatalist = Client.ClientHelper.PlatformSqlMap.GetList<PJ_yfsyjl>("SelectPJ_yfsyjlList", " where type='断路器' and planExpTime like '%" + DateTime.Now.Year + "%' " + filter + " order by xh "); if (isWorkflowCall) { for (i = 0; i < byqdatalist.Count; i++) { WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ID = mrwt.CreateID(); mrwt.ModleRecordID = byqdatalist[i].ID; mrwt.RecordID = currRecord.ID; mrwt.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString(); mrwt.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); mrwt.ModleTableName = byqdatalist[i].GetType().ToString(); mrwt.CreatTime = DateTime.Now; Thread.Sleep(new TimeSpan(100000));//0.1毫秒 mrwtlist.Add(mrwt); } } byqdatalist = Client.ClientHelper.PlatformSqlMap.GetList<PJ_yfsyjl>("SelectPJ_yfsyjlList", " where type='避雷器' and planExpTime like '%" + DateTime.Now.Year + "%' " + filter + " order by xh "); if (isWorkflowCall) { for (i = 0; i < byqdatalist.Count; i++) { WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ID = mrwt.CreateID(); mrwt.ModleRecordID = byqdatalist[i].ID; mrwt.RecordID = currRecord.ID; mrwt.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString(); mrwt.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); mrwt.ModleTableName = byqdatalist[i].GetType().ToString(); mrwt.CreatTime = DateTime.Now; Thread.Sleep(new TimeSpan(100000));//0.1毫秒 mrwtlist.Add(mrwt); } } byqdatalist = Client.ClientHelper.PlatformSqlMap.GetList<PJ_yfsyjl>("SelectPJ_yfsyjlList", " where type='电容器' and planExpTime like '%" + DateTime.Now.Year + "%' " + filter + " order by xh "); if (isWorkflowCall) { for (i = 0; i < byqdatalist.Count; i++) { WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ID = mrwt.CreateID(); mrwt.ModleRecordID = byqdatalist[i].ID; mrwt.RecordID = currRecord.ID; mrwt.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString(); mrwt.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); mrwt.ModleTableName = byqdatalist[i].GetType().ToString(); mrwt.CreatTime = DateTime.Now; Thread.Sleep(new TimeSpan(100000));//0.1毫秒 mrwtlist.Add(mrwt); } List<SqlQueryObject> list3 = new List<SqlQueryObject>(); if (mrwtlist.Count > 0) { SqlQueryObject obj3 = new SqlQueryObject(SqlQueryType.Insert, mrwtlist.ToArray()); list3.Add(obj3); } MainHelper.PlatformSqlMap.ExecuteTransationUpdate(list3); } }
public bool Save() { bool flag = true; List<string> list = new List<string>(); List<rUserRole> list2 = new List<rUserRole>(); this.getCheckList(this.treeList1.Nodes, list); foreach (string str in list) { rUserRole function = new rUserRole(); function.RoleID = this.m_RoleID; function.UserID = str; list2.Add(function); } SqlQueryObject item = new SqlQueryObject(SqlQueryType.Delete, "DeleterUserRoleByWhere", "where RoleID='" + this.m_RoleID + "'"); try { List<SqlQueryObject> list3 = new List<SqlQueryObject>(); list3.Add(item); 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); flag = false; } return flag; }
private void updateGjlist(string rwid, List<sbxj_gj> list) { List<sd_xsgj> gjlist = new List<sd_xsgj>(); List<SqlQueryObject> sqllist = new List<SqlQueryObject>(); int n = Client.ClientHelper.PlatformSqlMap.GetRowCount<sd_xsgj>(string.Format(" where rwid='{0}' and sj='{1}'", rwid, list[0].dt)); SqlQueryObject sqo = null; if (n >0) { sqo = new SqlQueryObject(SqlQueryType.Delete, "Delete", "delete from sd_xsgj where rwID='" + rwid + "'"); sqllist.Add(sqo); } foreach (sbxj_gj gj in list) { sqo = new SqlQueryObject(SqlQueryType.Insert, new sd_xsgj() { rwID = rwid, jd = gj.jd, wd = gj.wd, sj = DateTime.Parse(gj.dt) }); sqllist.Add(sqo); } Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(gjlist.ToArray(), null, null); Console.WriteLine("{0},调用方法:{1},共插入{2}个巡视轨迹点。", DateTime.Now.ToString(), "updateGjlist", list.Count); }
public string UpdateGtOne(ps_gt data) { PS_gt gt = Ebada.Client.ClientHelper.PlatformSqlMap.GetOneByKey<PS_gt>(data.gtID); if (gt != null) { //foreach(FieldInfo fi in data.GetType().GetFields()){ // try { // gt.GetType().GetProperty(fi.Name).SetValue(gt, fi.GetValue(data), null); // } catch { } //} gt.gtType = data.gtType; gt.gtModle = data.gtModle; gt.gtElev = (int)decimal.Parse(data.gtElev); gt.gtLat = decimal.Parse(data.gtLat); gt.gtLon = decimal.Parse(data.gtLon); gt.gtHeight = decimal.Parse(data.gtHeight); gt.gtJg = data.gtSpan == "是" ? "是" : "否";//借杆 if ((gt.gtLat + gt.gtLon) > 0) { int n = Ebada.Client.ClientHelper.PlatformSqlMap.Update<PS_gt>(gt); ncount += n; } if (data.jsonData != null) { Console.WriteLine(data.jsonData); List<ps_gtsb> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ps_gtsb>>(data.jsonData); if (list != null) { List<SqlQueryObject> sqllist = new List<SqlQueryObject>(); SqlQueryObject sqo = new SqlQueryObject(SqlQueryType.Delete, "Delete", "delete from ps_gtsb where gtid='" + gt.gtID + "'"); sqllist.Add(sqo); int num = 0; foreach (ps_gtsb sb in list) { num++; PS_gtsb gtsb = new PS_gtsb() { gtID = gt.gtID, sbModle = sb.xh, sbType = sb.zldm, sbNumber = short.Parse(sb.sl), sbName = sb.zl, sbCode = num.ToString("000") }; gtsb.sbID = gt.gtID + num.ToString("000"); sqo = new SqlQueryObject(SqlQueryType.Insert, gtsb); sqllist.Add(sqo); } Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(sqllist); } //Console.WriteLine(list != null ? list.Count : 0); } //Console.WriteLine("update {0} count {1}", gt.gtCode, n); } return ""; }
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; }
public void ExportExceljhbAllSubmitToWF_ModleRecordWorkTaskIns(string orgid) { string filter = ""; int i = 0; List<WF_ModleRecordWorkTaskIns> mrwtlist = new List<WF_ModleRecordWorkTaskIns>(); filter = " where 1=1 "; if (orgid != "") filter += " and OrgCode='" + orgid + "'"; if (isWorkflowCall) { filter = filter + " and id not in (select ModleRecordID from WF_ModleRecordWorkTaskIns where WorkFlowId='" + WorkFlowData.Rows[0]["WorkFlowId"].ToString() + "') " + " or id in (select ModleRecordID from WF_ModleRecordWorkTaskIns where " + " RecordID='" + currRecord.ID + "') "; } IList<PJ_sbbzqsbgmxb3> datalist = Client.ClientHelper.PlatformSqlMap.GetListByWhere<PJ_sbbzqsbgmxb3>( filter ); if (isWorkflowCall) { for (i = 0; i < datalist.Count; i++) { WF_ModleRecordWorkTaskIns mrwt = new WF_ModleRecordWorkTaskIns(); mrwt.ID = mrwt.CreateID(); mrwt.ModleRecordID = datalist[i].ID; mrwt.RecordID = currRecord.ID; mrwt.WorkFlowId = WorkFlowData.Rows[0]["WorkFlowId"].ToString(); mrwt.WorkFlowInsId = WorkFlowData.Rows[0]["WorkFlowInsId"].ToString(); mrwt.WorkTaskId = WorkFlowData.Rows[0]["WorkTaskId"].ToString(); mrwt.WorkTaskInsId = WorkFlowData.Rows[0]["WorkTaskInsId"].ToString(); mrwt.ModleTableName = datalist[i].GetType().ToString(); mrwt.CreatTime = DateTime.Now; Thread.Sleep(new TimeSpan(100000));//0.1毫秒 mrwtlist.Add(mrwt); } } List<SqlQueryObject> list3 = new List<SqlQueryObject>(); if (mrwtlist.Count > 0) { SqlQueryObject obj3 = new SqlQueryObject(SqlQueryType.Insert, mrwtlist.ToArray()); list3.Add(obj3); } MainHelper.PlatformSqlMap.ExecuteTransationUpdate(list3); }
private SqlConstantExpression EvaluateQueryPlan(SqlQueryObject obj) { if (context.QueryContext == null) throw new ExpressionEvaluateException("A query context is required to evaluate a query."); try { var plan = obj.QueryPlan; var result = plan.Evaluate(context.QueryContext); return SqlExpression.Constant(new DataObject(new TabularType(), SqlTabular.From(result))); } catch (ExpressionEvaluateException) { throw; } catch (Exception ex) { throw new ExpressionEvaluateException("Could not evaluate a query.", ex); } }