/// <summary>
/// 新增一条进货信息
/// </summary>
/// <param name="errText"></param>
/// <param name="PurchaseDocInfo"></param>
/// <returns></returns>
public int InsertEntity(out string errText, PurchaseDocInfo PurchaseDocInfo)
{
errText = "";
try {
using (SqlConnection conn = new SqlConnection(SQL_CON)) {
var sql = "insert into PurchaseDoc (PurchaseDocId,PurchaseDocNo,SupplierId,PurchaseTime,OperatorId,Price,WarehouseId,Remark) "
+ "values(@PurchaseDocId,@PurchaseDocNo,@SupplierId,@PurchaseTime,@OperatorId,@Price,@WarehouseId,@Remark)";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@PurchaseDocId", PurchaseDocInfo.PurchaseDocId);
cmd.Parameters.AddWithValue("@PurchaseDocNo", PurchaseDocInfo.PurchaseDocNo);
cmd.Parameters.AddWithValue("@SupplierId", PurchaseDocInfo.SupplierId);
cmd.Parameters.AddWithValue("@PurchaseTime", PurchaseDocInfo.PurchaseTime);
cmd.Parameters.AddWithValue("@OperatorId", PurchaseDocInfo.OperatorId);
cmd.Parameters.AddWithValue("@Price", PurchaseDocInfo.Price);
cmd.Parameters.AddWithValue("@WarehouseId", PurchaseDocInfo.WarehouseId);
cmd.Parameters.AddWithValue("@Remark", PurchaseDocInfo.Remark);
var i = cmd.ExecuteNonQuery();
conn.Close();
return(i);
}
} catch (Exception ex) {
errText = ex.Message;
return(0);
}
}
private void btnOk_Click(object sender, EventArgs e)
{
if (!InputValidator())
{
return;
}
var supplier = this.cmboxSupplier.SelectedValue as SupplierInfo;
if (supplier == null)
{
MessageBox.Show("请选择供应商！");
return;
}
var warehouse = this.cmboxWarehouse.SelectedValue as WarehouseInfo;
if (warehouse == null)
{
MessageBox.Show("请选择仓库！");
return;
}
PurchaseDocInfo purchaseDocInfo = new PurchaseDocInfo()
{
PurchaseDocId = _purchaseDocId, PurchaseDocNo = this.lblOrderNo.Text, SupplierId = supplier.SupplierId, PurchaseTime = this.dtPicker1.Value,
OperatorId = _userInfo.Id, WarehouseId = warehouse.WarehouseId, Remark = this.txtboxRemark.Text, Price = Convert.ToInt32(this.lblPrice.Text)
};
var data = this.dataGridView1.DataSource as DataTable;
if (data == null || data.Rows.Count == 0)
{
MessageBox.Show("请选择采购商品！");
return;
}
List <PurchaseDetailDocInfo> details = new List <PurchaseDetailDocInfo>();
foreach (DataRow row in data.Rows)
{
details.Add(new PurchaseDetailDocInfo()
{
PurchaseDetailDocId = (Guid)row["PurchaseDetailDocId"], PurchaseDocId = (Guid)row["PurchaseDocId"],
CommodityId = (Guid)row["CommodityId"], Count = (int)row["Count"], Price = (decimal)row["Price"], Remark = row["Remark"].ToString()
});
}
string errText;
int i = _srv.PurchaseOrder(out errText, purchaseDocInfo, details);
if (i == 0)
{
MessageBox.Show(errText);
return;
}
MessageBox.Show("采购成功！");
InitData();
}
public int PurchaseOrder(out string errText, PurchaseDocInfo purchaseDocInfo, List <PurchaseDetailDocInfo> details)
{
errText = "";
var i = _stockSrv.PurchaseOrderManage(out errText, purchaseDocInfo, details);
if (i <= 0)
{
return(i);
}
i = _dal.InsertEntity(out errText, purchaseDocInfo);
if (i <= 0)
{
return(i);
}
i = PurchaseOrderDetail(out errText, details);
return(i);
}
