/**//// <summary> /// 获得WorkServiceMessage表 /// </summary> /// <param name=MessageId></param> /// <returns></returns> public static DataTable GetWorkServiceMessageTable(string messageid) { try { //string sql = "select * from WorkServiceMessage where MessageId=@messageid"; //SqlDataItem sqlItem = new SqlDataItem(); //sqlItem.CommandText = sql; //sqlItem.AppendParameter("@messageid", messageid); //ClientDBAgent agent = new ClientDBAgent(); //return agent.ExecuteDataTable(sqlItem); string sql = "where MessageId='"+messageid+"'"; IList li = MainHelper.PlatformSqlMap.GetList("SelectWF_WorkServiceMessageList", messageid); if (li.Count == 0) { DataTable dt = new DataTable(); return dt; } return ConvertHelper.ToDataTable(li); } catch (Exception ex) { throw ex; } } public void GetWorkServiceMessageInfo(string messageid) { DataTable dt = GetWorkServiceMessageTable(messageid); if (dt != null && dt.Rows.Count > 0) { MessageId = dt.Rows[0]["MessageId"].ToString(); WorkflowId = dt.Rows[0]["WorkflowId"].ToString(); WorktaskId = dt.Rows[0]["WorktaskId"].ToString(); WorkflowInsId = dt.Rows[0]["WorkflowInsId"].ToString(); WorktaskInsId = dt.Rows[0]["WorktaskInsId"].ToString(); Content = dt.Rows[0]["Content"].ToString(); SendTime1 = dt.Rows[0]["SendTime1"].ToString(); SendTime2 = dt.Rows[0]["SendTime2"].ToString(); SendTime3 = dt.Rows[0]["SendTime3"].ToString(); DoneFlag1 = Convert.ToInt16(dt.Rows[0]["DoneFlag1"].ToString()); DoneFlag2 = Convert.ToInt16(dt.Rows[0]["DoneFlag2"].ToString()); DoneFlag3 = Convert.ToInt16(dt.Rows[0]["DoneFlag3"].ToString()); MsgType = dt.Rows[0]["MsgType"].ToString(); Users1 = dt.Rows[0]["Users1"].ToString(); Users2 = dt.Rows[0]["Users2"].ToString(); Users3 = dt.Rows[0]["Users3"].ToString(); } } /**//// <summary> /// 根据主键删除记录 /// </summary> /// <param name=MessageId></param> /// <returns></returns> public static int Delete(string messageid) { try { //string sql = "delete from WorkServiceMessage where MessageId=@messageid"; //SqlDataItem sqlItem = new SqlDataItem(); //sqlItem.CommandText = sql; //sqlItem.AppendParameter("@messageid", messageid); //ClientDBAgent agent = new ClientDBAgent(); //return agent.ExecuteNonQuery(sqlItem); WF_WorkServiceMessage workSer = new WF_WorkServiceMessage(); workSer.MessageId = messageid; return MainHelper.PlatformSqlMap.Delete<WF_WorkServiceMessage>(workSer); } catch (Exception ex) { throw ex; } }
//private void setParameter() //{ // sqlDataItem.ParameterList.Clear(); // sqlDataItem.AppendParameter("@MessageId", MessageId); // sqlDataItem.AppendParameter("@WorkflowId", WorkflowId); // sqlDataItem.AppendParameter("@WorktaskId", WorktaskId); // sqlDataItem.AppendParameter("@WorkflowInsId", WorkflowInsId); // sqlDataItem.AppendParameter("@WorktaskInsId", WorktaskInsId); // sqlDataItem.AppendParameter("@Content", Content); // sqlDataItem.AppendParameter("@SendTime1", SendTime1); // sqlDataItem.AppendParameter("@SendTime2", SendTime2); // sqlDataItem.AppendParameter("@SendTime3", SendTime3); // sqlDataItem.AppendParameter("@DoneFlag1", DoneFlag1,typeof(int)); // sqlDataItem.AppendParameter("@DoneFlag2", DoneFlag2, typeof(int)); // sqlDataItem.AppendParameter("@DoneFlag3", DoneFlag3, typeof(int)); // sqlDataItem.AppendParameter("@MsgType", MsgType); // sqlDataItem.AppendParameter("@Users1", Users1); // sqlDataItem.AppendParameter("@Users2", Users2); // sqlDataItem.AppendParameter("@Users3", Users3); //} //private void setInsertSql() //{ // string tmpValueList = ""; // string tmpFieldName = ""; // sqlString = "insert into " + tableName + "("; // int tmpInt = this.fieldList.Length; // for (int i = 0; i < tmpInt - 1; i++) // { // tmpFieldName = fieldList[i].ToString(); // sqlString = sqlString + tmpFieldName + ","; // tmpValueList = tmpValueList + "@" + tmpFieldName + ","; // } // tmpFieldName = this.fieldList[tmpInt - 1].ToString(); // sqlString = sqlString + tmpFieldName; // tmpValueList = tmpValueList + "@" + tmpFieldName; // this.sqlString = sqlString + ")values(" + tmpValueList + ")"; // sqlDataItem.CommandText = sqlString; //} //private void setUpdateSql() //{ // string tmpFieldName = ""; // int tmpInt = this.fieldList.Length; // sqlString = "update " + tableName + " set "; // for (int i = 0; i < tmpInt - 1; i++) // { // tmpFieldName = this.fieldList[i].ToString(); // sqlString = sqlString + tmpFieldName + "=@" + tmpFieldName + ","; // } // tmpFieldName = fieldList[tmpInt - 1].ToString(); // sqlString = sqlString + tmpFieldName + "=@" + tmpFieldName; // sqlString = sqlString + " where " + keyField + "=@" + keyField; // sqlDataItem.CommandText = sqlString; //} /**//// <summary> /// 增加WorkServiceMessage /// </summary> public void Insert() { try { //setInsertSql();//设定insert语句 //setParameter();//设定参数 //ClientDBAgent agent = new ClientDBAgent(); //agent.ExecuteNonQuery(sqlDataItem); WF_WorkServiceMessage workSer = new WF_WorkServiceMessage(); workSer.MessageId=MessageId; workSer.WorkflowId=WorkflowId; workSer.WorktaskId=WorktaskId; workSer.WorkflowInsId=WorkflowInsId; workSer.WorktaskInsId=WorktaskInsId; workSer.Content=Content; workSer.SendTime1=Convert.ToDateTime( SendTime1); workSer.SendTime2=Convert.ToDateTime( SendTime2); workSer.SendTime3=Convert.ToDateTime( SendTime3); workSer.DoneFlag1=DoneFlag1; workSer.DoneFlag2=DoneFlag2; workSer.DoneFlag3=DoneFlag3; workSer.MsgType=MsgType; workSer.Users1=Users1; workSer.Users2=Users2; workSer.Users3 = Users3; MainHelper.PlatformSqlMap.Create<WF_WorkServiceMessage>(workSer); } catch (Exception ex) { throw ex; } } /**//// <summary> /// 更新WorkServiceMessage /// </summary> public void Update() { if (MessageId.Trim().Length == 0 || MessageId == null) throw new Exception("Update方法错误,MessageId不能为空!"); try { //setUpdateSql();//设定Update语句 //setParameter();//设定参数 //ClientDBAgent agent = new ClientDBAgent(); //agent.ExecuteNonQuery(sqlDataItem); WF_WorkServiceMessage workSer = new WF_WorkServiceMessage(); workSer.MessageId = MessageId; workSer.WorkflowId = WorkflowId; workSer.WorktaskId = WorktaskId; workSer.WorkflowInsId = WorkflowInsId; workSer.WorktaskInsId = WorktaskInsId; workSer.Content = Content; workSer.SendTime1 = Convert.ToDateTime(SendTime1); workSer.SendTime2 = Convert.ToDateTime(SendTime2); workSer.SendTime3 = Convert.ToDateTime(SendTime3); workSer.DoneFlag1 = DoneFlag1; workSer.DoneFlag2 = DoneFlag2; workSer.DoneFlag3 = DoneFlag3; workSer.MsgType = MsgType; workSer.Users1 = Users1; workSer.Users2 = Users2; workSer.Users3 = Users3; MainHelper.PlatformSqlMap.Update <WF_WorkServiceMessage>(workSer); } catch (Exception ex) { throw ex; } }