public IList <T_truckType> ListMaker(string tempsql, SqlParameter[] sps)
{
DataTable dt = returnDt(tempsql, sps, false);
IList <T_truckType> list = new List <T_truckType>();
foreach (DataRow dr in dt.Rows)
{
T_truckType model = new T_truckType();
model.typeCode = dr["typeCode"].ToString();
model.NOTE5 = dr["NOTE5"].ToString();
model.typeName = dr["typeName"].ToString();
model.parentCode = dr["parentCode"].ToString();
model.status = dr["status"].ToString();
model.IsLastNode = dr["IsLastNode"].ToString();
float fHigherPerPoint = 0;
float.TryParse(dr["HigherPerPoint"].ToString(), out fHigherPerPoint);
model.HigherPerPoint = fHigherPerPoint;
float fRebatePoint = 0;
float.TryParse(dr["RebatePoint"].ToString(), out fRebatePoint);
model.RebatePoint = fRebatePoint;
model.NOTE1 = dr["NOTE1"].ToString();
model.NOTE2 = dr["NOTE2"].ToString();
model.NOTE3 = dr["NOTE3"].ToString();
model.NOTE4 = dr["NOTE4"].ToString();
float fDeductionPoint = 0;
float.TryParse(dr["DeductionPoint"].ToString(), out fDeductionPoint);
model.DeductionPoint = fDeductionPoint;
list.Add(model);
}
return(list);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(T_truckType model, SqlTransaction tran)
{
Delete(model.typeCode, tran);
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_truckType(");
strSql.Append("typeCode,NOTE5,typeName,parentCode,status,IsLastNode,HigherPerPoint,RebatePoint,NOTE1,NOTE2,NOTE3,NOTE4,DeductionPoint");
strSql.Append(") values (");
strSql.Append("@typeCode,@NOTE5,@typeName,@parentCode,@status,@IsLastNode,@HigherPerPoint,@RebatePoint,@NOTE1,@NOTE2,@NOTE3,@NOTE4,@DeductionPoint");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@typeCode", SqlDbType.NVarChar, 50),
new SqlParameter("@NOTE5", SqlDbType.NVarChar, 50),
new SqlParameter("@typeName", SqlDbType.NVarChar, 50),
new SqlParameter("@parentCode", SqlDbType.NVarChar, 50),
new SqlParameter("@status", SqlDbType.Char, 1),
new SqlParameter("@IsLastNode", SqlDbType.Char, 1),
new SqlParameter("@HigherPerPoint", SqlDbType.Float),
new SqlParameter("@RebatePoint", SqlDbType.Float),
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("@DeductionPoint", SqlDbType.NVarChar, 50)
};
parameters[0].Value = SqlNull(model.typeCode);
parameters[1].Value = SqlNull(model.NOTE5);
parameters[2].Value = SqlNull(model.typeName);
parameters[3].Value = SqlNull(model.parentCode);
parameters[4].Value = SqlNull(model.status);
parameters[5].Value = SqlNull(model.IsLastNode);
parameters[6].Value = SqlNull(model.HigherPerPoint);
parameters[7].Value = SqlNull(model.RebatePoint);
parameters[8].Value = SqlNull(model.NOTE1);
parameters[9].Value = SqlNull(model.NOTE2);
parameters[10].Value = SqlNull(model.NOTE3);
parameters[11].Value = SqlNull(model.NOTE4);
parameters[12].Value = SqlNull(model.DeductionPoint);
return(DataHelper.ExcuteNonQuery(strSql.ToString(), tran, parameters, false));
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <param name="tran"></param>
/// <returns></returns>
public int updatemodel(T_truckType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"update T_truckType set NOTE5=@NOTE5,typeName=@typeName,parentCode=@parentCode,status=@status,
IsLastNode=@IsLastNode,HigherPerPoint=@HigherPerPoint,RebatePoint=@RebatePoint,NOTE1=@NOTE1,NOTE2=@NOTE2,NOTE3=@NOTE3,NOTE4=@NOTE4,DeductionPoint=@DeductionPoint
where typeCode=@typeCode");
SqlParameter[] parameters =
{
new SqlParameter("@typeCode", SqlDbType.NVarChar, 50),
new SqlParameter("@NOTE5", SqlDbType.NVarChar, 50),
new SqlParameter("@typeName", SqlDbType.NVarChar, 50),
new SqlParameter("@parentCode", SqlDbType.NVarChar, 50),
new SqlParameter("@status", SqlDbType.Char, 1),
new SqlParameter("@IsLastNode", SqlDbType.Char, 1),
new SqlParameter("@HigherPerPoint", SqlDbType.Float),
new SqlParameter("@RebatePoint", SqlDbType.Float),
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("@DeductionPoint", SqlDbType.NVarChar, 50)
};
parameters[0].Value = SqlNull(model.typeCode);
parameters[1].Value = SqlNull(model.NOTE5);
parameters[2].Value = SqlNull(model.typeName);
parameters[3].Value = SqlNull(model.parentCode);
parameters[4].Value = SqlNull(model.status);
parameters[5].Value = SqlNull(model.IsLastNode);
parameters[6].Value = SqlNull(model.HigherPerPoint);
parameters[7].Value = SqlNull(model.RebatePoint);
parameters[8].Value = SqlNull(model.NOTE1);
parameters[9].Value = SqlNull(model.NOTE2);
parameters[10].Value = SqlNull(model.NOTE3);
parameters[11].Value = SqlNull(model.NOTE4);
parameters[12].Value = SqlNull(model.DeductionPoint);
return(DataHelper.ExcuteNonQuery(strSql.ToString(), parameters, false));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="modelTruckType"></param>
/// <returns></returns>
public int Upd(T_truckType modelTruckType, out string strmsg)
{
try
{
strmsg = "";
return(dalTruckType.updatemodel(modelTruckType));
}
catch (Exception ex)
{
strmsg = ex.Message;
return(0);
}
}
public int Add(T_truckType modelTruckType, out string strMsg)
{
try
{
strMsg = "";
return(dalTruckType.Add(modelTruckType));
}
catch (Exception ex)
{
strMsg = ex.Message;
return(0);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public T_truckType GetModel(string typeCode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(sql);
strSql.Append(" where typeCode=@typeCode ");
SqlParameter[] parameters =
{
new SqlParameter("@typeCode", typeCode)
};
T_truckType model = new T_truckType();
using (SqlDataReader dr = DataHelper.GetDataReader(strSql.ToString(), parameters))
{
if (dr.Read())
{
model.typeCode = dr["typeCode"].ToString();
model.NOTE5 = dr["NOTE5"].ToString();
model.typeName = dr["typeName"].ToString();
model.parentCode = dr["parentCode"].ToString();
model.status = dr["status"].ToString();
model.IsLastNode = dr["IsLastNode"].ToString();
float fHigherPerPoint = 0;
float.TryParse(dr["HigherPerPoint"].ToString(), out fHigherPerPoint);
model.HigherPerPoint = fHigherPerPoint;
float fRebatePoint = 0;
float.TryParse(dr["RebatePoint"].ToString(), out fRebatePoint);
model.RebatePoint = fRebatePoint;
model.NOTE1 = dr["NOTE1"].ToString();
model.NOTE2 = dr["NOTE2"].ToString();
model.NOTE3 = dr["NOTE3"].ToString();
model.NOTE4 = dr["NOTE4"].ToString();
float fDeductionPoint = 0;
float.TryParse(dr["DeductionPoint"].ToString(), out fDeductionPoint);
model.DeductionPoint = fDeductionPoint;
return(model);
}
else
{
return(null);
}
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="strCode"></param>
/// <param name="msg"></param>
/// <returns></returns>
public int Delete(string strCode, out string msg)
{
try
{
//先获取model以操作上级节点
T_truckType modelTruckType = this.GetModel(strCode);
msg = "";
int iRel = dalTruckType.Delete(strCode);
if (iRel < 1)
{
throw new Exception("删除车辆类型时失败！");
}
//删除车辆对应关系
new T_TruckTypeCorrespondBLL().DeleteByTruckTypeCode(strCode);
//判断父节点的子节点数量 如果为零 则修改状态为末节点
if (modelTruckType != null && modelTruckType.parentCode != "0")
{
int childrenCount = this.dalTruckType.GetAllChildren(modelTruckType.parentCode).Count;
if (childrenCount == 0)
{
string strUp = "update T_truckType set IsLastNode='1' where typeCode=@typeCode";
SqlParameter[] arrSp = new SqlParameter[] { new SqlParameter("@typeCode", modelTruckType.parentCode) };
int iRel2 = DataHelper.ExcuteNonQuery(strUp, arrSp, false);
if (iRel2 < 1)
{
throw new Exception("在修改父节点状态时出现异常！");
}
}
else
{
throw new Exception("该节点下有子节点，不允许删除！");
}
}
return(1);
}
catch (Exception ex)
{
msg = ex.Message;
return(-1);
}
}
public int Add(T_truckType model)
{
using (SqlConnection conn = new SqlConnection(DataHelper.constr))
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
int iRel = Add(model, tran);
tran.Commit();
return(iRel);
}
catch
{
tran.Rollback();
throw;
}
}
}