public IList <ZiChan_ShiYongZhuangKuang> ListMaker(string tempsql, SqlParameter[] sps) { DataTable dt = DataHelper.GetDataTable(tempsql, sps, false); IList <ZiChan_ShiYongZhuangKuang> list = new List <ZiChan_ShiYongZhuangKuang>(); foreach (DataRow dr in dt.Rows) { ZiChan_ShiYongZhuangKuang model = new ZiChan_ShiYongZhuangKuang(); model.ZhuangKuangCode = dr["ZhuangKuangCode"].ToString(); model.Note6 = dr["Note6"].ToString(); model.Note7 = dr["Note7"].ToString(); model.Note8 = dr["Note8"].ToString(); model.Note9 = dr["Note9"].ToString(); model.Note10 = dr["Note10"].ToString(); model.ZhuangKuangName = dr["ZhuangKuangName"].ToString(); model.ParentCode = dr["ParentCode"].ToString(); model.BeiZhu = dr["BeiZhu"].ToString(); model.Note1 = dr["Note1"].ToString(); model.Note2 = dr["Note2"].ToString(); model.Note3 = dr["Note3"].ToString(); model.Note4 = dr["Note4"].ToString(); model.Note5 = dr["Note5"].ToString(); list.Add(model); } return(list); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ZiChan_ShiYongZhuangKuang model, SqlTransaction tran) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ZiChan_ShiYongZhuangKuang("); strSql.Append("ZhuangKuangCode,Note6,Note7,Note8,Note9,Note10,ZhuangKuangName,ParentCode,BeiZhu,Note1,Note2,Note3,Note4,Note5"); strSql.Append(") values ("); strSql.Append("@ZhuangKuangCode,@Note6,@Note7,@Note8,@Note9,@Note10,@ZhuangKuangName,@ParentCode,@BeiZhu,@Note1,@Note2,@Note3,@Note4,@Note5"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@ZhuangKuangCode", SqlDbType.NVarChar, 50), new SqlParameter("@Note6", SqlDbType.NVarChar, 50), new SqlParameter("@Note7", SqlDbType.NVarChar, 50), new SqlParameter("@Note8", SqlDbType.NVarChar, 50), new SqlParameter("@Note9", SqlDbType.NVarChar, 50), new SqlParameter("@Note10", SqlDbType.NVarChar, 50), new SqlParameter("@ZhuangKuangName", SqlDbType.NVarChar, 50), new SqlParameter("@ParentCode", SqlDbType.NVarChar, 50), new SqlParameter("@BeiZhu", SqlDbType.NVarChar, 100), new SqlParameter("@Note1", SqlDbType.NVarChar, 50), new SqlParameter("@Note2", SqlDbType.NVarChar, 50), new SqlParameter("@Note3", SqlDbType.NVarChar, 50), new SqlParameter("@Note4", SqlDbType.NVarChar, 50), new SqlParameter("@Note5", SqlDbType.NVarChar, 50) }; parameters[0].Value = SqlNull(model.ZhuangKuangCode); parameters[1].Value = SqlNull(model.Note6); parameters[2].Value = SqlNull(model.Note7); parameters[3].Value = SqlNull(model.Note8); parameters[4].Value = SqlNull(model.Note9); parameters[5].Value = SqlNull(model.Note10); parameters[6].Value = SqlNull(model.ZhuangKuangName); parameters[7].Value = SqlNull(model.ParentCode); parameters[8].Value = SqlNull(model.BeiZhu); parameters[9].Value = SqlNull(model.Note1); parameters[10].Value = SqlNull(model.Note2); parameters[11].Value = SqlNull(model.Note3); parameters[12].Value = SqlNull(model.Note4); parameters[13].Value = SqlNull(model.Note5); return(DataHelper.ExcuteNonQuery(strSql.ToString(), tran, parameters, false)); }
/// <summary> /// /// </summary> /// <param name="model"></param> /// <returns></returns> public int updatemodel(ZiChan_ShiYongZhuangKuang model) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"update ZiChan_ShiYongZhuangKuang set ZhuangKuangName=@ZhuangKuangName,ParentCode=@ParentCode, BeiZhu=@BeiZhu,Note1=@Note1,Note2=@Note2,Note3=@Note3,Note4=@Note4,Note5=@Note5,Note6=@Note6,Note7=@Note7,Note8=@Note8,Note9=@Note9,Note10=@Note10 where ZhuangKuangCode=@ZhuangKuangCode"); SqlParameter[] parameters = { new SqlParameter("@ZhuangKuangCode", SqlDbType.NVarChar, 50), new SqlParameter("@ZhuangKuangName", SqlDbType.NVarChar, 50), new SqlParameter("@ParentCode", SqlDbType.NVarChar, 50), new SqlParameter("@BeiZhu", SqlDbType.NVarChar, 100), new SqlParameter("@Note1", SqlDbType.NVarChar, 50), new SqlParameter("@Note2", SqlDbType.NVarChar, 50), new SqlParameter("@Note3", SqlDbType.NVarChar, 50), new SqlParameter("@Note4", SqlDbType.NVarChar, 50), new SqlParameter("@Note5", SqlDbType.NVarChar, 50), new SqlParameter("@Note6", SqlDbType.NVarChar, 50), new SqlParameter("@Note7", SqlDbType.NVarChar, 50), new SqlParameter("@Note8", SqlDbType.NVarChar, 50), new SqlParameter("@Note9", SqlDbType.NVarChar, 50), new SqlParameter("@Note10", SqlDbType.NVarChar, 50) }; parameters[0].Value = SqlNull(model.ZhuangKuangCode); parameters[1].Value = SqlNull(model.ZhuangKuangName); parameters[2].Value = SqlNull(model.ParentCode); parameters[3].Value = SqlNull(model.BeiZhu); parameters[4].Value = SqlNull(model.Note1); parameters[5].Value = SqlNull(model.Note2); parameters[6].Value = SqlNull(model.Note3); parameters[7].Value = SqlNull(model.Note4); parameters[8].Value = SqlNull(model.Note5); parameters[9].Value = SqlNull(model.Note6); parameters[10].Value = SqlNull(model.Note7); parameters[11].Value = SqlNull(model.Note8); parameters[12].Value = SqlNull(model.Note9); parameters[13].Value = SqlNull(model.Note10); return(DataHelper.ExcuteNonQuery(strSql.ToString(), parameters, false)); }
/// <summary> /// 修改 /// </summary> /// <param name="modelTruckType"></param> /// <returns></returns> public int Upd(ZiChan_ShiYongZhuangKuang model, out string strmsg) { try { strmsg = ""; return(syzkDal.updatemodel(model)); } catch (Exception ex) { strmsg = ex.Message; return(0); } }
/// <summary> /// 删除 /// </summary> /// <param name="strCode"></param> /// <param name="msg"></param> /// <returns></returns> public int Delete(string strCode, out string msg) { try { //先获取model以操作上级节点 ZiChan_ShiYongZhuangKuang model = this.GetModel(strCode); msg = ""; ////判断父节点的子节点数量 如果为零 则可以删除 if (model != null) { int childrenCount = this.syzkDal.GetAllChildren(model.ZhuangKuangCode).Count; //获取该类别下子节点数 if (childrenCount > 0) //有子节点 不允许删除 { msg = "该节点下有子节点,不允许删除!"; throw new Exception(msg); } else//没有子节点 删除 { int iRel = syzkDal.Delete(strCode); if (iRel < 1) { msg = "删除资产类型时失败!"; throw new Exception(msg); } } return(1); } else { return(-1); } } catch (Exception ex) { msg = ex.Message; return(-1); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ZiChan_ShiYongZhuangKuang GetModel(string ZhuangKuangCode) { StringBuilder strSql = new StringBuilder(); strSql.Append(sql); strSql.Append(" where ZhuangKuangCode=@ZhuangKuangCode "); SqlParameter[] parameters = { new SqlParameter("@ZhuangKuangCode", SqlDbType.NVarChar, 50) }; parameters[0].Value = ZhuangKuangCode; ZiChan_ShiYongZhuangKuang model = new ZiChan_ShiYongZhuangKuang(); using (SqlDataReader dr = DataHelper.GetDataReader(strSql.ToString(), parameters)) { if (dr.Read()) { model.ZhuangKuangCode = dr["ZhuangKuangCode"].ToString(); model.Note6 = dr["Note6"].ToString(); model.Note7 = dr["Note7"].ToString(); model.Note8 = dr["Note8"].ToString(); model.Note9 = dr["Note9"].ToString(); model.Note10 = dr["Note10"].ToString(); model.ZhuangKuangName = dr["ZhuangKuangName"].ToString(); model.ParentCode = dr["ParentCode"].ToString(); model.BeiZhu = dr["BeiZhu"].ToString(); model.Note1 = dr["Note1"].ToString(); model.Note2 = dr["Note2"].ToString(); model.Note3 = dr["Note3"].ToString(); model.Note4 = dr["Note4"].ToString(); model.Note5 = dr["Note5"].ToString(); return(model); } else { return(null); } } }
public int Add(ZiChan_ShiYongZhuangKuang model) { using (SqlConnection conn = new SqlConnection(DataHelper.constr)) { conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { Delete(model.ZhuangKuangCode, tran); int intRow = Add(model, tran); tran.Commit(); return(intRow); } catch { tran.Rollback(); throw; } } }