/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(EtNet_Models.ProdClass model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ProdClass(");
strSql.Append("ProdClassNo,ProdClassName,Prior,ViewInReport)");
strSql.Append(" values (");
strSql.Append("@ProdClassNo,@ProdClassName,@Prior,@ViewInReport)");
SqlParameter[] parameters =
{
new SqlParameter("@ProdClassNo", SqlDbType.Char, 4),
new SqlParameter("@ProdClassName", SqlDbType.Char, 60),
new SqlParameter("@Prior", SqlDbType.Int, 4),
new SqlParameter("@ViewInReport", SqlDbType.Bit, 1)
};
parameters[0].Value = model.ProdClassNo;
parameters[1].Value = model.ProdClassName;
parameters[2].Value = model.Prior;
parameters[3].Value = model.ViewInReport;
int rows = DBHelper.ExecuteCommand(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(EtNet_Models.ProdClass model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ProdClass set ");
strSql.Append("ProdClassName=@ProdClassName,");
strSql.Append("Prior=@Prior,");
strSql.Append("ViewInReport=@ViewInReport");
strSql.Append(" where ProdClassNo=@ProdClassNo");
SqlParameter[] parameters =
{
new SqlParameter("@ProdClassNo", SqlDbType.Char, 4),
new SqlParameter("@ProdClassName", SqlDbType.Char, 60),
new SqlParameter("@Prior", SqlDbType.Int, 4),
new SqlParameter("@ViewInReport", SqlDbType.Bit, 1)
};
parameters[0].Value = model.ProdClassNo;
parameters[1].Value = model.ProdClassName;
parameters[2].Value = model.Prior;
parameters[3].Value = model.ViewInReport;
int rows = DBHelper.ExecuteCommand(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EtNet_Models.ProdClass GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ProdClassNo,ProdClassName,Prior,ViewInReport from ProdClass ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
EtNet_Models.ProdClass model = new EtNet_Models.ProdClass();
DataTable dt = DBHelper.GetDataSet(strSql.ToString(), parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["ProdClassNo"] != null && dt.Rows[0]["ProdClassNo"].ToString() != "")
{
model.ProdClassNo = dt.Rows[0]["ProdClassNo"].ToString();
}
if (dt.Rows[0]["ProdClassName"] != null && dt.Rows[0]["ProdClassName"].ToString() != "")
{
model.ProdClassName = dt.Rows[0]["ProdClassName"].ToString();
}
if (dt.Rows[0]["Prior"] != null && dt.Rows[0]["Prior"].ToString() != "")
{
model.Prior = int.Parse(dt.Rows[0]["Prior"].ToString());
}
if (dt.Rows[0]["ViewInReport"] != null && dt.Rows[0]["ViewInReport"].ToString() != "")
{
if ((dt.Rows[0]["ViewInReport"].ToString() == "1") || (dt.Rows[0]["ViewInReport"].ToString().ToLower() == "true"))
{
model.ViewInReport = true;
}
else
{
model.ViewInReport = false;
}
}
return(model);
}
else
{
return(null);
}
}
