protected void btnSave_Click(object sender, EventArgs e) { SaleRecordInfo saleRecord = new SaleRecordInfo(); saleRecord.SalePrice = TransMoney(this.txtSalePrice.Text); saleRecord.Discount = TransMoney(this.txtDiscount.Text); saleRecord.CouponsNo = this.txtCouponsNo.Text; saleRecord.CouponsPrice = TransMoney(this.txtCouponsMoney.Text); saleRecord.CashMoney = TransMoney(this.txtCashMoney.Text); saleRecord.VisaMoney = TransMoney(this.txtVisaCardMoney.Text); saleRecord.UserCardMoney = TransMoney(this.txtUserCardMoney.Text); saleRecord.TrueMoney = TransMoney(this.txtTrueMoney.Text); saleRecord.CustomerName = this.txtCustomerName.Text; saleRecord.CustomerPhone = this.txtCustomerPhone.Text; saleRecord.InVoiceNo = this.txtInvoiceNo.Text; saleRecord.Bz = this.txtBz.Text; saleRecord.SaleLsh = System.DateTime.Now.ToString("yyyyMMddHHmmss"); string loginuser = "******"; saleRecord.Sales = loginuser; saleRecord.ShopId = 2; FT.DAL.Orm.SimpleOrmOperator.Create(saleRecord); string sql = ""; FT.DAL.IDataAccess access = FT.DAL.DataAccessFactory.GetDataAccess(); object id = access.SelectScalar("select id from SaleRecord where SaleLsh='" + saleRecord.SaleLsh + "'"); ArrayList lists = ViewState[Sale_List] as ArrayList; for (int i = 0; i < lists.Count; i++) { Console.Write(id.ToString()); Console.Write(lists[i].ToString()); sql = "insert into Sale_Product(SaleId,ProductId,State) values(" + id.ToString() + "," + lists[i].ToString() + ",'" + ProductStateEnum.BeginSaleString + "')"; access.ExecuteSql(sql); sql = "update Product set ProductStatus=" + ProductStateEnum.BeginSaleInt + ",State='" + ProductStateEnum.BeginSaleString + "' where Product_Id=" + lists[i].ToString(); access.ExecuteSql(sql); } //FT.Commons.Tools.WebFormHelper.WriteScript(this, "<script language='javascript'>printSaleDetail();</script>"); // MagicAjax.AjaxCallHelper.WriteSetHtmlOfPageScript("<script language='javascript'>alert('请选择目标门店!');</script>"); ClientScript.RegisterStartupScript(this.GetType(), "tip", "<script>alert('保存成功!');</script>"); }
protected void btnSave_Click(object sender, EventArgs e) { SaleRecordInfo saleRecord = new SaleRecordInfo(); saleRecord.SalePrice = TransMoney(this.txtSalePrice.Text); saleRecord.Discount = TransMoney(this.txtDiscount.Text); saleRecord.CouponsNo = this.txtCouponsNo.Text; saleRecord.CouponsPrice = TransMoney(this.txtCouponsMoney.Text); saleRecord.CashMoney = TransMoney(this.txtCashMoney.Text); saleRecord.VisaMoney = TransMoney(this.txtVisaCardMoney.Text); saleRecord.UserCardMoney = TransMoney(this.txtUserCardMoney.Text); saleRecord.TrueMoney = TransMoney(this.txtTrueMoney.Text); saleRecord.CustomerName = this.txtCustomerName.Text; saleRecord.CustomerPhone = this.txtCustomerPhone.Text; saleRecord.InVoiceNo = this.txtInvoiceNo.Text; saleRecord.Bz = this.txtBz.Text; saleRecord.SaleLsh = System.DateTime.Now.ToString("yyyyMMddHHmmss"); string loginuser = "******"; saleRecord.Sales = loginuser; saleRecord.ShopId = 2; FT.DAL.Orm.SimpleOrmOperator.Create(saleRecord); string sql = ""; FT.DAL.IDataAccess access = FT.DAL.DataAccessFactory.GetDataAccess(); object id = access.SelectScalar("select id from SaleRecord where SaleLsh='" + saleRecord.SaleLsh + "'"); ArrayList lists = ViewState[Sale_List] as ArrayList; for (int i = 0; i < lists.Count; i++) { Console.Write(id.ToString()); Console.Write(lists[i].ToString()); sql = "insert into Sale_Product(SaleId,ProductId,State) values(" + id.ToString() + "," + lists[i].ToString() + ",'"+ProductStateEnum.BeginSaleString+"')"; access.ExecuteSql(sql); sql = "update Product set ProductStatus="+ProductStateEnum.BeginSaleInt+",State='"+ProductStateEnum.BeginSaleString+"' where Product_Id=" + lists[i].ToString(); access.ExecuteSql(sql); } //FT.Commons.Tools.WebFormHelper.WriteScript(this, "<script language='javascript'>printSaleDetail();</script>"); // MagicAjax.AjaxCallHelper.WriteSetHtmlOfPageScript("<script language='javascript'>alert('请选择目标门店!');</script>"); ClientScript.RegisterStartupScript(this.GetType(), "tip", "<script>alert('保存成功!');</script>"); }