/// <summary>
/// 查询添加成功的表单查询
/// </summary>
/// <returns></returns>
public static List <SaveOutDetail> CheckGridView(string OutID)
{
Database db = DatabaseFactory.CreateDatabase("Constr");
string sql = string.Format(@"select t_OutStockDetail.DetailID,ps.ProductsID,ProductsName,Quantity,Price,Price*Quantity Total
from t_OutStockDetail join (select p.ProductsID,p.ProductsName from
(select distinct p.ProductsID,p.ProductsName from t_OutStockDetail s
join t_Products p on s.ProductsID=p.ProductsID ) p
) ps on t_OutStockDetail.ProductsID=ps.ProductsID
and t_OutStockDetail.OutID ='{0}'", OutID);
DataSet ds = db.ExecuteDataSet(CommandType.Text, sql);
List <SaveOutDetail> list = new List <SaveOutDetail>();
foreach (DataRow item in ds.Tables[0].Rows)
{
SaveOutDetail s = new SaveOutDetail();
s.DetailID = int.Parse(item["DetailID"].ToString());
s.ProductsID = int.Parse(item["ProductsID"].ToString());
s.ProductsName = item["ProductsName"].ToString();
//s.SupplierName = item["SupplierName"].ToString();
s.Quantity = int.Parse(item["Quantity"].ToString());
s.Price = Convert.ToDouble(item["Price"].ToString());
s.Total = Convert.ToDouble(item["Total"].ToString());
list.Add(s);
}
return(list);
}
/// <summary>
/// 添加编辑的信息到保存表里
/// </summary>
/// <param name="supplyname"></param>
/// <returns></returns>
public static bool AddMessage(SaveOutDetail save)
{
Database db = DatabaseFactory.CreateDatabase("Constr");
string sql = string.Format(@"insert into t_OutStockDetail values('{0}',{1},{2},'{3}','{4}')",
save.OutID, save.ProductsID, save.Quantity, save.Price, save.Description == "" ? " " : save.Description);
return(db.ExecuteNonQuery(CommandType.Text, sql) > 0);
}
//点击保存 保存信息
protected void btnSave_Click(object sender, EventArgs e)
{
SaveOutDetail save = new SaveOutDetail();
save.OutID = this.txtOrderID.Text;
save.ProductsID = int.Parse(this.ProID.Text);
save.ProductsName = this.txtPro.Text;
//save.SupplierID = BLL.PIntoBLL.ProIntoManager.GetSupplierID(this.txtSupply.Text);
save.Quantity = int.Parse(this.txtCount.Text);
save.Price = Convert.ToDouble(this.txtPrice.Text);
save.Total = Convert.ToDouble(this.txtPrice.Text) * int.Parse(this.txtCount.Text);
if (BLL.POutBLL.POutManager.AddMessage(save))
{
this.GridViewMessage.DataSource = BLL.POutBLL.POutManager.CheckGridView(save.OutID);
this.GridViewMessage.DataBind();
}
else
{
Response.Write("<script>alert('添加信息失败')</script>");
}
}
//添加编辑的信息到保存表里
public static bool AddMessage(SaveOutDetail save)
{
return(DAL.POutDAL.POutService.AddMessage(save));
}
