/// <summary>
/// 得到一个对象实体
/// </summary>
public MDL.ProductBomInfoMDL DataRowToModel(DataRow row)
{
MDL.ProductBomInfoMDL model = new MDL.ProductBomInfoMDL();
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["MaterialCode"] != null)
{
model.MaterialCode = row["MaterialCode"].ToString();
}
if (row["MaterialName"] != null)
{
model.MaterialName = row["MaterialName"].ToString();
}
if (row["MaterialNum"] != null && row["MaterialNum"].ToString() != "")
{
model.MaterialNum = int.Parse(row["MaterialNum"].ToString());
}
if (row["FeatureIndex"] != null)
{
model.FeatureIndex = row["FeatureIndex"].ToString();
}
if (row["FeatureCode"] != null)
{
model.FeatureCode = row["FeatureCode"].ToString();
}
if (row["BatchNum"] != null && row["BatchNum"].ToString() != "")
{
model.BatchNum = int.Parse(row["BatchNum"].ToString());
}
//if (row["ScannerID"] != null)
//{
// model.ScannerID = row["ScannerID"].ToString();
//}
if (row["TraceType"] != null)
{
model.TraceType = row["TraceType"].ToString();
}
if (row["Desc"] != null)
{
model.Desc = row["Desc"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MDL.ProductBomInfoMDL GetModel(string TID, string ProductType, string ProductCode, string MaterialCode, string TraceType)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
dict.Add("do", "get");
dict.Add("method", "model");
dict.Add("TID", TID);
dict.Add("ProductType", ProductType);
dict.Add("ProductCode", ProductCode);
dict.Add("MaterialCode", MaterialCode);
dict.Add("TraceType", TraceType);
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.ProductBomInfoMDL>(ReturnData.Data.ToString());
MDL.ProductBomInfoMDL Model = (MDL.ProductBomInfoMDL)data;
return(Model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MDL.ProductBomInfoMDL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into productbominfo(");
strSql.Append("ProductType,ProductCode,ProductName,MaterialCode,MaterialName,MaterialNum,FeatureIndex,FeatureCode,BatchNum,TraceType,[Desc] )");
strSql.Append(" values (");
strSql.Append("@ProductType,@ProductCode,@ProductName,@MaterialCode,@MaterialName,@MaterialNum,@FeatureIndex,@FeatureCode,@BatchNum,@TraceType,@Desc)");
SqlParameter[] parameters =
{
new SqlParameter("@ProductType", model.ProductType),
new SqlParameter("@ProductCode", model.ProductCode),
new SqlParameter("@ProductName", model.ProductName),
new SqlParameter("@MaterialCode", model.MaterialCode),
new SqlParameter("@MaterialName", model.MaterialName),
new SqlParameter("@MaterialNum", model.MaterialNum),
new SqlParameter("@FeatureIndex", model.FeatureIndex),
new SqlParameter("@FeatureCode", model.FeatureCode),
new SqlParameter("@BatchNum", model.BatchNum),
//new SqlParameter("@ScannerID", model.ScannerID),
new SqlParameter("@TraceType", model.TraceType),
new SqlParameter("@Desc", model.Desc)
};
int rows = helper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MDL.ProductBomInfoMDL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update productbominfo set ");
strSql.Append("ProductType=@ProductType,");
strSql.Append("ProductCode=@ProductCode,");
strSql.Append("ProductName=@ProductName,");
strSql.Append("MaterialCode=@MaterialCode,");
strSql.Append("MaterialName=@MaterialName,");
strSql.Append("MaterialNum=@MaterialNum,");
strSql.Append("FeatureIndex=@FeatureIndex,");
strSql.Append("FeatureCode=@FeatureCode,");
strSql.Append("BatchNum=@BatchNum,");
//strSql.Append("ScannerID=@ScannerID,");
strSql.Append("TraceType=@TraceType,");
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("@MaterialCode", model.MaterialCode),
new SqlParameter("@MaterialName", model.MaterialName),
new SqlParameter("@MaterialNum", model.MaterialNum),
new SqlParameter("@FeatureIndex", model.FeatureIndex),
new SqlParameter("@FeatureCode", model.FeatureCode),
new SqlParameter("@BatchNum", model.BatchNum),
//new SqlParameter("@ScannerID", model.ScannerID),
new SqlParameter("@TraceType", model.TraceType),
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.ProductBomInfoMDL GetModel(string where)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select TOP 1 TID,ProductType,ProductCode,ProductName,MaterialCode,MaterialName,MaterialNum,FeatureIndex,FeatureCode,BatchNum,TraceType,[Desc] from productbominfo ");
if (!string.IsNullOrEmpty(where))
{
strSql.Append(" where " + where);
}
MDL.ProductBomInfoMDL model = new MDL.ProductBomInfoMDL();
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 MDL.ProductBomInfoMDL GetModel(long TID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select TID,ProductType,ProductCode,ProductName,MaterialCode,MaterialName,MaterialNum,FeatureIndex,FeatureCode,BatchNum,TraceType,[Desc] from productbominfo ");
strSql.Append(" where TID=@TID");
SqlParameter[] parameters =
{
new SqlParameter("@TID", TID)
};
MDL.ProductBomInfoMDL model = new MDL.ProductBomInfoMDL();
DataSet ds = helper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
