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);
}
