private void BindControl()
{
POItemDAL dal = new POItemDAL();
var poItems = dal.GetPOItemByPOId(POId);
Utility.BindDataToRepeater(rpItems, poItems);
}
protected void btnCreatePurchase_Click(object sender, EventArgs e)
{
//get no
SeedDAL sdal = new SeedDAL();
string no = sdal.GetNoByTableName(SysConst.TablePurchaseOrder, SysConst.SuffixPurchaseOrder);
//get enqordman
string enqOrdMan = string.Empty;
string companyName = string.Empty;
string contact = string.Empty;
string address = string.Empty;
string email = string.Empty;
string qq = string.Empty;
string phone1 = string.Empty;
string phone2 = string.Empty;
string other = string.Empty;
if (string.Equals(SourceType, SysConst.SourceTypeOrder, StringComparison.OrdinalIgnoreCase))
{
OrderDAL soDAL = new OrderDAL();
var so = soDAL.GetOrderByNo(SourceNo);
so.Status = "申请采购";
soDAL.Save();
enqOrdMan = so.OrderMan;
companyName = so.CustomerCompanyName;
contact = so.CustomerContactName;
address = so.CustomerAddress;
email = so.CustomerEmail;
qq = so.CustomerQQ;
phone1 = so.CustomerPhone1;
phone2 = so.CustomerPhone2;
other = so.CustomerOthers;
}
else if (string.Equals(SourceType, SysConst.SourceTypeMaching, StringComparison.OrdinalIgnoreCase))
{
MachiningDAL mDAL = new MachiningDAL();
var mach = mDAL.GetMachByNo(SourceNo);
companyName = mach.CustomerCompanyName;
contact = mach.CustomerContactName;
address = mach.CustomerAddress;
email = mach.CustomerEmail;
qq = mach.CustomerQQ;
phone1 = mach.CustomerPhone1;
phone2 = mach.CustomerPhone2;
other = mach.CustomerOthers;
}
//new refine
PurchaseOrderDAL dal = new PurchaseOrderDAL();
PurchaseOrder po = new PurchaseOrder()
{
Purchase_No = no,
Status = FirstStatusConsts.Purchase,
EnqOrdMan = enqOrdMan,
SourceType = SourceType,
SourceNo = SourceNo,
CreatedDate = DateTime.Now,
CreatedAt = DateTime.Now,
CreatedBy = SMSContext.Current.User.UserName
};
dal.AddPO(po);
dal.Save();
int poid = po.Purchase_Id;
string pono = po.Purchase_No;
//poitem
if (string.Equals(SourceType, SysConst.SourceTypeMaching, StringComparison.OrdinalIgnoreCase))
{
MachiningDAL mDAL = new MachiningDAL();
var mach = mDAL.GetMachByNo(SourceNo);
MachItemDAL miDAL = new MachItemDAL();
var machItems = miDAL.GetMachItemsByMachId(mach.Mach_Id);
POItemDAL pDAL = new POItemDAL();
foreach (var item in machItems)
{
PurchaseOrderItem poItem = new PurchaseOrderItem()
{
Code = item.Code,
Deepth = item.Deepth,
Intro = item.Intro,
Long = item.Long,
PO_Id = poid,
Product_Code = item.Product_Code,
Quantity = item.Quantity,
Square = item.Square,
Width = item.Width
};
pDAL.AddPOItem(poItem);
}
pDAL.Save();
}
string url = Page.ResolveUrl(string.Format("~/PurchaseForm.aspx?poid={0}&pono={1}&sourcetype={2}&sourceno={3}", poid, pono, SourceType, SourceNo));
string script = string.Format("<script>window.open('{0}')</script>", url);
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "createpo", script);
BindControl();
SetFocus(btnCreatePurchase);
}
protected void rpItems_ItemCommand(object source, RepeaterCommandEventArgs e)
{
POItemDAL dal = new POItemDAL();
if (e.Item.ItemType == ListItemType.Header)
{
if (e.CommandName == "Add")
{
TextBox txtIntroAdd = e.Item.FindControl("txtIntroAdd") as TextBox;
TextBox txtProductAdd = e.Item.FindControl("txtProductAdd") as TextBox;
TextBox txtCodeAdd = e.Item.FindControl("txtCodeAdd") as TextBox;
TextBox txtLongAdd = e.Item.FindControl("txtLongAdd") as TextBox;
TextBox txtWidthAdd = e.Item.FindControl("txtWidthAdd") as TextBox;
TextBox txtDeepAdd = e.Item.FindControl("txtDeepAdd") as TextBox;
TextBox txtQtyAdd = e.Item.FindControl("txtQtyAdd") as TextBox;
TextBox txtSquareAdd = e.Item.FindControl("txtSquareAdd") as TextBox;
PurchaseOrderItem item = new PurchaseOrderItem();
item.PO_Id = POId;
item.Intro = txtIntroAdd.Text;
item.Product_Code = txtProductAdd.Text;
item.Code = txtCodeAdd.Text;
item.Long = !string.IsNullOrEmpty(txtLongAdd.Text) ? int.Parse(txtLongAdd.Text) : 0;
item.Width = !string.IsNullOrEmpty(txtWidthAdd.Text) ? int.Parse(txtWidthAdd.Text) : 0;
item.Deepth = !string.IsNullOrEmpty(txtDeepAdd.Text) ? int.Parse(txtDeepAdd.Text) : 0;
item.Quantity = !string.IsNullOrEmpty(txtQtyAdd.Text) ? int.Parse(txtQtyAdd.Text) : 0;
item.Square = !string.IsNullOrEmpty(txtSquareAdd.Text) ? double.Parse(txtSquareAdd.Text) : 0;
dal.AddPOItem(item);
dal.Save();
}
}
if (e.CommandName == "Save")
{
HiddenField hdId = e.Item.FindControl("hdId") as HiddenField;
var item = dal.GetPOItemById(int.Parse(hdId.Value));
TextBox txtIntro = e.Item.FindControl("txtIntro") as TextBox;
TextBox txtProduct = e.Item.FindControl("txtProduct") as TextBox;
TextBox txtCode = e.Item.FindControl("txtCode") as TextBox;
TextBox txtLong = e.Item.FindControl("txtLong") as TextBox;
TextBox txtWidth = e.Item.FindControl("txtWidth") as TextBox;
TextBox txtDeep = e.Item.FindControl("txtDeep") as TextBox;
TextBox txtQty = e.Item.FindControl("txtQty") as TextBox;
TextBox txtSquare = e.Item.FindControl("txtSquare") as TextBox;
TextBox txtRemark = e.Item.FindControl("txtRemark") as TextBox;
item.Intro = txtIntro.Text;
item.Product_Code = txtProduct.Text;
item.Code = txtCode.Text;
item.Long = !string.IsNullOrEmpty(txtLong.Text) ? int.Parse(txtLong.Text) : 0;
item.Width = !string.IsNullOrEmpty(txtWidth.Text) ? int.Parse(txtWidth.Text) : 0;
item.Deepth = !string.IsNullOrEmpty(txtDeep.Text) ? int.Parse(txtDeep.Text) : 0;
item.Quantity = !string.IsNullOrEmpty(txtQty.Text) ? int.Parse(txtQty.Text) : 0;
item.Square = !string.IsNullOrEmpty(txtSquare.Text) ? double.Parse(txtSquare.Text) : 0;
dal.Save();
}
if (e.CommandName == "Delete")
{
HiddenField hdId = e.Item.FindControl("hdId") as HiddenField;
dal.DeletePOItem(int.Parse(hdId.Value));
}
BindControl();
SetFocus(source);
}
