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