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