//生成入库订单
protected void btnCreate_Click(object sender, EventArgs e)
{
//1.获取数据发送到DAL
//2.p判断返回值，是否新增成功
//3.把按钮隐藏
this.btnCreate.Visible = false;
//4.显示panel
//this.Panel1.Visible = true;
SaveOutMessage s = new SaveOutMessage();
s.OutID = this.txtOrderID.Text;
s.CreateDate = this.txtMakeDate.Text;
s.OutType = int.Parse(this.DDLIntoType.SelectedValue);
s.StoreHouseID = int.Parse(this.txtHouse.Text);
s.HouseDetailID = int.Parse(this.txtArea.Text);
s.UserName = Session["UserName"].ToString(); //当前登录人的名字
s.TradeDate = this.DateTime1.Value; //选择日期
s.AlreadyPay = Convert.ToDouble(this.txtPay.Text);
s.Description = this.txtDec.Text;
bool b = BLL.POutBLL.POutManager.SaveAllOut(s);
if (b)
{
//显示下面的表格
}
}
//点击生成入库订单 添加主要信息到数据库
public static bool SaveAllOut(SaveOutMessage s)
{
Database db = DatabaseFactory.CreateDatabase("Constr");
string sql = string.Format(@"insert into t_OutStock (OutID,CreateDate,OutType,StoreHouseID,HouseDetailID,TradeDate,TotalPrice,AlreadyPay,Description,AuditingUser,UserName) values
('{0}','{1}',{2},{3},{4},'{5}',{6},{7},'{8}','{9}','{10}')",
s.OutID, s.CreateDate, s.OutType, s.StoreHouseID, s.HouseDetailID, s.TradeDate, s.TotalPrice, s.AlreadyPay, s.Description, s.AuditingUser, s.UserName);
return(db.ExecuteNonQuery(CommandType.Text, sql) > 0);
}
//查询 显示信息到出库明细单
public static SaveOutMessage GetDetails(string OutID)
{
Database db = DatabaseFactory.CreateDatabase("Constr");
string sql = string.Format(@"select t_OutStock.OutID,t_OutStock.CreateDate,t_OutStock.UserName,
t_OutStock.HouseDetailID,t_OutStock.StoreHouseID,t_OutStock.TradeDate,
t_OutStock.TotalPrice,t_OutStock.State,t_OutStock.Description from t_OutStock where t_OutStock.OutID='{0}'", OutID);
DataSet ds = db.ExecuteDataSet(CommandType.Text, sql);
SaveOutMessage s = new SaveOutMessage();
s.OutID = ds.Tables[0].Rows[0]["OutID"].ToString();
s.CreateDate = ds.Tables[0].Rows[0]["CreateDate"].ToString();
s.UserName = ds.Tables[0].Rows[0]["UserName"].ToString();
s.HouseDetailID = int.Parse(ds.Tables[0].Rows[0]["HouseDetailID"].ToString());
s.StoreHouseID = int.Parse(ds.Tables[0].Rows[0]["StoreHouseID"].ToString());
s.HouseStore = GetHouseStore(s.HouseDetailID, s.StoreHouseID);
s.TotalPrice = Convert.ToDouble(ds.Tables[0].Rows[0]["TotalPrice"].ToString());
s.State = int.Parse(ds.Tables[0].Rows[0]["State"].ToString());
s.TradeDate = ds.Tables[0].Rows[0]["TradeDate"].ToString();
return(s);
}
public void ShowDetailInfo(string outID)
{
SaveOutMessage s = BLL.POutBLL.POutManager.GetDetails(outID);
this.txtID.Text = s.OutID;
this.txtCreateDate.Text = s.TradeDate;
this.txtPeople.Text = s.UserName;
this.txtHouse.Text = s.HouseStore.ToString();
this.txtTotal.Text = s.TotalPrice.ToString();
if (s.State == 1)
{
this.txtState.Text = "未审核";
this.txtState.ForeColor = System.Drawing.Color.Red;
}
else
{
this.txtState.Text = "已审核";
this.txtState.ForeColor = System.Drawing.Color.Green;
}
this.txtTradeDate.Text = s.TradeDate;
this.txtDesc.Text = s.Description;
}
//点击生成入库订单 添加主要信息到数据库
public static bool SaveAllOut(SaveOutMessage s)
{
return(DAL.POutDAL.POutService.SaveAllOut(s));
}
