/// <summary>
/// 增加一条数据
/// </summary>
public int AddProductPriceNOAuto(ProductPriceNOAutoInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tbProductPriceNOAutoInfo(");
strSql.Append("ProductsID,Price,PriceRMB,ppAppendTime)");
strSql.Append(" values (");
strSql.Append("@ProductsID,@Price,@PriceRMB,Getdate())");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ProductsID", SqlDbType.Int),
new SqlParameter("@Price", SqlDbType.Money),
new SqlParameter("@PriceRMB", SqlDbType.Money),
};
parameters[0].Value = model.ProductsID;
parameters[1].Value = model.Price;
parameters[2].Value = model.PriceRMB;
object obj = DbHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters);
if (obj == null)
{
return(-1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ProductPriceNOAutoInfo GetProductPriceNOAutoModel(int ProductPriceNOAutoID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ProductPriceNOAutoID,ProductsID,Price,PriceRMB,ppAppendTime from tbProductPriceNOAutoInfo ");
strSql.Append(" where ProductPriceNOAutoID=@ProductPriceNOAutoID ");
SqlParameter[] parameters =
{
new SqlParameter("@ProductPriceNOAutoID", SqlDbType.Int)
};
parameters[0].Value = ProductPriceNOAutoID;
ProductPriceNOAutoInfo model = new ProductPriceNOAutoInfo();
DataSet ds = DbHelper.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ProductPriceNOAutoID"].ToString() != "")
{
model.ProductPriceNOAutoID = int.Parse(ds.Tables[0].Rows[0]["ProductPriceNOAutoID"].ToString());
}
if (ds.Tables[0].Rows[0]["ProductsID"].ToString() != "")
{
model.ProductsID = int.Parse(ds.Tables[0].Rows[0]["ProductsID"].ToString());
}
if (ds.Tables[0].Rows[0]["Price"].ToString() != "")
{
model.Price = decimal.Parse(ds.Tables[0].Rows[0]["Price"].ToString());
}
if (ds.Tables[0].Rows[0]["PriceRMB"].ToString() != "")
{
model.PriceRMB = decimal.Parse(ds.Tables[0].Rows[0]["PriceRMB"].ToString());
}
if (ds.Tables[0].Rows[0]["ppAppendTime"].ToString() != "")
{
model.ppAppendTime = DateTime.Parse(ds.Tables[0].Rows[0]["ppAppendTime"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void UpdateProductPriceNOAuto(ProductPriceNOAutoInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tbProductPriceNOAutoInfo set ");
strSql.Append("ProductsID=@ProductsID,");
strSql.Append("Price=@Price,");
strSql.Append("PriceRMB=@PriceRMB,");
strSql.Append("ppAppendTime=GETDATE()");
strSql.Append(" where ProductPriceNOAutoID=@ProductPriceNOAutoID ");
SqlParameter[] parameters =
{
new SqlParameter("@ProductPriceNOAutoID", SqlDbType.Int),
new SqlParameter("@ProductsID", SqlDbType.Int),
new SqlParameter("@Price", SqlDbType.Money),
new SqlParameter("@PriceRMB", SqlDbType.Money),
};
parameters[0].Value = model.ProductPriceNOAutoID;
parameters[1].Value = model.ProductsID;
parameters[2].Value = model.Price;
parameters[3].Value = model.PriceRMB;
DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);
}
public bool ShowProductCostPrice = false; //是否显示成本
protected virtual void Page_Load(object sender, EventArgs e)
{
if (this.userid > 0)
{
if (CheckUserPopedoms("X"))
{
Act = HTTPRequest.GetString("Act");
//邮件校验码
if (HTTPRequest.GetString("rCode") != "")
{
Session ["r_Code"] = HTTPRequest.GetString("rCode");
}
string _rCode = Session["r_Code"] != null?Convert.ToString(Session["r_Code"]) : ""; //邮件获取
string s_rCode = Session["s_r_Code"] != null?Convert.ToString(Session["s_r_Code"]) : ""; //本地校验
if (_rCode == "" || _rCode != s_rCode)
{
string s_r_Code = s_rCode.Trim() != ""?s_rCode: MakeCode(6); //生成6位验证码
if (Act == "SendCode")
{
Session ["s_r_Code"] = s_r_Code;
UsersUtils.SendMailToEmail(config.ProductCostPriceCodeMail, "商品成本维护校验码", "请在10分钟内输入商品成本维护校验码:<b>" + s_r_Code + "</b>");
Response.ClearContent();
Response.Buffer = true;
Response.ExpiresAbsolute = System.DateTime.Now.AddYears(-1);
Response.Expires = 0;
Response.Write("{state:true,msg:\"OK!\"}");
Response.End();
}
if (Act.Trim() == "UpdatePrice")
{
Response.ClearContent();
Response.Buffer = true;
Response.ExpiresAbsolute = System.DateTime.Now.AddYears(-1);
Response.Expires = 0;
Response.Write("{state:false,msg:\"No Code!\"}");
Response.End();
}
else
{
ShowRCodeInput(s_r_Code);
} //AddErrLine ("请输入授权码!");
}
else
{
//仓库分类树
StorageClassJson = Caches.GetStorageInfoToJson(-1, false, true);
Aclass = HTTPRequest.GetString("aclass");
if (Aclass.IndexOf("aclass") > -1)
{
string sID = "";
string sCode = "";
string sName = "";
//获得仓库分类编号
StorageClassID = HTTPRequest.GetString("sClassID");
//获得仓库名称、编号、系统编号
StorageName = tbStockProductInfo.getStorageNameByClass(Convert.ToInt32(StorageClassID));
for (int i = 0; i < StorageName.Rows.Count; i++)
{
if (StorageName.Rows [i] ["sState"].ToString() == "0")
{
sName += StorageName.Rows [i] ["sName"].ToString() + "(" + StorageName.Rows [i] ["sCode"].ToString() + ")" + ",";
sID += StorageName.Rows [i] ["StorageID"].ToString() + ",";
sCode += StorageName.Rows [i] ["sCode"].ToString() + ",";
}
}
Response.ClearContent();
Response.Buffer = true;
Response.ExpiresAbsolute = System.DateTime.Now.AddYears(-1);
Response.Expires = 0;
Response.Write("{sID:'" + sID + "',sCode:'" + sCode + "',sName:'" + sName + "'}");
Response.End();
}
StorageID = HTTPRequest.GetInt("StorageID", 0);
sDate = HTTPRequest.GetString("sDate").Trim() != "" ? Convert.ToDateTime(HTTPRequest.GetString("sDate").Trim() + " 23:59:59") : DateTime.Now;
//显示列表
if (Act.Trim() != "")
{
className = HTTPRequest.GetString("StorageClassName").Trim();
StorageClassID = HTTPRequest.GetString("StorageClassNum");
if (StorageClassID == "")
{
AddMsgLine("请选择仓库类别后再进行查询!");
}
else
{
priceList = tbProductPriceNOAuto.GetProductPriceNOAutoListNew("").Tables [0];
StorageName = tbStockProductInfo.getStorageNameByClass(Convert.ToInt32(StorageClassID));
if (StorageID == 0)
{
dList = tbProductsInfo.GetProductsStorageInfoByStorageID(Convert.ToInt32(StorageClassID), StorageID, sDate, ProductID);
}
else
{
dList = tbProductsInfo.GetProductsStorageInfoByStorageID(0, StorageID, sDate, ProductID); // DataUtils.GetStock_analysis(0, DateTime.Now, ProductID);
}
if (dList.Rows.Count > 0)
{
DataColumn dc = dList.Columns.Add("pPrice", Type.GetType("System.Decimal"));
dc.DefaultValue = 0;
DataColumn dc2 = dList.Columns.Add("pPriceRMB", Type.GetType("System.Decimal"));
dc2.DefaultValue = 0;
for (int k = 0; k < priceList.Rows.Count; k++)
{
for (int j = 0; j < dList.Rows.Count; j++)
{
if (dList.Rows [j] ["ProductsID"].ToString() == priceList.Rows [k] ["ProductsID"].ToString())
{
dList.Rows [j] ["pPrice"] = Convert.ToDecimal(priceList.Rows [k] ["Price"]);
dList.Rows [j] ["pPriceRMB"] = Convert.ToDecimal(priceList.Rows [k] ["PriceRMB"]);
}
}
}
dList.AcceptChanges();
}
}
}
//更新成本
if (Act == "UpdatePrice")
{
ProductID = HTTPRequest.GetInt("ProductID", 0);
Price = Convert.ToDecimal(HTTPRequest.GetFloat("Price", 0));
PriceRMB = Convert.ToDecimal(HTTPRequest.GetFloat("PriceRMB", 0));
if (ProductID > 0)
{
ProductPriceNOAutoInfo pp = new ProductPriceNOAutoInfo();
pp.ProductsID = ProductID;
pp.Price = Price;
pp.PriceRMB = PriceRMB;
pp.ppAppendTime = DateTime.Now;
if (tbProductPriceNOAuto.AddProductPriceNOAuto(pp) > 0)
{
Response.ClearContent();
Response.Buffer = true;
Response.ExpiresAbsolute = System.DateTime.Now.AddYears(-1);
Response.Expires = 0;
Response.Write("{state:true,ProductsID:" + ProductID + ",Price:" + Price + "}");
Response.End();
}
}
}
if (ispost)
{
Act = HTTPRequest.GetFormString("Act");
S_key = Utils.ChkSQL(HTTPRequest.GetFormString("S_key"));
}
else
{
S_key = Utils.ChkSQL(HTTPRequest.GetQueryString("S_key"));
//导出
if (Act.IndexOf("Export") > -1)
{
DataTable dt = dList.Copy();
if (dt.Rows.Count > 0)
{
for (int j = 0; j < dt.Rows.Count; j++)
{
dt.Rows[j]["pStorage"] = (Convert.ToDecimal(dt.Rows[j]["pStorage"].ToString()) + Convert.ToDecimal(dt.Rows[j]["pStorageIn"].ToString()) - Convert.ToDecimal(dt.Rows[j]["pStorageOut"].ToString()) + Convert.ToDecimal(dt.Rows[j]["Beginning"].ToString())).ToString();
}
dt.AcceptChanges();
dt.Columns.RemoveAt(0);
dt.Columns.RemoveAt(0);
dt.Columns.RemoveAt(6);
dt.Columns.RemoveAt(6);
dt.Columns.RemoveAt(6);
dt.Columns.RemoveAt(7);
DataSet dset = new DataSet();
dt.Columns["sName"].SetOrdinal(0);
dset.Tables.Add(dt);
dset.Tables[0].Columns[0].ColumnName = "仓库名称";
dset.Tables[0].Columns[1].ColumnName = "商品条码";
dset.Tables[0].Columns[2].ColumnName = "商品名称";
dset.Tables[0].Columns[3].ColumnName = "默认售价";
dset.Tables[0].Columns[4].ColumnName = "库存数量";
dset.Tables[0].Columns[5].ColumnName = "入库未核销";
dset.Tables[0].Columns[6].ColumnName = "出库未核销";
dset.Tables[0].Columns[7].ColumnName = "不可用库存";
dset.Tables[0].Columns[8].ColumnName = "成本(€)";
dset.Tables[0].Columns[9].ColumnName = "成本(¥)";
CreateExcel(dset.Tables[0], "Data_" + sDate.ToShortDateString() + ".xls");
}
else
{
AddErrLine("请选择仓库类别后再进行查询!");
}
}
}
}
}
else
{
AddErrLine("权限不足!");
}
}
else
{
AddErrLine("请先登录!");
SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer()));
}
}
public static void UpdateProductPriceNOAuto(ProductPriceNOAutoInfo model)
{
DatabaseProvider.GetInstance().UpdateProductPriceNOAuto(model);
}
public static int AddProductPriceNOAuto(ProductPriceNOAutoInfo model)
{
return(DatabaseProvider.GetInstance().AddProductPriceNOAuto(model));
}