/// <summary> /// 更新一条数据 /// </summary> public bool Update(CZB.Model.CCCAPI_ChangeItems model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update CCCAPI_ChangeItems set "); strSql.Append("ItemId=@ItemId,"); strSql.Append("itemName=@itemName,"); strSql.Append("ManualFlag=@ManualFlag,"); strSql.Append("partNo=@partNo,"); strSql.Append("partQuantity=@partQuantity,"); strSql.Append("unitPriceAfterDiscount=@unitPriceAfterDiscount,"); strSql.Append("partFeeAfterDiscount=@partFeeAfterDiscount,"); strSql.Append("depreciation=@depreciation,"); strSql.Append("salvage=@salvage,"); strSql.Append("recycleFlag=@recycleFlag"); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@ItemId", SqlDbType.Decimal, 9), new SqlParameter("@itemName", SqlDbType.NVarChar, 255), new SqlParameter("@ManualFlag", SqlDbType.Bit, 1), new SqlParameter("@partNo", SqlDbType.VarChar, 30), new SqlParameter("@partQuantity", SqlDbType.Decimal, 5), new SqlParameter("@unitPriceAfterDiscount", SqlDbType.Decimal, 9), new SqlParameter("@partFeeAfterDiscount", SqlDbType.Decimal, 9), new SqlParameter("@depreciation", SqlDbType.Decimal, 9), new SqlParameter("@salvage", SqlDbType.Decimal, 9), new SqlParameter("@recycleFlag", SqlDbType.Bit, 1), new SqlParameter("@Id", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.ItemId; parameters[1].Value = model.itemName; parameters[2].Value = model.ManualFlag; parameters[3].Value = model.partNo; parameters[4].Value = model.partQuantity; parameters[5].Value = model.unitPriceAfterDiscount; parameters[6].Value = model.partFeeAfterDiscount; parameters[7].Value = model.depreciation; parameters[8].Value = model.salvage; parameters[9].Value = model.recycleFlag; parameters[10].Value = model.Id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(CZB.Model.CCCAPI_ChangeItems model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CCCAPI_ChangeItems("); strSql.Append("Id,ItemId,itemName,ManualFlag,partNo,partQuantity,unitPriceAfterDiscount,partFeeAfterDiscount,depreciation,salvage,recycleFlag)"); strSql.Append(" values ("); strSql.Append("@Id,@ItemId,@itemName,@ManualFlag,@partNo,@partQuantity,@unitPriceAfterDiscount,@partFeeAfterDiscount,@depreciation,@salvage,@recycleFlag)"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.NVarChar, 50), new SqlParameter("@ItemId", SqlDbType.Decimal, 9), new SqlParameter("@itemName", SqlDbType.NVarChar, 255), new SqlParameter("@ManualFlag", SqlDbType.Bit, 1), new SqlParameter("@partNo", SqlDbType.VarChar, 30), new SqlParameter("@partQuantity", SqlDbType.Decimal, 5), new SqlParameter("@unitPriceAfterDiscount", SqlDbType.Decimal, 9), new SqlParameter("@partFeeAfterDiscount", SqlDbType.Decimal, 9), new SqlParameter("@depreciation", SqlDbType.Decimal, 9), new SqlParameter("@salvage", SqlDbType.Decimal, 9), new SqlParameter("@recycleFlag", SqlDbType.Bit, 1) }; parameters[0].Value = model.Id; parameters[1].Value = model.ItemId; parameters[2].Value = model.itemName; parameters[3].Value = model.ManualFlag; parameters[4].Value = model.partNo; parameters[5].Value = model.partQuantity; parameters[6].Value = model.unitPriceAfterDiscount; parameters[7].Value = model.partFeeAfterDiscount; parameters[8].Value = model.depreciation; parameters[9].Value = model.salvage; parameters[10].Value = model.recycleFlag; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public CZB.Model.CCCAPI_ChangeItems GetModel(string Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,ItemId,itemName,ManualFlag,partNo,partQuantity,unitPriceAfterDiscount,partFeeAfterDiscount,depreciation,salvage,recycleFlag from CCCAPI_ChangeItems "); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.NVarChar, 50) }; parameters[0].Value = Id; CZB.Model.CCCAPI_ChangeItems model = new CZB.Model.CCCAPI_ChangeItems(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(CZB.Model.CCCAPI_ChangeItems model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(CZB.Model.CCCAPI_ChangeItems model) { return(dal.Add(model)); }
/// <summary> /// 得到一个对象实体 /// </summary> public CZB.Model.CCCAPI_ChangeItems DataRowToModel(DataRow row) { CZB.Model.CCCAPI_ChangeItems model = new CZB.Model.CCCAPI_ChangeItems(); if (row != null) { if (row["Id"] != null) { model.Id = row["Id"].ToString(); } if (row["ItemId"] != null && row["ItemId"].ToString() != "") { model.ItemId = decimal.Parse(row["ItemId"].ToString()); } if (row["itemName"] != null) { model.itemName = row["itemName"].ToString(); } if (row["ManualFlag"] != null && row["ManualFlag"].ToString() != "") { if ((row["ManualFlag"].ToString() == "1") || (row["ManualFlag"].ToString().ToLower() == "true")) { model.ManualFlag = true; } else { model.ManualFlag = false; } } if (row["partNo"] != null) { model.partNo = row["partNo"].ToString(); } if (row["partQuantity"] != null && row["partQuantity"].ToString() != "") { model.partQuantity = decimal.Parse(row["partQuantity"].ToString()); } if (row["unitPriceAfterDiscount"] != null && row["unitPriceAfterDiscount"].ToString() != "") { model.unitPriceAfterDiscount = decimal.Parse(row["unitPriceAfterDiscount"].ToString()); } if (row["partFeeAfterDiscount"] != null && row["partFeeAfterDiscount"].ToString() != "") { model.partFeeAfterDiscount = decimal.Parse(row["partFeeAfterDiscount"].ToString()); } if (row["depreciation"] != null && row["depreciation"].ToString() != "") { model.depreciation = decimal.Parse(row["depreciation"].ToString()); } if (row["salvage"] != null && row["salvage"].ToString() != "") { model.salvage = decimal.Parse(row["salvage"].ToString()); } if (row["recycleFlag"] != null && row["recycleFlag"].ToString() != "") { if ((row["recycleFlag"].ToString() == "1") || (row["recycleFlag"].ToString().ToLower() == "true")) { model.recycleFlag = true; } else { model.recycleFlag = false; } } } return(model); }