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