public bool UpdateFlow(Model.flow_master oaFlowMasterInfo, List <Model.flow_node> insertList, List <Model.flow_node> updateList, List <Model.flow_node> delList) { try { ArrayList al = new ArrayList(); //主表 StringBuilder sbSql = new StringBuilder(); sbSql.Append("update flow_master set "); sbSql.Append("flow_name='" + oaFlowMasterInfo.flow_name + "',"); sbSql.Append("rf_sid=" + oaFlowMasterInfo.rf_sid + ","); sbSql.Append("dept_sid='" + oaFlowMasterInfo.dept_sid + "',"); sbSql.Append("post_sid='" + oaFlowMasterInfo.post_sid + "',"); sbSql.Append("dept='" + oaFlowMasterInfo.dept + "',"); sbSql.Append("post='" + oaFlowMasterInfo.post + "',"); sbSql.Append("form='" + oaFlowMasterInfo.form + "',"); sbSql.Append("flow_status=" + oaFlowMasterInfo.flow_status + ","); sbSql.Append("remark='" + oaFlowMasterInfo.remark + "',"); sbSql.Append("update_person = '',"); sbSql.Append("update_date = getdate()"); sbSql.Append(" where sid = '" + oaFlowMasterInfo.sid + "'"); al.Add(sbSql.ToString()); //从表 //删除 for (int i = 0; i < delList.Count; i++) { sbSql = new StringBuilder(); Model.flow_node model = delList[i]; sbSql.Append("delete from flow_node where sid=" + model.sid); al.Add(sbSql.ToString()); } //修改 for (int i = 0; i < updateList.Count; i++) { sbSql = new StringBuilder(); //DataRow dr = dtDetail.Rows[i]; //if (dr.RowState == DataRowState.Deleted) continue; Model.flow_node model = updateList[i]; sbSql.Append("update flow_node set node_no = '" + model.node_no.ToString() + "',"); sbSql.Append("flow_sid = " + model.flow_sid.ToString() + ","); sbSql.Append("node_type = '" + model.node_type + "',"); sbSql.Append("node_name = '" + model.node_name + "',"); sbSql.Append("appr_dept = '" + model.appr_dept.ToString() + "',"); sbSql.Append("appr_dept_type = '" + model.appr_dept_type.ToString() + "',"); sbSql.Append("appr_role = '" + model.appr_role.ToString() + "',"); sbSql.Append("dept = '" + model.dept.ToString() + "',"); sbSql.Append("role = '" + model.role.ToString() + "',"); sbSql.Append("appr_count = '" + model.appr_count.ToString() + "',"); sbSql.Append("appr_time = '" + model.appr_time.ToString() + "',"); sbSql.Append("update_person = '',"); sbSql.Append("update_date = getdate()"); sbSql.Append(" where sid = '" + model.sid.ToString() + "'"); al.Add(sbSql.ToString()); } //添加 for (int i = 0; i < insertList.Count; i++) { sbSql = new StringBuilder(); //DataRow dr = dtDetail.Rows[i]; //if (dr.RowState == DataRowState.Deleted) continue; Model.flow_node model = insertList[i]; sbSql.Append("insert into flow_node(flow_sid, node_no, node_type, node_name, appr_dept,"); sbSql.Append("dept,role,"); sbSql.Append("appr_dept_type,appr_role,appr_count,appr_time,create_person, create_date"); sbSql.Append(")values("); sbSql.Append("'" + oaFlowMasterInfo.sid + "'," + model.node_no.ToString() + ","); sbSql.Append("" + model.node_type.ToString() + ",'" + model.node_name.ToString() + "',"); sbSql.Append("'" + model.appr_dept.ToString() + "',"); sbSql.Append("'" + model.dept.ToString() + "',"); sbSql.Append("'" + model.role.ToString() + "',"); sbSql.Append("" + model.appr_dept_type.ToString() + ",'" + model.appr_role.ToString() + "',"); sbSql.Append("" + model.appr_count.ToString() + ",'" + model.appr_time.ToString() + "',"); sbSql.Append("'" + oaFlowMasterInfo.create_person + "',getdate()"); sbSql.Append(")"); al.Add(sbSql.ToString()); } DbHelperSQL.ExecuteSqlTran(al); return(true); } catch (Exception exc) { throw new Exception(exc.Message); } }
/* * /// <summary> * /// 分页获取数据列表 * /// </summary> * public DataSet GetList(int PageSize,int PageIndex,string strWhere) * { * SqlParameter[] parameters = { * new SqlParameter("@tblName", SqlDbType.VarChar, 255), * new SqlParameter("@fldName", SqlDbType.VarChar, 255), * new SqlParameter("@PageSize", SqlDbType.Int), * new SqlParameter("@PageIndex", SqlDbType.Int), * new SqlParameter("@IsReCount", SqlDbType.Bit), * new SqlParameter("@OrderType", SqlDbType.Bit), * new SqlParameter("@strWhere", SqlDbType.VarChar,1000), * }; * parameters[0].Value = "flow_master"; * parameters[1].Value = "sid"; * parameters[2].Value = PageSize; * parameters[3].Value = PageIndex; * parameters[4].Value = 0; * parameters[5].Value = 0; * parameters[6].Value = strWhere; * return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds"); * }*/ #endregion BasicMethod #region ExtensionMethod public bool InsertFlow(Model.flow_master oaFlowMasterInfo, List <Model.flow_node> insertList) { StringBuilder sbSql = new StringBuilder(); sbSql.Append("insert into flow_master(flow_name,rf_sid,dept_sid,post_sid,flow_status,remark,"); sbSql.Append("create_person, create_date,dept,post,form"); sbSql.Append(")values("); sbSql.Append("'" + oaFlowMasterInfo.flow_name + "'," + oaFlowMasterInfo.rf_sid + ","); sbSql.Append("'" + oaFlowMasterInfo.dept_sid + "','" + oaFlowMasterInfo.post_sid + "',"); sbSql.Append("" + oaFlowMasterInfo.flow_status + ",'" + oaFlowMasterInfo.remark + "',"); sbSql.Append("'" + oaFlowMasterInfo.create_person + "',getdate(),"); sbSql.Append("'" + oaFlowMasterInfo.dept + "','" + oaFlowMasterInfo.post + "','" + oaFlowMasterInfo.form + "'"); sbSql.Append(")"); using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; SqlTransaction tx = conn.BeginTransaction(); cmd.Transaction = tx; try { //主表 cmd.CommandText = sbSql.ToString(); cmd.ExecuteNonQuery(); //获取ID cmd.CommandText = "select SCOPE_IDENTITY()"; string strMID = cmd.ExecuteScalar().ToString(); //从表 //添加 for (int i = 0; i < insertList.Count; i++) { sbSql = new StringBuilder(); //DataRow dr = dtDetail.Rows[i]; //if (dr.RowState == DataRowState.Deleted) continue; Model.flow_node model = insertList[i]; sbSql.Append("insert into flow_node(flow_sid, node_no, node_type, node_name, appr_dept,"); sbSql.Append("dept,role,"); sbSql.Append("appr_dept_type,appr_role,appr_count,appr_time,create_person, create_date"); sbSql.Append(")values("); sbSql.Append("'" + strMID + "'," + model.node_no.ToString() + ","); sbSql.Append("" + model.node_type.ToString() + ",'" + model.node_name.ToString() + "',"); sbSql.Append("'" + model.appr_dept.ToString() + "',"); sbSql.Append("'" + model.dept.ToString() + "',"); sbSql.Append("'" + model.role.ToString() + "',"); sbSql.Append("" + model.appr_dept_type.ToString() + ",'" + model.appr_role.ToString() + "',"); sbSql.Append("" + model.appr_count.ToString() + ",'" + model.appr_time.ToString() + "',"); sbSql.Append("'" + oaFlowMasterInfo.create_person + "',getdate()"); sbSql.Append(")"); cmd.CommandText = sbSql.ToString(); cmd.ExecuteNonQuery(); } tx.Commit(); } catch (System.Data.SqlClient.SqlException E) { tx.Rollback(); throw new Exception(E.Message); } } return(true); }