/// <summary> /// 增加一条数据 /// </summary> public bool Add(Library.Model.WorkFlow_Templete model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_WorkFlow_Templete("); strSql.Append("F_LinkTask,F_StateID,F_StateName,F_StateType,F_Next_StateID,F_Back_StateID)"); strSql.Append(" values ("); strSql.Append("@F_LinkTask,@F_StateID,@F_StateName,@F_StateType,@F_Next_StateID,@F_Back_StateID)"); SqlParameter[] parameters = { new SqlParameter("@F_LinkTask", SqlDbType.VarChar, 50), new SqlParameter("@F_StateID", SqlDbType.VarChar, 50), new SqlParameter("@F_StateName", SqlDbType.VarChar, 50), new SqlParameter("@F_StateType", SqlDbType.Int, 4), new SqlParameter("@F_Next_StateID", SqlDbType.VarChar, 50), new SqlParameter("@F_Back_StateID", SqlDbType.VarChar, 50) }; parameters[0].Value = model.F_LinkTask; parameters[1].Value = model.F_StateID; parameters[2].Value = model.F_StateName; parameters[3].Value = model.F_StateType; parameters[4].Value = model.F_Next_StateID; parameters[5].Value = model.F_Back_StateID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Library.Model.WorkFlow_Templete GetModel(string F_LinkTask, string F_StateID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 F_LinkTask,F_StateID,F_StateName,F_StateType,F_Next_StateID,F_Back_StateID from T_WorkFlow_Templete "); strSql.Append(" where F_LinkTask=@F_LinkTask and F_StateID=@F_StateID "); SqlParameter[] parameters = { new SqlParameter("@F_LinkTask", SqlDbType.VarChar, 50), new SqlParameter("@F_StateID", SqlDbType.VarChar, 50) }; parameters[0].Value = F_LinkTask; parameters[1].Value = F_StateID; Library.Model.WorkFlow_Templete model = new Library.Model.WorkFlow_Templete(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Library.Model.WorkFlow_Templete DataRowToModel(DataRow row) { Library.Model.WorkFlow_Templete model = new Library.Model.WorkFlow_Templete(); if (row != null) { if (row["F_LinkTask"] != null) { model.F_LinkTask = row["F_LinkTask"].ToString(); } if (row["F_StateID"] != null) { model.F_StateID = row["F_StateID"].ToString(); } if (row["F_StateName"] != null) { model.F_StateName = row["F_StateName"].ToString(); } if (row["F_StateType"] != null && row["F_StateType"].ToString() != "") { model.F_StateType = int.Parse(row["F_StateType"].ToString()); } if (row["F_Next_StateID"] != null) { model.F_Next_StateID = row["F_Next_StateID"].ToString(); } if (row["F_Back_StateID"] != null) { model.F_Back_StateID = row["F_Back_StateID"].ToString(); } } return(model); }
private void btnNo_Click(object sender, RoutedEventArgs e) { DataRow row = GridView.GetFocusedDataRow(); if (row != null) { string id = row["F_ID"].ToString(); string F_StateID = row["F_StateID"].ToString(); if ("5".Equals(F_StateID)) { Library.Model.CostApply model = SystemManager.Instance.Services.CostApplyService.GetModel(int.Parse(id)); Library.Model.WorkFlow_Templete wfnode = SystemManager.Instance.Services.WorkFlow_TempleteService.GetCurrentModel(WorkFlowLinkTable.BaseFare, F_StateID); if (wfnode.F_StateType == 2 || wfnode.F_StateType == 1) // 当前节点时 判断或者普通节点 { if (MessageBox.Show("是否确认驳回\"" + row["F_ApplyTitle"] + "\"?", "提示", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { model.F_WF_StateID = int.Parse(wfnode.F_Back_StateID); SystemManager.Instance.Services.CostApplyService.Update(model); BindDataList(); } } else { MessageBox.Show("当前节点不在审批范围!"); } } else { MessageBox.Show("请选择单据状态为\"财务确认\"的记录!"); } } else { MessageBox.Show("请选择单据记录"); } }