/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MDL.ProductInfoMDL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ProductInfo(");
strSql.Append("ProductType,ProductCode,ProductName,FeatureIndex,FeatureCode,BarCodeCount,HaveSub,[Desc])");
strSql.Append(" values (");
strSql.Append("@ProductType,@ProductCode,@ProductName,@FeatureIndex,@FeatureCode,@BarCodeCount,@HaveSub,@Desc)");
SqlParameter[] parameters =
{
new SqlParameter("@ProductType", model.ProductType),
new SqlParameter("@ProductCode", model.ProductCode),
new SqlParameter("@ProductName", model.ProductName),
new SqlParameter("@FeatureIndex", model.FeatureIndex),
new SqlParameter("@FeatureCode", model.FeatureCode),
new SqlParameter("@BarCodeCount", model.BarCodeCount),
new SqlParameter("@HaveSub", model.HaveSub),
new SqlParameter("@Desc", model.Desc)
};
int rows = helper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
///// <summary>
///// 得到一个对象实体
///// </summary>
//public MDL.ProductInfoMDL GetModel(string ProductCode)
//{
// StringBuilder strSql = new StringBuilder();
// strSql.Append("select TID,ProductType,ProductCode,ProductName,FeatureIndex,FeatureCode,BarCodeCount,[Desc] from ProductInfo ");
// strSql.Append(" where ProductCode=@ProductCode");
// SqlParameter[] parameters = {
// new SqlParameter("@ProductCode", ProductCode)
// };
// MDL.ProductInfoMDL model = new MDL.ProductInfoMDL();
// DataSet ds = helper.Query(strSql.ToString(), parameters);
// if (ds.Tables[0].Rows.Count > 0)
// {
// return DataRowToModel(ds.Tables[0].Rows[0]);
// }
// else
// {
// return null;
// }
//}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MDL.ProductInfoMDL DataRowToModel(DataRow row)
{
MDL.ProductInfoMDL model = new MDL.ProductInfoMDL();
if (row != null)
{
if (row["TID"] != null && row["TID"].ToString() != "")
{
model.TID = long.Parse(row["TID"].ToString());
}
if (row["ProductType"] != null)
{
model.ProductType = row["ProductType"].ToString();
}
if (row["ProductCode"] != null)
{
model.ProductCode = row["ProductCode"].ToString();
}
if (row["ProductName"] != null)
{
model.ProductName = row["ProductName"].ToString();
}
if (row["FeatureIndex"] != null)
{
model.FeatureIndex = row["FeatureIndex"].ToString();
}
if (row["FeatureCode"] != null)
{
model.FeatureCode = row["FeatureCode"].ToString();
}
if (row["BarCodeCount"] != null)
{
model.BarCodeCount = row["BarCodeCount"].ToString();
}
if (row["HaveSub"] != null && row["HaveSub"].ToString() != "")
{
if ((row["HaveSub"].ToString() == "1") || (row["HaveSub"].ToString().ToLower() == "true"))
{
model.HaveSub = true;
}
else
{
model.HaveSub = false;
}
}
if (row["Desc"] != null)
{
model.Desc = row["Desc"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MDL.ProductInfoMDL GetModel(string where)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select TID,ProductType,ProductCode,ProductName,FeatureIndex,FeatureCode,BarCodeCount,HaveSub,[Desc] from ProductInfo ");
if (!string.IsNullOrEmpty(where))
{
strSql.Append(" where " + where);
}
MDL.ProductInfoMDL model = new MDL.ProductInfoMDL();
DataSet ds = helper.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MDL.ProductInfoMDL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ProductInfo set ");
strSql.Append("ProductType=@ProductType,");
strSql.Append("ProductCode=@ProductCode,");
strSql.Append("ProductName=@ProductName,");
strSql.Append("FeatureIndex=@FeatureIndex,");
strSql.Append("FeatureCode=@FeatureCode,");
strSql.Append("BarCodeCount=@BarCodeCount,");
strSql.Append("HaveSub=@HaveSub,");
strSql.Append("Desc=@Desc");
strSql.Append(" where TID=@TID");
SqlParameter[] parameters =
{
new SqlParameter("@ProductType", model.ProductType),
new SqlParameter("@ProductCode", model.ProductCode),
new SqlParameter("@ProductName", model.ProductName),
new SqlParameter("@FeatureIndex", model.FeatureIndex),
new SqlParameter("@FeatureCode", model.FeatureCode),
new SqlParameter("@BarCodeCount", model.BarCodeCount),
new SqlParameter("@HaveSub", model.HaveSub),
new SqlParameter("@Desc", model.Desc),
new SqlParameter("@TID", model.TID)
};
int rows = helper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MDL.ProductInfoMDL GetModel(long TID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select TID,ProductType,ProductCode,ProductName,FeatureIndex,FeatureCode,BarCodeCount,HaveSub,[Desc] from ProductInfo ");
strSql.Append(" where TID=@TID");
SqlParameter[] parameters =
{
new SqlParameter("@TID", TID)
};
MDL.ProductInfoMDL model = new MDL.ProductInfoMDL();
DataSet ds = helper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MDL.ProductInfoMDL GetModel(string TID, string ProductCode)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
dict.Add("do", "get");
dict.Add("method", "model");
dict.Add("TID", TID);
dict.Add("ProductCode", ProductCode);
string str = Http.POST(requestUrl, dict);
var obj = JsonHelper.JsonDeSerializer <ReturnInfo>(str);
ReturnInfo ReturnData = (ReturnInfo)obj;
if (ReturnData != null && ReturnData.Code == "1")
{
var data = JsonHelper.JsonDeSerializer <MDL.ProductInfoMDL>(ReturnData.Data.ToString());
MDL.ProductInfoMDL Model = (MDL.ProductInfoMDL)data;
return(Model);
}
else
{
return(null);
}
}
