public bool Edit(List <Model.implement> insertList, List <Model.implement> updateList, List <Model.implement> delList, string uid)
{
ArrayList al = new ArrayList();
StringBuilder sbSql = new StringBuilder();
//删除
for (int i = 0; i < delList.Count; i++)
{
sbSql = new StringBuilder();
Model.implement model = delList[i];
sbSql.Append("delete from implement where sid=" + model.sid);
al.Add(sbSql.ToString());
}
//修改
for (int i = 0; i < updateList.Count; i++)
{
sbSql = new StringBuilder();
Model.implement model = updateList[i];
sbSql.Append("update implement set implement_name = '" + model.implement_name.Trim() + "',");
sbSql.Append("remark = '" + model.remark.Trim() + "',");
sbSql.Append("update_person = '" + uid + "',");
sbSql.Append("update_date =getdate()");
sbSql.Append(" where sid = '" + model.sid.ToString().Trim() + "'");
al.Add(sbSql.ToString());
}
//添加
for (int i = 0; i < insertList.Count; i++)
{
sbSql = new StringBuilder();
Model.implement model = insertList[i];
sbSql.Append("insert into implement(implement_name, remark,create_person,create_date");
sbSql.Append(")values(");
sbSql.Append("'" + model.implement_name.Trim() + "','" + model.remark.Trim() + "','" + uid + "',getdate()");
sbSql.Append(")");
al.Add(sbSql.ToString());
}
//排序
//for (int i = 0; i < sequenceList.Count; i++)
//{
// sbSql = new StringBuilder();
// Model.project_group_model model = sequenceList[i];
// if (model.sid.ToString().Trim() != "0" && model.sid.ToString().Trim() != "")
// {
// sbSql.Append("update stage set sequence = " + i.ToString().Trim());
// sbSql.Append("");
// sbSql.Append(" where sid = " + model.sid.ToString().Trim() + "");
// al.Add(sbSql.ToString());
// }
//}
DbHelperSQL.ExecuteSqlTran(al);
return(true);
}
/*
* /// <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 = "implement";
* 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
#endregion ExtensionMethod
public bool Edit(List <Model.implement> insertList, List <Model.implement> updateList, List <Model.implement> delList)
{
ArrayList al = new ArrayList();
StringBuilder sbSql = new StringBuilder();
//删除
for (int i = 0; i < delList.Count; i++)
{
sbSql = new StringBuilder();
Model.implement model = delList[i];
sbSql.Append("delete from implement where sid=" + model.sid);
al.Add(sbSql.ToString());
}
//修改
for (int i = 0; i < updateList.Count; i++)
{
sbSql = new StringBuilder();
Model.implement model = updateList[i];
sbSql.Append("update implement set implement_name = '" + model.implement_name.Trim() + "',");
sbSql.Append("remark = '" + model.remark.Trim() + "'");
sbSql.Append(" where sid = '" + model.sid.ToString().Trim() + "'");
al.Add(sbSql.ToString());
}
//添加
for (int i = 0; i < insertList.Count; i++)
{
sbSql = new StringBuilder();
Model.implement model = insertList[i];
sbSql.Append("insert into implement(implement_name, remark");
sbSql.Append(")values(");
sbSql.Append("'" + model.implement_name.Trim() + "','" + model.remark.Trim() + "'");
sbSql.Append(")");
al.Add(sbSql.ToString());
}
DbHelperSQL.ExecuteSqlTran(al);
return(true);
}
