private void DoMain(string[] aList) { List <string> Alist = new List <string>(); str_bill_id = CommadMethod.getNextId("00000000", ""); InsertCommandBuilder insert3 = new InsertCommandBuilder("pre_str_in_bill"); insert3.InsertColumn("str_in_bill_id", str_bill_id); insert3.InsertColumn("str_in_type_id", "C"); insert3.InsertColumn("str_in_bill_no", aList[0].Trim() + aList[2].Trim().Substring(2, 6) + Convert.ToInt32(aList[3].Trim()).ToString()); insert3.InsertColumn("operator_date", "getdate()"); insert3.InsertColumn("str_in_date", "getdate()"); insert3.InsertColumn("store_id", "03");//store_id);//暂时固定为03 insert3.InsertColumn("create_user", "0000"); insert3.InsertColumn("operator_id", "0000"); //insert3.InsertColumn("come_from", aList[1]); insert3.InsertColumn("islocal", "y"); //insert.InsertColumn("is_state", "N"); Alist.Add(insert3.getInsertCommand()); InsertCommandBuilder ins = new InsertCommandBuilder("pre_str_in_bill_detail"); ins.InsertColumn("batch_id", CommadMethod.getNextId("00000000", "")); ins.InsertColumn("str_in_bill_id", str_bill_id); ins.InsertColumn("goods_id", new SelectCommandBuilder().ExecuteDataTable("select goods_id from goods where goods_name='" + goodsName + "'").Rows[0][0].ToString()); ins.InsertColumn("qty", Qty); ins.InsertColumn("hwh", hwh); ins.InsertColumn("pch", aList[2]); Alist.Add(ins.getInsertCommand()); ins.ExcutTransaction(Alist); sList.Insert(0, AppendDateTime("部番:" + goodsName + " 数量:" + Qty)); sList.Insert(0, AppendDateTime("OK,条码???")); }
protected void dgvMaterailList_RowUpdating(object sender, GridViewUpdateEventArgs e) { string name = (dgvMaterailList.Rows[e.RowIndex].FindControl("Label1") as Label).Text; double price = Convert.ToDouble((dgvMaterailList.Rows[e.RowIndex].FindControl("txtPrice") as TextBox).Text); string currency = (dgvMaterailList.Rows[e.RowIndex].FindControl("ddlcurrency") as DropDownList).SelectedItem.Text; double exchangeRate = getexchangeRate(currency); UpdateCommandBuilder u = new UpdateCommandBuilder("materials"); u.UpdateColumn("new_price", price); u.UpdateColumn("wb_name", currency); u.ConditionsColumn("name", name); string mainSql = u.getUpdateCommand(); InsertCommandBuilder insert = new InsertCommandBuilder("materials_newest_price"); insert.InsertColumn("name", name); insert.InsertColumn("price", price); insert.InsertColumn("wb_name", currency); insert.InsertColumn("exchange_rate", exchangeRate); insert.InsertColumn("update_date", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); string insertSql = insert.getInsertCommand(); List <string> sList = new List <string>(); sList.Add(mainSql); sList.Add(insertSql); int i = insert.ExcutTransaction(sList); if (i != 0) { dgvMaterailList.EditIndex = -1; if (string.IsNullOrEmpty(txtName.Value.Trim()) && ddlVendorList.SelectedItem.Value.Trim() == "0") { dgvMaterailList.DataSource = getIndexPageData(); } else { dgvMaterailList.DataSource = getIndexPageData(txtName.Value.Trim(), ddlVendorList.SelectedItem.Value.Trim()); } dgvMaterailList.DataBind(); } }
protected void btnSave_Click(object sender, EventArgs e) { try { if (ViewState["name"].ToString() != txtgoodsName.Text.Trim()) { Response.Write("<script>alert('添加记录请点击新增按钮!')</script>"); return; } List <string> SqlList = new List <string>(); string Usql = getUpdateDataSQL("goods_tmp", ViewState["id"].ToString()); int count = 0; if (Rbt4M.Checked == true) { string Tsql = getUpdateDataSQL("goods_tran", hifId.Value); string Csql = getUpdateDataSQL("goods_chage_record", txtgoodsName.Text.Trim().ToUpper(), txtVersion.Text.Trim().ToUpper().ToUpper()); SqlList.Add(Tsql); SqlList.Add(Csql); } SqlList.Add(Usql); InsertCommandBuilder up = new InsertCommandBuilder(constr, ""); count = up.ExcutTransaction(SqlList); if (count != 0) { dgvList.DataSource = getConfirmGoodsList(ViewState["id"].ToString()); dgvList.DataBind(); Response.Write("<script>alert('保存成功!')</script>"); } else { Response.Write("<script>alert('保存失败!')</script>"); } } catch (Exception ex) { Response.Write("<script>alert('" + ex.Message + "!')</script>"); } }
protected void btnSave_Click(object sender, EventArgs e) { try { if (AddList.Count == 0) { ClientScript.RegisterClientScriptBlock(ClientScript.GetType(), "alert", "<script>alert('无数据')</script>", false); return; } if (string.IsNullOrEmpty(txtInternalNo.Text)) { ClientScript.RegisterClientScriptBlock(ClientScript.GetType(), "alert", "<script>alert('输入社内编号')</script>", false); txtInternalNo.Focus(); return; } if (string.IsNullOrEmpty(txtDate.Text)) { ClientScript.RegisterClientScriptBlock(ClientScript.GetType(), "alert", "<script>alert('输入声请日期')</script>", false); txtDate.Focus(); return; } List <string> sqlList = new List <string>(); InsertCommandBuilder ins = new InsertCommandBuilder("m_materails_apply"); string applyNo = CommadMethod.getNextId("APN" + DateTime.Now.ToString("yyyyMMdd"), "").Trim(); ins.InsertColumn("apply_no", applyNo); if (!string.IsNullOrEmpty(txtModeNo.Text)) { ins.InsertColumn("mode_no", txtModeNo.Text); } ins.InsertColumn("internal_no", txtInternalNo.Text); ins.InsertColumn("type", cbxNomal.Checked == true ? 1 : 2); ins.InsertColumn("apply_date", "getdate()"); ins.InsertColumn("apply_by", "0000"); if (!string.IsNullOrEmpty(txtRemark.Text)) { ins.InsertColumn("remark", txtRemark.Text); } ins.InsertColumn("is_confirm", "N"); for (int i = 0; i < AddList.Count; i++) { InsertCommandBuilder insDetail = new InsertCommandBuilder("m_materails_apply_detail"); insDetail.InsertColumn("apply_no", applyNo); insDetail.InsertColumn("name", AddList[i].name); insDetail.InsertColumn("texture", AddList[i].cz); insDetail.InsertColumn("spec", AddList[i].spec); insDetail.InsertColumn("qty", AddList[i].qty); insDetail.InsertColumn("is_check", 'N'); sqlList.Add(insDetail.getInsertCommand()); } sqlList.Add(ins.getInsertCommand()); int count = ins.ExcutTransaction(sqlList); if (count != 0) { ClientScript.RegisterClientScriptBlock(ClientScript.GetType(), "alert", "<script>alert('保存成功')</script>", false); txtModeNo.Text = string.Empty; txtDate.Text = string.Empty; txtInternalNo.Text = string.Empty; txtRemark.Text = string.Empty; cbxNomal.Checked = false; cbxSpec.Checked = false; AddList.Clear(); gvAddData.DataSource = null; gvAddData.DataBind(); } else { ClientScript.RegisterClientScriptBlock(ClientScript.GetType(), "alert", "<script>alert('保存失败')</script>", false); } } catch (Exception ex) { ClientScript.RegisterClientScriptBlock(ClientScript.GetType(), "alert", "<script>alert('" + ex.Message + "')</script>", false); } }
protected void btnDone_Click(object sender, EventArgs e) { if (ddlDemp.SelectedItem.Value == "0") { Response.Write("<script>alert('请选择处理区域!')</script>"); return; } else { ViewState["area"] = ddlDemp.SelectedItem.Value; } List <CrushedMaterialDetail> cmList = new List <CrushedMaterialDetail>(); List <string> sqlList = new List <string>(); if (dgvList.Rows.Count != 0) { for (int i = 0; i < dgvList.Rows.Count; i++) { if ((dgvList.Rows[i].Cells[0].FindControl("cboCheckItem") as CheckBox).Checked == true) { CrushedMaterialDetail c = new CrushedMaterialDetail() { id = int.Parse((dgvList.Rows[i].Cells[0].FindControl("Hfid") as HiddenField).Value), Name = (dgvList.Rows[i].Cells[1].FindControl("Label1") as Label).Text, MaterialNo = (dgvList.Rows[i].Cells[2].FindControl("Label2") as Label).Text, Material = (dgvList.Rows[i].Cells[3].FindControl("Label3") as Label).Text, JigLeader = (dgvList.Rows[i].Cells[4].FindControl("Label4") as Label).Text, addtime = (dgvList.Rows[i].Cells[5].FindControl("Label5") as Label).Text, area1style = (dgvList.Rows[i].Cells[6].FindControl("Label6") as Label).Text, area2style = (dgvList.Rows[i].Cells[7].FindControl("Label7") as Label).Text, area3style = (dgvList.Rows[i].Cells[8].FindControl("Label8") as Label).Text, area4style = (dgvList.Rows[i].Cells[9].FindControl("Label9") as Label).Text, Qty = int.Parse((dgvList.Rows[i].Cells[10].FindControl("TextBox1") as TextBox).Text == string.Empty ? "0" : (dgvList.Rows[i].Cells[10].FindControl("TextBox1") as TextBox).Text) }; cmList.Add(c); } } if (cmList.Count == 0) { Response.Write("<script>alert('没有选择任何行!')</script>"); return; } for (int i = 0; i < cmList.Count; i++) { UpdateCommandBuilder up = new UpdateCommandBuilder(ConnectionFactory.ConnectionString_hudsonwwwroot, "trymolde"); string status = ""; switch (ViewState["area"].ToString()) { case "1": up.UpdateColumn("area1style", "Done(" + cmList[i].Qty + ")"); up.UpdateColumn("area1CrushedDate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); status = cmList[i].area1style; break; case "2": up.UpdateColumn("area2style", "Done(" + cmList[i].Qty + ")"); up.UpdateColumn("area2CrushedDate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); status = cmList[i].area2style; break; case "3": up.UpdateColumn("area3style", "Done(" + cmList[i].Qty + ")"); up.UpdateColumn("area3CrushedDate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); status = cmList[i].area3style; break; case "4": up.UpdateColumn("area4style", "Done(" + cmList[i].Qty + ")"); up.UpdateColumn("area4CrushedDate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); status = cmList[i].area4style; break; default: break; } up.ConditionsColumn("id", cmList[i].id); sqlList.Add(up.getUpdateCommand()); if (status != "粉碎中") { Response.Write("<script>alert('选择行中数据有误,请选择<粉碎中>的部番!')</script>"); return; } } InsertCommandBuilder ins = new InsertCommandBuilder(ConnectionFactory.ConnectionString_hudsonwwwroot, "trymolde"); int count = ins.ExcutTransaction(sqlList); if (count != 0) { dgvList.DataSource = getAllCrushedMaterial(); dgvList.DataBind(); } } }
protected void btnBegin_Click(object sender, EventArgs e) { //string sql = "INSERT INTO pre_pk ( pk_id, pk_no, pk_date, store_id, verifier, operator_id, remark, str_in_bill_id, str_out_bill_id, islocal, pkms ) VALUES ( 'PK000009420101', '', '2012-7-17 8:49:33.056', '03', '', '0000', '', 'RK001406270101', 'CK000548050101', 'Y', '正常按批次盘库' )"; string ss = "select count(*) from pre_prd_pk where store_id='" + ddlMaterialStock.SelectedItem.Value.Trim() + "' and CONVERT(varchar(100), prd_pk_Date, 112) = '" + DateTime.Now.ToString("yyyyMMdd") + "'"; int count = Convert.ToInt32(new SelectCommandBuilder().ExecuteScalar(ss)); if (count != 0) { Response.Write("<script>alert('" + Resources.Resource.alertWxqd + "')</script>"); gvData.DataSource = getData(); gvData.DataBind(); return; } string sql = @" SELECT materials.dm, materials.name, materials.spec, sccj.sccj_name as sccjname, materials.unit, prd_batch.pch as pch, price = prd_batch.price, prd_stock.qty as zmsl, prd_stock.qty as pdsl, prd_batch.yxq, ' ' as stock_type_id, prd_stock.is_can_sale, prd_batch.str_in_date , prd_stock.prd_batch_id , prd_stock.prd_stock_id , prd_stock.materials_id, 'ddd' as pk_id, 'N' as disobey, prd_stock.qty as zmsl1, prd_stock.qty as pdsl1, prd_batch.mjpch, materials.texture, materials.color, prd_batch.hwh FROM materials, prd_stock, prd_batch, sccj WHERE ( prd_stock.materials_id = materials.id ) and prd_stock.prd_batch_id = prd_batch.prd_batch_id and materials.sccj_id *= sccj.sccj_id and prd_stock.store_id = '" + ddlMaterialStock.SelectedItem.Value.Trim() + @"' and prd_stock.materials_id like '%' and 1 = 1 "; DataTable dt = new SelectCommandBuilder().ExecuteDataTable(sql); if (dt == null || dt.Rows.Count == 0) { Response.Write("<script>alert('" + Resources.Resource.alertWsj + "')</script>"); return; } List <string> sqlList = new List <string>(); InsertCommandBuilder ins = new InsertCommandBuilder("pre_prd_pk"); string pkId = CommadMethod.getNextId("HPR", "0101");; ins.InsertColumn("prd_pk_id", pkId); ins.InsertColumn("prd_pk_no", ""); ins.InsertColumn("prd_pk_date", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); ins.InsertColumn("store_id", ddlMaterialStock.SelectedItem.Value.Trim()); ins.InsertColumn("verifier", ""); ins.InsertColumn("operator_id", HttpContext.Current.Request.Cookies["cookie"].Values["id"]); ins.InsertColumn("remark", txtRemark.Text.Trim().ToUpper()); //ins.InsertColumn("str_in_bill_id", getId()); //ins.InsertColumn("str_out_bill_id", getId()); ins.InsertColumn("islocal", "Y"); ins.InsertColumn("prd_pkms", "正常按批次盘库"); sqlList.Add(ins.getInsertCommand()); for (int i = 0; i < dt.Rows.Count; i++) { ins = new InsertCommandBuilder("pre_prd_pk_detail"); ins.InsertColumn("prd_pk_id", pkId); ins.InsertColumn("stock_remain_id", dt.Rows[i]["prd_stock_id"]); ins.InsertColumn("materials_id", dt.Rows[i]["materials_id"]); ins.InsertColumn("pdsl", 0); ins.InsertColumn("zmsl", dt.Rows[i]["zmsl"]); ins.InsertColumn("prd_batch_id", dt.Rows[i]["prd_batch_id"]); ins.InsertColumn("zmsl1", dt.Rows[i]["zmsl1"]); ins.InsertColumn("pdsl1", 0); ins.InsertColumn("is_can_sale", dt.Rows[i]["is_can_sale"]); sqlList.Add(ins.getInsertCommand()); } ins.ExcutTransaction(sqlList); gvData.DataSource = getData(); gvData.DataBind(); }
protected void btnConfirm_Click(object sender, EventArgs e) { List <goods> List = new List <goods>(); List <string> sqlList = new List <string>(); string constr = ""; if (ddldept.SelectedItem.Value == "0") { constr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; } else { constr = ConfigurationManager.ConnectionStrings["ConXG_ZhuSu"].ConnectionString; } if (dgvList.Rows.Count != 0) { for (int i = 0; i < dgvList.Rows.Count; i++) { if ((dgvList.Rows[i].Cells[0].FindControl("cboCheckItem") as CheckBox).Checked == true) { goods g = new goods() { goodsId = (dgvList.Rows[i].Cells[0].FindControl("HfId") as HiddenField).Value, goods_name = (dgvList.Rows[i].Cells[2].FindControl("Label0") as Label).Text, mjh = (dgvList.Rows[i].Cells[3].FindControl("Label1") as Label).Text, goods_ename = (dgvList.Rows[i].Cells[4].FindControl("Label2") as Label).Text, Aircraft = (dgvList.Rows[i].Cells[5].FindControl("Label3") as Label).Text, Materail_Number = (dgvList.Rows[i].Cells[6].FindControl("Label4") as Label).Text, Materail_Name = (dgvList.Rows[i].Cells[7].FindControl("Label5") as Label).Text, Materail_Model = (dgvList.Rows[i].Cells[8].FindControl("Label6") as Label).Text, ys = (dgvList.Rows[i].Cells[9].FindControl("Label7") as Label).Text, Materail_Vender_Color = (dgvList.Rows[i].Cells[10].FindControl("Label8") as Label).Text, Materail_Color = (dgvList.Rows[i].Cells[11].FindControl("Label9") as Label).Text, cpdz = (dgvList.Rows[i].Cells[12].FindControl("Label10") as Label).Text, skdz = (dgvList.Rows[i].Cells[13].FindControl("Label11") as Label).Text, Drying_Temperature = (dgvList.Rows[i].Cells[14].FindControl("Label12") as Label).Text, Drying_Time = (dgvList.Rows[i].Cells[15].FindControl("Label13") as Label).Text, sk_scale = (dgvList.Rows[i].Cells[16].FindControl("Label14") as Label).Text, Fire_Retardant_Grade = (dgvList.Rows[i].Cells[17].FindControl("Label15") as Label).Text, Buyer = (dgvList.Rows[i].Cells[18].FindControl("Label16") as Label).Text, cxzq = (dgvList.Rows[i].Cells[19].FindControl("Label17") as Label).Text, Toner_Model = (dgvList.Rows[i].Cells[20].FindControl("Label18") as Label).Text, Toner_Buyer = (dgvList.Rows[i].Cells[21].FindControl("Label19") as Label).Text, qs = (dgvList.Rows[i].Cells[22].FindControl("Label20") as Label).Text, dw = (dgvList.Rows[i].Cells[23].FindControl("Label21") as Label).Text, khdm = (dgvList.Rows[i].Cells[24].FindControl("Label22") as Label).Text, Rohs_Certification = (dgvList.Rows[i].Cells[25].FindControl("Label23") as Label).Text, Model_Abrasives = (dgvList.Rows[i].Cells[26].FindControl("Label24") as Label).Text, remark = (dgvList.Rows[i].Cells[27].FindControl("Label25") as Label).Text }; List.Add(g); } } } if (List.Count == 0) { Response.Write("<script>alert('没有选择任何行')</script>"); return; } SelectCommandBuilder s = new SelectCommandBuilder(constr, ""); string sql = "SELECT MAX(goods_id) FROM goods"; long id = Convert.ToInt64(s.ExecuteScalar(sql).ToString().Trim()); string maxId = new SelectCommandBuilder(constr, "").ExecuteScalar("SELECT MAX(goods_ration_id) FROM goods_ration").ToString(); int rationSId = int.Parse(CommadMethod.getNextId("", "")); for (int i = 0; i < List.Count; i++) { if (sList.Count == 0) { id += 1; InsertCommandBuilder ins = new InsertCommandBuilder(constr, "goods"); ins.InsertColumn("goods_id", id.ToString()); ins.InsertColumn("goods_name", List[i].goods_name); ins.InsertColumn("goods_ename", List[i].goods_ename); ins.InsertColumn("mjh", List[i].mjh); ins.InsertColumn("dw", List[i].dw); ins.InsertColumn("qs", List[i].qs); ins.InsertColumn("Materail_Number", List[i].Materail_Number); ins.InsertColumn("Materail_Name", List[i].Materail_Name); ins.InsertColumn("ys", List[i].ys); ins.InsertColumn("Materail_Model", List[i].Materail_Model); ins.InsertColumn("Materail_Vender_Color", List[i].Materail_Vender_Color); ins.InsertColumn("Materail_Color", List[i].Materail_Color); ins.InsertColumn("cpdz", List[i].cpdz); ins.InsertColumn("skdz", List[i].skdz); ins.InsertColumn("Drying_Temperature", List[i].Drying_Temperature); ins.InsertColumn("Drying_Time", List[i].Drying_Time); string sk = List[i].sk_scale.Trim().IndexOf('%') != -1 ? (Convert.ToDecimal(List[i].sk_scale.Trim().Split('%')[0]) / 100).ToString() : (Convert.ToDecimal(List[i].sk_scale.Trim()) / 100).ToString(); ins.InsertColumn("sk_scale", sk); ins.InsertColumn("cxzq", List[i].cxzq); ins.InsertColumn("khdm", List[i].khdm); ins.InsertColumn("remark", List[i].remark); ins.InsertColumn("Fire_Retardant_Grade", List[i].Fire_Retardant_Grade); ins.InsertColumn("Buyer", List[i].Buyer); ins.InsertColumn("Toner_Model", List[i].Toner_Model); ins.InsertColumn("Toner_Buyer", List[i].Toner_Buyer); ins.InsertColumn("Aircraft", List[i].Aircraft); ins.InsertColumn("Rohs_Certification", List[i].Rohs_Certification); decimal qty = (Convert.ToDecimal(List[i].cpdz) + (Convert.ToDecimal(List[i].skdz) / Convert.ToDecimal(List[i].qs))) * (1 - Convert.ToDecimal(sk)); decimal skqty = (Convert.ToDecimal(List[i].cpdz) + (Convert.ToDecimal(List[i].skdz) / Convert.ToDecimal(List[i].qs))) * Convert.ToDecimal(sk); List <decimal> dlist = new List <decimal>(); dlist.Add(qty); dlist.Add(skqty); for (int k = 0; k < dlist.Count; k++) { InsertCommandBuilder inss = new InsertCommandBuilder(constr, "goods_ration"); inss.InsertColumn("goods_ration_id", "AG" + rationSId.ToString().PadLeft(8, '0') + "0101"); inss.InsertColumn("goods_id", id); inss.InsertColumn("item_Data", ""); inss.InsertColumn("item_type", "01"); inss.InsertColumn("qty", dlist[k].ToString("0.00#")); inss.InsertColumn("price", "0"); inss.InsertColumn("remark", ""); inss.InsertColumn("operator_date", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); sqlList.Add(inss.getInsertCommand()); } CommadMethod.getNextId("", "", dlist.Count); sqlList.Add(ins.getInsertCommand()); } else { for (int j = 0; j < sList.Count; j++) { string name = List[i].goods_name.Trim() + sList[j]; id += 1; InsertCommandBuilder ins = new InsertCommandBuilder(constr, "goods"); ins.InsertColumn("goods_id", id.ToString()); ins.InsertColumn("goods_name", name); ins.InsertColumn("goods_ename", List[i].goods_ename); ins.InsertColumn("mjh", List[i].mjh); ins.InsertColumn("dw", List[i].dw); ins.InsertColumn("qs", List[i].qs); ins.InsertColumn("Materail_Number", List[i].Materail_Number); ins.InsertColumn("Materail_Name", List[i].Materail_Name); ins.InsertColumn("ys", List[i].ys); ins.InsertColumn("Materail_Model", List[i].Materail_Model); ins.InsertColumn("Materail_Vender_Color", List[i].Materail_Vender_Color); ins.InsertColumn("Materail_Color", List[i].Materail_Color); ins.InsertColumn("cpdz", List[i].cpdz); ins.InsertColumn("skdz", List[i].skdz); ins.InsertColumn("Drying_Temperature", List[i].Drying_Temperature); ins.InsertColumn("Drying_Time", List[i].Drying_Time); string sk = List[i].sk_scale.Trim().IndexOf('%') != -1 ? (Convert.ToDecimal(List[i].sk_scale.Trim().Split('%')[0]) / 100).ToString() : (Convert.ToDecimal(List[i].sk_scale.Trim()) / 100).ToString(); ins.InsertColumn("sk_scale", sk); ins.InsertColumn("cxzq", List[i].cxzq); ins.InsertColumn("khdm", List[i].khdm); ins.InsertColumn("remark", List[i].remark); ins.InsertColumn("Fire_Retardant_Grade", List[i].Fire_Retardant_Grade); ins.InsertColumn("Buyer", List[i].Buyer); ins.InsertColumn("Toner_Model", List[i].Toner_Model); ins.InsertColumn("Toner_Buyer", List[i].Toner_Buyer); ins.InsertColumn("Aircraft", List[i].Aircraft); ins.InsertColumn("Rohs_Certification", List[i].Rohs_Certification); decimal qty = (Convert.ToDecimal(List[i].cpdz) + (Convert.ToDecimal(List[i].skdz) / Convert.ToDecimal(List[i].qs))) * (1 - Convert.ToDecimal(sk)); decimal skqty = (Convert.ToDecimal(List[i].cpdz) + (Convert.ToDecimal(List[i].skdz) / Convert.ToDecimal(List[i].qs))) * Convert.ToDecimal(sk); List <decimal> dlist = new List <decimal>(); dlist.Add(qty); dlist.Add(skqty); for (int k = 0; k < dlist.Count; k++) { rationSId = int.Parse(CommadMethod.getNextId("", "")); InsertCommandBuilder inss = new InsertCommandBuilder(constr, "goods_ration"); inss.InsertColumn("goods_ration_id", "AG" + rationSId.ToString().PadLeft(8, '0') + "0101"); inss.InsertColumn("goods_id", id); inss.InsertColumn("item_Data", ""); inss.InsertColumn("item_type", "01"); inss.InsertColumn("qty", dlist[k].ToString("0.00#")); inss.InsertColumn("price", "0"); inss.InsertColumn("remark", ""); inss.InsertColumn("operator_date", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); sqlList.Add(inss.getInsertCommand()); } //CommadMethod.getNextId("", "", dlist.Count); sqlList.Add(ins.getInsertCommand()); } } } InsertCommandBuilder insert = new InsertCommandBuilder(constr, ""); for (int i = 0; i < List.Count; i++) { new UpdateCommandBuilder(constr, "").ExecuteNonQuery("update goods_tran set isConfirm = 'Done' where goods_id = '" + List[i].goodsId + "'"); } int count = insert.ExcutTransaction(sqlList); Response.Write("<script>alert('执行成功')</script>"); btnSearch_Click(sender, e); }
protected void btnConfirm_Click(object sender, EventArgs e) { List <Details> DList = new List <Details>(); List <string> SList = new List <string>(); for (int i = 0; i < gvDetailData.Rows.Count; i++) { if ((gvDetailData.Rows[i].Cells[0].FindControl("checkbox1") as CheckBox).Checked == true) { if (string.IsNullOrEmpty((gvDetailData.Rows[i].Cells[5].FindControl("txtPrice") as TextBox).Text.Trim())) { ClientScript.RegisterClientScriptBlock(ClientScript.GetType(), "alert", "<script>alert('请输入数量')</script>", false); (gvDetailData.Rows[i].Cells[6].FindControl("txtPrice") as TextBox).Focus(); return; } Details dItem = new Details() { Apply_No = orderNo, MNo = Mno, Name = gvDetailData.Rows[i].Cells[2].Text.Trim(), Texture = gvDetailData.Rows[i].Cells[3].Text.Trim(), Spec = gvDetailData.Rows[i].Cells[4].Text.Trim(), Qty = Convert.ToInt32((gvDetailData.Rows[i].Cells[6].FindControl("txtPrice") as TextBox).Text.Trim()), Hwh = (gvDetailData.Rows[i].Cells[7].FindControl("txtHwh") as TextBox).Text.Trim(), Id = Convert.ToInt64(gvDetailData.Rows[i].Cells[8].Text.Trim()) }; DList.Add(dItem); } } if (DList.Count == 0) { ClientScript.RegisterClientScriptBlock(ClientScript.GetType(), "alert", "<script>alert('无选择数据')</script>", false); return; } string Id = CommadMethod.getNextId("SI" + DateTime.Now.ToString("yyyyMMdd"), "").Trim(); for (int i = 0; i < DList.Count; i++) { InsertCommandBuilder insert = new InsertCommandBuilder("m_materails_pre_str_in_detail"); UpdateCommandBuilder up = new UpdateCommandBuilder("m_materails_pch_order_detail"); up.UpdateColumn("is_end", "Y"); up.ConditionsColumn("Id", DList[i].Id); insert.InsertColumn("str_in_no", Id); insert.InsertColumn("name", DList[i].Name); insert.InsertColumn("texture", DList[i].Texture); insert.InsertColumn("spec", DList[i].Spec); insert.InsertColumn("qty", DList[i].Qty); insert.InsertColumn("hwh", DList[i].Hwh); insert.InsertColumn("is_check", "N"); SList.Add(insert.getInsertCommand()); SList.Add(up.getUpdateCommand()); } InsertCommandBuilder ins = new InsertCommandBuilder("m_materails_pre_str_in"); ins.InsertColumn("str_in_no", Id); if (!string.IsNullOrEmpty(Mno)) { ins.InsertColumn("mode_no", Mno); } ins.InsertColumn("order_no", orderNo); ins.InsertColumn("Operator", "0000"); ins.InsertColumn("str_in_date", "getDate()"); ins.InsertColumn("Operate_Date", "getDate()"); ins.InsertColumn("is_confirm", "N"); SList.Add(ins.getInsertCommand()); int count = ins.ExcutTransaction(SList); if (count != 0) { ClientScript.RegisterClientScriptBlock(ClientScript.GetType(), "alert", "<script>alert('保存成功')</script>", false); gvDetailData.DataSource = null; gvDetailData.DataBind(); string updateSql = "update m_materails_pch_order set isCheck = 'Y' where Order_No='" + orderNo.Trim() + "'"; int countY = Convert.ToInt32(new SelectCommandBuilder().ExecuteScalar("select count(*) from m_materails_pch_order_detail where Order_No='" + orderNo.Trim() + "' and is_end = 'N' ")); if (countY == 0) { new UpdateCommandBuilder().ExecuteNonQuery(updateSql); } } else { ClientScript.RegisterClientScriptBlock(ClientScript.GetType(), "alert", "<script>alert('保存失败')</script>", false); } }
protected void btnConfirm_Click(object sender, EventArgs e) { List <goods> List = new List <goods>(); List <string> sqlList = new List <string>(); if (dgvList.Rows.Count != 0) { for (int i = 0; i < dgvList.Rows.Count; i++) { if ((dgvList.Rows[i].Cells[0].FindControl("cboCheckItem") as CheckBox).Checked == true) { goods g = new goods() { goodsId = (dgvList.Rows[i].Cells[0].FindControl("HfId") as HiddenField).Value, goods_name = (dgvList.Rows[i].Cells[2].FindControl("Label0") as Label).Text, mjh = (dgvList.Rows[i].Cells[3].FindControl("Label1") as Label).Text, goods_ename = (dgvList.Rows[i].Cells[4].FindControl("Label2") as Label).Text, Aircraft = (dgvList.Rows[i].Cells[5].FindControl("Label3") as Label).Text, Materail_Number = (dgvList.Rows[i].Cells[6].FindControl("Label4") as Label).Text, Materail_Name = (dgvList.Rows[i].Cells[7].FindControl("Label5") as Label).Text, Materail_Model = (dgvList.Rows[i].Cells[8].FindControl("Label6") as Label).Text, ys = (dgvList.Rows[i].Cells[9].FindControl("Label7") as Label).Text, Materail_Vender_Color = (dgvList.Rows[i].Cells[10].FindControl("Label8") as Label).Text, Materail_Color = (dgvList.Rows[i].Cells[11].FindControl("Label9") as Label).Text, cpdz = (dgvList.Rows[i].Cells[12].FindControl("Label10") as Label).Text, skdz = (dgvList.Rows[i].Cells[13].FindControl("Label11") as Label).Text, Drying_Temperature = (dgvList.Rows[i].Cells[14].FindControl("Label12") as Label).Text, Drying_Time = (dgvList.Rows[i].Cells[15].FindControl("Label13") as Label).Text, sk_scale = (dgvList.Rows[i].Cells[16].FindControl("Label14") as Label).Text, Fire_Retardant_Grade = (dgvList.Rows[i].Cells[17].FindControl("Label15") as Label).Text, Buyer = (dgvList.Rows[i].Cells[18].FindControl("Label16") as Label).Text, cxzq = (dgvList.Rows[i].Cells[19].FindControl("Label17") as Label).Text, Toner_Model = (dgvList.Rows[i].Cells[20].FindControl("Label18") as Label).Text, Toner_Buyer = (dgvList.Rows[i].Cells[21].FindControl("Label19") as Label).Text, qs = (dgvList.Rows[i].Cells[22].FindControl("Label20") as Label).Text, dw = (dgvList.Rows[i].Cells[23].FindControl("Label21") as Label).Text, khdm = (dgvList.Rows[i].Cells[24].FindControl("Label22") as Label).Text, Rohs_Certification = (dgvList.Rows[i].Cells[25].FindControl("Label23") as Label).Text, Model_Abrasives = (dgvList.Rows[i].Cells[26].FindControl("Label24") as Label).Text, remark = (dgvList.Rows[i].Cells[27].FindControl("Label25") as Label).Text }; List.Add(g); } } } if (List.Count == 0) { Response.Write("<script>alert('没有选择任何行')</script>"); return; } for (int i = 0; i < List.Count; i++) { UpdateCommandBuilder up = new UpdateCommandBuilder(constr, "goods_tran"); up.UpdateColumn("isConfirm", "Approved"); up.ConditionsColumn("goods_id", List[i].goodsId); sqlList.Add(up.getUpdateCommand()); } InsertCommandBuilder ins = new InsertCommandBuilder(constr, ""); int count = ins.ExcutTransaction(sqlList); //int count = new InsertCommandBuilder().ExcutTransaction(sqlList); if (count != 0) { Response.Write("<script>alert('审核成功!')</script>"); dgvList.DataSource = getConfirmGoodsList(); dgvList.DataBind(); gvData.DataSource = null; gvData.DataBind(); } }
protected void sr_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(txtInput.Text)) { txtInput.Focus(); return; } switch (step) { case 0: if (txtInput.Text.ToLower() != "begin") { sList.Insert(0, AppendDateTime("NG,指令错误")); sList.Insert(0, AppendDateTime("开始指令???")); alertMsg(); return; } step += 1; sList.Insert(0, AppendDateTime("OK,工号???")); alertMsg(); break; case 1: if (!getUser(txtInput.Text.Trim().ToUpper())) { sList.Insert(0, AppendDateTime("NG,用户不存在")); alertMsg(); return; } step += 1; ViewState["UserId"] = txtInput.Text.Trim().ToUpper(); sList.Insert(0, AppendDateTime(ViewState["UserId"].ToString())); sList.Insert(0, AppendDateTime("OK,请扫入区域???")); alertMsg(); break; case 2: if (txtInput.Text.ToLower() == "end") { sList.Insert(0, AppendDateTime("OK,结束指令,需要操作请重新刷读指令")); alertMsg(); step = 0; return; } area = txtInput.Text; if (area.Length > 11) { area = area.Substring(area.Length - 6, 6); } else { area = area; } step += 1; switch (area.ToLower()) { case "waitstorge": sList.Insert(0, AppendDateTime("待入库区")); sList.Insert(0, AppendDateTime("OK,入库票???")); alertMsg(); break; case "storge": hwh = txtInput.Text.Trim().ToLower().Split(' ')[0]; store_id = txtInput.Text.Trim().ToLower().Split(' ')[1]; sList.Insert(0, AppendDateTime("仓库")); sList.Insert(0, AppendDateTime("OK,请扫入库票")); alertMsg(); step += 1; break; case "pickarea": sList.Insert(0, AppendDateTime("选别区")); sList.Insert(0, AppendDateTime("OK,请扫入库票???")); alertMsg(); break; case "print": sList.Insert(0, AppendDateTime("丝印区")); sList.Insert(0, AppendDateTime("OK,请扫入库票???")); alertMsg(); break; case "z_area": sList.Insert(0, AppendDateTime("暂放区域")); sList.Insert(0, AppendDateTime("OK,请扫入库票???")); alertMsg(); break; default: sList.Insert(0, AppendDateTime("NG,区域错误")); sList.Insert(0, AppendDateTime("请重新扫描区域???")); alertMsg(); step = 2; break; } break; case 3: switch (area.ToLower()) { case "waitstorge": if (txtInput.Text.ToLower() == "end") { sList.Insert(0, AppendDateTime("OK,结束指令,需要操作请重新刷读指令")); alertMsg(); step = 0; return; } string[] List = getBarCode(txtInput.Text); if (List.Length < 7) { sList.Insert(0, AppendDateTime("NG,条码格式错误!")); sList.Insert(0, AppendDateTime("NG,重新入库票")); step = 3; alertMsg(); return; } goodsName = List[2]; Qty = int.Parse(List[6]); int wCount = Convert.ToInt32(new SelectCommandBuilder().ExecuteScalar("SELECT count(*) FROM Material_control WHERE (label = '" + List[0] + "' and process_id = '" + 1 + "')")); if (wCount != 0) { sList.Insert(0, AppendDateTime("入库票重复")); sList.Insert(0, AppendDateTime("NG,请重新入库票???")); step = 3; alertMsg(); return; } waitStorge(List[0], goodsName, Qty, ViewState["UserId"].ToString()); sList.Insert(0, AppendDateTime("部番:" + goodsName + " 数量:" + Qty)); sList.Insert(0, AppendDateTime("OK,请扫入区域")); step = 2; alertMsg(); break; case "z_area": if (txtInput.Text.ToLower() == "end") { sList.Insert(0, AppendDateTime("OK,结束指令,需要操作请重新刷读指令")); alertMsg(); step = 0; return; } string[] zList = getBarCode(txtInput.Text); if (zList.Length < 7) { sList.Insert(0, AppendDateTime("NG,入库票格式错误!")); sList.Insert(0, AppendDateTime("NG,重新刷入库票")); return; } goodsName = zList[2]; Qty = int.Parse(zList[6]); int zCount = Convert.ToInt32(new SelectCommandBuilder().ExecuteScalar("select count(*) from material_control where label='" + zList[0] + "' and process_id= 5 ")); if (zCount != 0) { sList.Insert(0, AppendDateTime("入库票重复")); sList.Insert(0, AppendDateTime("入库票重复")); step = 3; alertMsg(); return; } string sqlz = "SELECT TOP 1 process_id FROM Material_control where label = '" + zList[0] + "' ORDER BY operate_time DESC"; DataTable dtz = new SelectCommandBuilder().ExecuteDataTable(sqlz); if (dtz == null || dtz.Rows.Count == 0) { sList.Insert(0, AppendDateTime("NG,未入待入库区,请确认扫描后再入库!")); sList.Insert(0, AppendDateTime("NG,重新入库票")); step = 3; alertMsg(); return; } int z_areaId = int.Parse(dtz.Rows[0][0].ToString()); string z_QtySql = "SELECT ISNULL(SUM(CurrQty), 0) AS CurrQty FROM Material_control_process WHERE (label = '" + zList[0] + "' and process_id = 1)"; int z_Result = Convert.ToInt32(new SelectCommandBuilder().ExecuteScalar(z_QtySql)); if (z_Result < Qty) { sList.Insert(0, AppendDateTime("NG,数量超出待入库区数量,无法入库!")); sList.Insert(0, AppendDateTime("NG,重新入库票")); step = 4; } else { z_area(zList[0], goodsName, Qty, ViewState["UserId"].ToString()); sList.Insert(0, AppendDateTime("部番:" + goodsName + " 数量:" + Qty)); sList.Insert(0, AppendDateTime("OK,请扫入区域")); step = 2; } alertMsg(); break; case "pickarea": if (txtInput.Text.ToLower() == "end") { sList.Insert(0, AppendDateTime("OK,结束指令,需要操作请重新刷读指令")); alertMsg(); step = 0; return; } string[] pList = getBarCode(txtInput.Text); if (pList.Length < 7) { sList.Insert(0, AppendDateTime("NG,条码格式错误!")); sList.Insert(0, AppendDateTime("NG,重新入库票")); step = 3; alertMsg(); return; } goodsName = pList[2]; Qty = int.Parse(pList[6]); int pCount = Convert.ToInt32(new SelectCommandBuilder().ExecuteScalar("SELECT count(*) FROM Material_control WHERE (label = '" + pList[0] + "' and process_id = '" + 2 + "')")); if (pCount != 0) { sList.Insert(0, AppendDateTime("入库票重复")); sList.Insert(0, AppendDateTime("NG,请重新入库票???")); step = 3; alertMsg(); return; } List <string> paList = new List <string>(); string sql1 = "select count(str_in_bill_id) from pre_str_in_bill where str_in_bill_no = '" + pList[0] + "'"; int hasCount1 = Convert.ToInt32(new SelectCommandBuilder().ExecuteScalar(sql1)); if (hasCount1 != 0) { sList.Insert(0, AppendDateTime("NG,该入库票已入库???")); sList.Insert(0, AppendDateTime("条码???")); step = 5; alertMsg(); return; } str_bill_id = CommadMethod.getNextId("Q"); InsertCommandBuilder insert = new InsertCommandBuilder("pre_str_in_bill"); insert.InsertColumn("str_in_bill_id", str_bill_id); insert.InsertColumn("str_in_type_id", "C"); insert.InsertColumn("str_in_bill_no", pList[0]); insert.InsertColumn("operator_date", "getdate()"); insert.InsertColumn("str_in_date", "getdate()"); insert.InsertColumn("store_id", "12"); insert.InsertColumn("create_user", ViewState["UserId"]); insert.InsertColumn("operator_id", "0000"); insert.InsertColumn("dfdh", pList[1]); insert.InsertColumn("come_from", "生产加工入库"); insert.InsertColumn("islocal", "Y"); insert.InsertColumn("verifier", "0024"); insert.InsertColumn("bill_num", "0"); insert.InsertColumn("paydate", "1900/1/1"); //insert.InsertColumn("is_state", "N"); paList.Add(insert.getInsertCommand()); //入库操作 InsertCommandBuilder ins1 = new InsertCommandBuilder("pre_str_in_bill_detail"); ins1.InsertColumn("batch_id", CommadMethod.getNextId("Q")); ins1.InsertColumn("str_in_bill_id", str_bill_id); ins1.InsertColumn("goods_id", new SelectCommandBuilder().ExecuteDataTable("select goods_id from goods where goods_name='" + goodsName + "'").Rows[0][0].ToString()); ins1.InsertColumn("qty", Qty); ins1.InsertColumn("pch", pList[0].Substring(2, 6)); ins1.InsertColumn("hwh", "NG01"); ins1.InsertColumn("piece", "0"); ins1.InsertColumn("price", "0"); ins1.InsertColumn("inqty", Qty); ins1.InsertColumn("exam", " "); ins1.InsertColumn("yxq", "1900/1/1"); ins1.InsertColumn("producedate", "1900/1/1"); paList.Add(ins1.getInsertCommand()); string QtySql1 = "SELECT ISNULL(SUM(CurrQty), 0) AS CurrQty FROM Material_control_process WHERE (label = '" + pList[0] + "' and process_id = '1')"; int Result1 = Convert.ToInt32(new SelectCommandBuilder().ExecuteScalar(QtySql1)); if (Result1 < Qty) { sList.Insert(0, AppendDateTime("NG,数量不足,无法入库3!")); sList.Insert(0, AppendDateTime("NG,请注明手动处理,重扫区域???")); step = 2; alertMsg(); return; } else { PickArea(pList[0], goodsName, Qty, ViewState["UserId"].ToString()); ins1.ExcutTransaction(paList); sList.Insert(0, AppendDateTime("部番:" + goodsName + " 数量:" + Qty)); sList.Insert(0, AppendDateTime("OK,请扫描区域???")); step = 2; alertMsg(); break; } case "print": if (txtInput.Text.ToLower() == "end") { sList.Insert(0, AppendDateTime("OK,结束指令,需要操作请重新刷读指令")); alertMsg(); step = 0; return; } string[] prList = getBarCode(txtInput.Text); if (prList.Length < 7) { sList.Insert(0, AppendDateTime("NG,条码格式错误!")); sList.Insert(0, AppendDateTime("NG,重新入库票")); step = 3; alertMsg(); return; } goodsName = prList[2]; Qty = int.Parse(prList[6]); int prCount = Convert.ToInt32(new SelectCommandBuilder().ExecuteScalar("SELECT count(*) FROM Material_control WHERE (label = '" + prList[0] + "' and process_id = '" + 3 + "')")); if (prCount != 0) { sList.Insert(0, AppendDateTime("入库票重复")); sList.Insert(0, AppendDateTime("NG,请重新入库票???")); step = 3; alertMsg(); return; } string QtySql2 = "SELECT ISNULL(SUM(CurrQty), 0) AS CurrQty FROM Material_control_process WHERE (label = '" + prList[0] + "' and process_id = '" + 1 + "')"; int Result2 = Convert.ToInt32(new SelectCommandBuilder().ExecuteScalar(QtySql2)); if (Result2 < Qty) { sList.Insert(0, AppendDateTime("NG,数量不足,无法入库1!")); sList.Insert(0, AppendDateTime("NG,重新入库票???")); step = 2; alertMsg(); return; } else { print(prList[0], goodsName, Qty, ViewState["UserId"].ToString()); sList.Insert(0, AppendDateTime("部番:" + goodsName + " 数量:" + Qty)); sList.Insert(0, AppendDateTime("OK,请扫描区域???")); List <string> printList = new List <string>(); str_bill_id = CommadMethod.getNextId("Q"); InsertCommandBuilder pInser = new InsertCommandBuilder("pre_str_in_bill"); pInser.InsertColumn("str_in_bill_id", str_bill_id); pInser.InsertColumn("str_in_type_id", "C"); pInser.InsertColumn("str_in_bill_no", prList[0]); pInser.InsertColumn("operator_date", "getdate()"); pInser.InsertColumn("str_in_date", "getdate()"); pInser.InsertColumn("store_id", "11"); pInser.InsertColumn("create_user", ViewState["UserId"]); pInser.InsertColumn("operator_id", "0000"); pInser.InsertColumn("dfdh", prList[1]); pInser.InsertColumn("come_from", "生产加工入库"); pInser.InsertColumn("islocal", "Y"); pInser.InsertColumn("verifier", "0024"); pInser.InsertColumn("bill_num", "0"); pInser.InsertColumn("paydate", "1900/1/1"); //insert.InsertColumn("is_state", "N"); printList.Add(pInser.getInsertCommand()); //入库操作 InsertCommandBuilder pIinserd = new InsertCommandBuilder("pre_str_in_bill_detail"); pIinserd.InsertColumn("batch_id", CommadMethod.getNextId("Q")); pIinserd.InsertColumn("str_in_bill_id", str_bill_id); pIinserd.InsertColumn("goods_id", new SelectCommandBuilder().ExecuteDataTable("select goods_id from goods where goods_name='" + goodsName + "'").Rows[0][0].ToString()); pIinserd.InsertColumn("qty", Qty); pIinserd.InsertColumn("pch", prList[0].Substring(2, 6)); pIinserd.InsertColumn("hwh", "SY"); pIinserd.InsertColumn("piece", "0"); pIinserd.InsertColumn("price", "0"); pIinserd.InsertColumn("inqty", Qty); pIinserd.InsertColumn("exam", " "); pIinserd.InsertColumn("yxq", "1900/1/1"); pIinserd.InsertColumn("producedate", "1900/1/1"); printList.Add(pIinserd.getInsertCommand()); pIinserd.ExcutTransaction(printList); } step = 2; alertMsg(); break; } break; case 4: if (txtInput.Text.ToLower() == "end") { sList.Insert(0, AppendDateTime("OK,结束指令,需要操作请重新刷读指令")); str_bill_id = string.Empty; alertMsg(); step = 0; return; } else if (txtInput.Text.ToLower() == "reenter") { sList.Insert(0, AppendDateTime("OK,货位号???")); step = 3; alertMsg(); return; } string[] aList = getBarCode(txtInput.Text); if (aList.Length < 7) { sList.Insert(0, AppendDateTime("NG,条码格式错误!")); sList.Insert(0, AppendDateTime("NG,重新入库票")); step = 4; alertMsg(); return; } goodsName = aList[2]; Qty = int.Parse(aList[6]); string goods_id = new SelectCommandBuilder().ExecuteDataTable("select goods_id from goods where goods_name='" + goodsName + "'").Rows[0][0].ToString(); List <string> Alist = new List <string>(); string sql = "select count(str_in_bill_id) from pre_str_in_bill where str_in_bill_no = '" + aList[0] + "'"; int hasCount = Convert.ToInt32(new SelectCommandBuilder().ExecuteScalar(sql)); if (hasCount != 0) { sList.Insert(0, AppendDateTime("NG,该入库票已入库???")); sList.Insert(0, AppendDateTime("条码???")); step = 4; alertMsg(); return; } string lbel1 = aList[0].Substring(0, 2).ToString(); if (lbel1 == "XB") { List <string> olist = new List <string>(); string str_out_bill_id = CommadMethod.getNextId("Q"); string dfdh = CommadMethod.getNextId("Z"); InsertCommandBuilder insertout = new InsertCommandBuilder("pre_str_out_bill"); insertout.InsertColumn("str_out_bill_id", str_out_bill_id); insertout.InsertColumn("str_out_bill_no", aList[0]); insertout.InsertColumn("dfdh", dfdh); insertout.InsertColumn("str_out_type_id", "2"); insertout.InsertColumn("str_out_date", "getdate()"); insertout.InsertColumn("store_id", "12"); insertout.InsertColumn("operator_id", "0000"); insertout.InsertColumn("transactor", "曾松林"); insertout.InsertColumn("verifier", "曾松林"); insertout.InsertColumn("come_to", "成品"); insertout.InsertColumn("bill_num", "1"); insertout.InsertColumn("operator_date", "getdate()"); insertout.InsertColumn("islocal", "Y"); insertout.InsertColumn("gsptypeid", "2"); olist.Add(insertout.getInsertCommand()); string Dsql = @"SELECT stock_remain.goods_id, stock_remain.qty, batch.batch_id,batch.hwh, stock_remain.store_id FROM stock_remain INNER JOIN batch ON stock_remain.batch_id = batch.batch_id WHERE (stock_remain.goods_id = '" + goods_id + "') AND (batch.hwh = 'NG01') and stock_remain.store_id='12' order by right(rtrim(batch.pch),6)"; SelectCommandBuilder s = new SelectCommandBuilder(); int count = Convert.ToInt32(s.ExecuteScalar(Dsql)); if (count == 0) { sList.Insert(0, "选别区数量不足"); sList.Insert(0, "NG,请扫描区域"); step = 2; alertMsg(); return; } DataTable Dqty = s.ExecuteDataTable(Dsql); int dbqty = 0; int xQty = Qty; for (int i = 0; i < Dqty.Rows.Count; i++) { dbqty = xQty - Convert.ToInt32(Dqty.Rows[i]["qty"]); if (dbqty == 0) { InsertCommandBuilder insd = new InsertCommandBuilder("pre_str_out_bill_detail"); insd.InsertColumn("str_out_bill_id", str_out_bill_id); insd.InsertColumn("goods_id", goods_id); insd.InsertColumn("batch_id", Dqty.Rows[i]["batch_id"]); insd.InsertColumn("qty", xQty); insd.InsertColumn("exam", " "); insd.InsertColumn("price", "0"); insd.InsertColumn("Can_sale", "Y"); insd.InsertColumn("DSort", "1"); insd.InsertColumn("CostPrice", "0"); insd.InsertColumn("hwh", hwh); olist.Add(insd.getInsertCommand()); break; } else if (dbqty > 0) { InsertCommandBuilder insd = new InsertCommandBuilder("pre_str_out_bill_detail"); insd.InsertColumn("str_out_bill_id", str_out_bill_id); insd.InsertColumn("goods_id", goods_id); insd.InsertColumn("batch_id", Dqty.Rows[i]["batch_id"]); insd.InsertColumn("qty", Dqty.Rows[i]["qty"]); insd.InsertColumn("exam", " "); insd.InsertColumn("price", "0"); insd.InsertColumn("Can_sale", "Y"); insd.InsertColumn("DSort", "1"); insd.InsertColumn("CostPrice", "0"); insd.InsertColumn("hwh", hwh); xQty = dbqty; olist.Add(insd.getInsertCommand()); continue; } else if (dbqty < 0) { InsertCommandBuilder insd = new InsertCommandBuilder("pre_str_out_bill_detail"); insd.InsertColumn("str_out_bill_id", str_out_bill_id); insd.InsertColumn("goods_id", goods_id); insd.InsertColumn("batch_id", Dqty.Rows[i]["batch_id"]); insd.InsertColumn("qty", xQty); insd.InsertColumn("exam", " "); insd.InsertColumn("price", "0"); insd.InsertColumn("Can_sale", "Y"); insd.InsertColumn("DSort", "1"); insd.InsertColumn("CostPrice", "0"); insd.InsertColumn("hwh", hwh); olist.Add(insd.getInsertCommand()); break; } } new InsertCommandBuilder().ExcutTransaction(olist); Storge(aList[0], goodsName, Qty, 2, ViewState["UserId"].ToString()); //1:待入库 2:选别 sList.Insert(0, AppendDateTime("部番:" + goodsName + " 数量:" + Qty)); sList.Insert(0, AppendDateTime("OK,请扫描区域")); step = 2; alertMsg(); return; } str_bill_id = CommadMethod.getNextId("Q"); InsertCommandBuilder insert3 = new InsertCommandBuilder("pre_str_in_bill"); insert3.InsertColumn("str_in_bill_id", str_bill_id); insert3.InsertColumn("dfdh", aList[1]); insert3.InsertColumn("str_in_type_id", "C"); insert3.InsertColumn("verifier", "0024"); insert3.InsertColumn("bill_num", "0"); insert3.InsertColumn("paydate", "1900/1/1"); insert3.InsertColumn("str_in_bill_no", aList[0]); insert3.InsertColumn("operator_date", "getdate()"); insert3.InsertColumn("str_in_date", "getdate()"); insert3.InsertColumn("store_id", "03"); //store_id);//暂时固定为03 insert3.InsertColumn("create_user", ViewState["UserId"]); insert3.InsertColumn("operator_id", "0000"); insert3.InsertColumn("come_from", "生产加工入库"); insert3.InsertColumn("islocal", "Y"); Alist.Add(insert3.getInsertCommand()); InsertCommandBuilder ins = new InsertCommandBuilder("pre_str_in_bill_detail"); ins.InsertColumn("batch_id", CommadMethod.getNextId("Q")); ins.InsertColumn("str_in_bill_id", str_bill_id); ins.InsertColumn("goods_id", new SelectCommandBuilder().ExecuteDataTable("select goods_id from goods where goods_name='" + goodsName + "'").Rows[0][0].ToString()); ins.InsertColumn("qty", Qty); ins.InsertColumn("exam", " "); ins.InsertColumn("yxq", "1900/1/1"); ins.InsertColumn("Producedate", "1900/1/1"); ins.InsertColumn("inqty", Qty); ins.InsertColumn("notin", "1"); ins.InsertColumn("tax_rate", "17"); ins.InsertColumn("piece", "0"); ins.InsertColumn("price", "0"); ins.InsertColumn("hwh", hwh); ins.InsertColumn("pch", aList[0].Substring(2, 6)); Alist.Add(ins.getInsertCommand()); string sql2 = "SELECT TOP 1 process_id FROM Material_control where label = '" + aList[0] + "' ORDER BY operate_time DESC"; DataTable dt = new SelectCommandBuilder().ExecuteDataTable(sql2); if (dt == null || dt.Rows.Count == 0) { sList.Insert(0, AppendDateTime("NG,前端未扫描,请确认扫描后再入库!")); sList.Insert(0, AppendDateTime("NG,重新入库票")); step = 4; alertMsg(); return; } int areaId = int.Parse(dt.Rows[0][0].ToString()); string QtySql = "SELECT ISNULL(SUM(CurrQty), 0) AS CurrQty FROM Material_control_process WHERE (label = '" + aList[0] + "' and process_id = '" + areaId + "')"; int Result = Convert.ToInt32(new SelectCommandBuilder().ExecuteScalar(QtySql)); if (Result < Qty) { sList.Insert(0, AppendDateTime("NG,数量不足,无法入库2!")); sList.Insert(0, AppendDateTime("NG,重新入库票")); step = 4; } else { Storge(aList[0], goodsName, Qty, areaId, ViewState["UserId"].ToString()); //1:待入库 2:选别 ins.ExcutTransaction(Alist); sList.Insert(0, AppendDateTime("部番:" + goodsName + " 数量:" + Qty)); sList.Insert(0, AppendDateTime("OK,请扫描区域")); step = 2; } alertMsg(); break; } } catch (Exception ex) { sList.Insert(0, AppendDateTime(ex.Message)); sList.Insert(0, AppendDateTime("NG,出现错误,请重新刷读")); alertMsg(); } }
protected void Unnamed2_Click(object sender, EventArgs e) { if (btnUpload.Text == Resources.Resource.yl) { #region 将上传的Excel数据显示在GridView中 if (FileUpload1.HasFile == false) { ClientScript.RegisterStartupScript(ClientScript.GetType(), "error", "<script>alert('" + Resources.Resource.alertxzwj + "!')</script>"); //Response.Write("<script>alert('请您选择Excel文件')</script> "); return;//当无文件时,返回 } string IsXls = System.IO.Path.GetExtension(FileUpload1.FileName).ToString().ToLower(); if (IsXls != ".xls") { Response.Write("<script>alert('" + Resources.Resource.alertxzexcel + "')</script>"); return;//当选择的不是Excel文件时,返回 } btnUpload.Text = Resources.Resource.qr; Button1.Text = Resources.Resource.qx; string path = Server.MapPath("~/UploadExcel/"); string strpath = FileUpload1.PostedFile.FileName.ToString(); //string filename = FileUpload1.FileName; FileUpload1.PostedFile.SaveAs(path + FileUpload1.FileName); string Filename = path + FileUpload1.FileName; FileStream file = new FileStream(Filename, FileMode.Open, FileAccess.Read); HSSFWorkbook hssfworkbook = new HSSFWorkbook(file); Sheet sheet = hssfworkbook.GetSheetAt(0); DataTable table = new DataTable(); Row headerRow = sheet.GetRow(0); int cellCount = headerRow.LastCellNum; for (int i = headerRow.FirstCellNum; i < cellCount; i++) { DataColumn column = new DataColumn(headerRow.GetCell(i).StringCellValue); table.Columns.Add(column); } int rowCount = sheet.LastRowNum; for (int i = (sheet.FirstRowNum + 1); i < sheet.LastRowNum + 1; i++) { Row row = sheet.GetRow(i); DataRow dataRow = table.NewRow(); for (int j = row.FirstCellNum; j < cellCount; j++) { if (row.GetCell(j) != null) { dataRow[j] = row.GetCell(j).ToString(); } } table.Rows.Add(dataRow); } hssfworkbook = null; sheet = null; this.gvExcel.DataSource = table; this.gvExcel.DataBind(); File.Delete(Filename); #endregion } else { #region 确认上传数据 if (gvExcel.Rows.Count != 0 && checkInput()) { List <string> sList = getSQLList(this.gvExcel); InsertCommandBuilder insert = new InsertCommandBuilder(); int count = insert.ExcutTransaction(sList); if (count != 0) { Response.Write("<script>alert('" + Resources.Resource.alterOk + "')</script>"); this.gvExcel.DataSource = null; this.gvExcel.DataBind(); btnUpload.Text = Resources.Resource.yl; } } #endregion } }
protected void btnVerify_Click(object sender, EventArgs e) { try { List <CrushedMaterial> cmList = new List <CrushedMaterial>(); List <string> sqlList = new List <string>(); if (dgvList.Rows.Count != 0 && checkVerifyInput()) { for (int i = 0; i < dgvList.Rows.Count; i++) { if ((dgvList.Rows[i].Cells[0].FindControl("cboCheckItem") as CheckBox).Checked == true) { CrushedMaterial c = new CrushedMaterial() { id = int.Parse((dgvList.Rows[i].Cells[0].FindControl("Hfid") as HiddenField).Value), Name = (dgvList.Rows[i].Cells[1].FindControl("Label1") as Label).Text, MaterialNo = (dgvList.Rows[i].Cells[2].FindControl("Label2") as Label).Text, Material = (dgvList.Rows[i].Cells[3].FindControl("Label3") as Label).Text, JigLeader = (dgvList.Rows[i].Cells[4].FindControl("Label4") as Label).Text, addtime = (dgvList.Rows[i].Cells[5].FindControl("Label5") as Label).Text }; cmList.Add(c); } } if (cmList.Count == 0) { Response.Write("<script>alert('没有选择任何行!')</script>"); return; } string body = "部番:"; List <string> bd = new List <string>(); string list = ""; for (int i = 0; i < cmList.Count; i++) { if (i != cmList.Count - 1) { body += cmList[i].Name + ","; list += cmList[i].JigLeader + ";"; } else { body += cmList[i].Name; list += cmList[i].JigLeader; } UpdateCommandBuilder up = new UpdateCommandBuilder(ConnectionFactory.ConnectionString_hudsonwwwroot, "trymolde"); up.UpdateColumn("isApprove", ddlVerify.SelectedItem.Text); up.UpdateColumn("ApprovedDate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); up.UpdateColumn("Reason", txtReason.Text.Trim()); if (string.IsNullOrEmpty(txtReason.Text.Trim())) { up.UpdateColumn("area1style", "Wait"); up.UpdateColumn("area2style", "Wait"); up.UpdateColumn("area3style", "Wait"); up.UpdateColumn("area4style", "Wait"); } up.ConditionsColumn("id", cmList[i].id); sqlList.Add(up.getUpdateCommand()); } if (ddlVerify.SelectedItem.Text == "NG") { body += "审核未通过,原因为:" + txtReason.Text; mailList = getUserMailAddress(list); } else { bd.Add(body + "审核已通过!" + " <a href='" + url + "?status=Wait&&area=1'>点击此链接开始进行粉碎...</a>"); bd.Add(body + "审核已通过!" + " <a href='" + url + "?status=Wait&&area=2'>点击此链接开始进行粉碎...</a>"); bd.Add(body + "审核已通过!" + " <a href='" + url + "?status=Wait&&area=3'>点击此链接开始进行粉碎...</a>"); bd.Add(body + "审核已通过!" + " <a href='" + url + "?status=Wait&&area=4'>点击此链接开始进行粉碎...</a>"); } InsertCommandBuilder ins = new InsertCommandBuilder(ConnectionFactory.ConnectionString_hudsonwwwroot, "trymolde"); int count = ins.ExcutTransaction(sqlList); if (count != 0) { Response.Write("<script>alert('审核成功!')</script>"); if (mailList != "") { if (ddlVerify.SelectedItem.Text == "NG") { SendMail.ExecuteSendMail(smtpIp, Port, fromUser, fromPwd, mailList, "", "试作品粉碎审核通告(系统邮件,请勿回复!)", body, "", ""); } else { for (int i = 0; i <= 3; i++) { SendMail.ExecuteSendMail(smtpIp, Port, fromUser, fromPwd, ConfigurationManager.AppSettings["area" + (i + 1)].ToString(), "", "试作品粉碎审核通告(系统邮件,请勿回复!)", bd[i], "", ""); } } } dgvList.DataSource = getAllCrushedMaterial(); dgvList.DataBind(); //Response.Write("<script>alert('" + s + "!')</script>"); } else { Response.Write("<script>alert('审核失败!')</script>"); } } } catch (Exception ex) { Response.Write("<script>alert('" + ex.Message + "!')</script>");; } }
protected void btnSave_Click(object sender, EventArgs e) { if (gvAddData.Rows.Count == 0) { return; } List <string> sqlList = new List <string>(); InsertCommandBuilder insert = new InsertCommandBuilder(); if (gvAddData.Columns[11].Visible == false) { for (int i = 0; i < aList.Count; i++) { UpdateCommandBuilder up = new UpdateCommandBuilder("pd_detail"); up.UpdateColumn("Qty", aList[i].pdsl); up.UpdateColumn("pch", aList[i].pch); up.UpdateColumn("hwh", aList[i].hwh); up.ConditionsColumn("Detail_id", aList[i].id); sqlList.Add(up.getUpdateCommand()); //UpdateCommandBuilder up1 = new UpdateCommandBuilder("pre_prd_pk_detail"); //up1.UpdateColumn("pdsl", aList[i].pdsl); //up1.ConditionsColumn("Detail_id", aList[i].id); //sqlList.Add(up1.getUpdateCommand()); } } else { InsertCommandBuilder ins = new InsertCommandBuilder("pd_detail"); string Bill_id = "PD" + DateTime.Now.ToString("ddHHmmssfff"); for (int i = 0; i < lList.Count; i++) { List <string> sList = getBatch_id(lList[i].pm, lList[i].pch); string detail_id = Bill_id + (i + 1).ToString().PadLeft(4, '0'); //string sql = "INSERT INTO tmp_pk_detail ( Bill_id, Batch_id, Goods_id, Qty, Pch, Detail_id, Price, is_can_sale, hwh ) VALUES ( '" + Bill_id + "', '盘盈入库', '3034', 500.000000, '无库存', 'PB2012072109381211401010938257800002', 1.225000, 'Y', '' )"; ins.CommandClear(); ins.InsertColumn("Bill_id", Bill_id); ins.InsertColumn("prd_Batch_id", sList[1].Trim()); ins.InsertColumn("materials_id", sList[0].Trim()); ins.InsertColumn("Qty", lList[i].pdsl); ins.InsertColumn("Pch", lList[i].pch); ins.InsertColumn("Detail_id", detail_id); ins.InsertColumn("Price", lList[i].Price); ins.InsertColumn("is_can_sale", "Y"); ins.InsertColumn("hwh", lList[i].hwh); ins.InsertColumn("is_new", "Y"); sqlList.Add(ins.getInsertCommand()); int countPD = Convert.ToInt32(new SelectCommandBuilder().ExecuteScalar("select count(*) from pre_prd_pk_detail WHERE (prd_pk_id = '" + txtPK_Id.Text.Trim().ToUpper() + "') AND (prd_batch_id = '" + lList[i].b_id + "') AND (stock_remain_id = '" + lList[i].s_id + "') ")); if (countPD != 0) { string updateSQL = "update pre_prd_pk_detail set pdsl =" + lList[i].pdsl + ",detail_id = '" + detail_id + "' WHERE (prd_pk_id = '" + txtPK_Id.Text.Trim().ToUpper() + "') AND (prd_batch_id = '" + lList[i].b_id + "') AND (stock_remain_id = '" + lList[i].s_id + "') "; sqlList.Add(updateSQL); } } ins.CommandClear(); ins = new InsertCommandBuilder("pd"); ins.InsertColumn("Bill_Id", Bill_id); ins.InsertColumn("Bill_no", txtPK_No.Text.Trim()); ins.InsertColumn("Pk_id", txtPK_Id.Text.Trim().ToUpper()); ins.InsertColumn("store_id", ddlMaterialStock.SelectedItem.Value.Trim()); ins.InsertColumn("Crt_emp", HttpContext.Current.Request.Cookies["cookie"].Values["id"]); ins.InsertColumn("Crt_Date", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); ins.InsertColumn("Status", "N"); ins.InsertColumn("Remark", txtRemark.Text.Trim().ToUpper()); sqlList.Add(ins.getInsertCommand()); } int count = insert.ExcutTransaction(sqlList); if (count != 0) { Response.Write("<script>alert('" + Resources.Resource.alterOk + "')</script>"); lList.Clear(); aList.Clear(); gvAddData.DataSource = lList; gvAddData.DataBind(); ClearTextBox(); ddlMaterialStock.Enabled = true; ddlMaterialStock.SelectedIndex = 0; gvDetailData.DataSource = null; gvDetailData.DataBind(); } }
protected void btnBegin_Click(object sender, EventArgs e) { //string sql = "INSERT INTO pre_pk ( pk_id, pk_no, pk_date, store_id, verifier, operator_id, remark, str_in_bill_id, str_out_bill_id, islocal, pkms ) VALUES ( 'PK000009420101', '', '2012-7-17 8:49:33.056', '03', '', '0000', '', 'RK001406270101', 'CK000548050101', 'Y', '正常按批次盘库' )"; string ss = "select count(*) from pre_pk where store_id='" + ddlMaterialStock.SelectedItem.Value.Trim() + "' and CONVERT(varchar(100), pk_Date, 112) = '" + DateTime.Now.ToString("yyyyMMdd") + "'"; int count = Convert.ToInt32(new SelectCommandBuilder().ExecuteScalar(ss)); if (count != 0) { Response.Write("<script>alert('" + Resources.Resource.alertWxqd + "')</script>"); gvData.DataSource = getData(); gvData.DataBind(); return; } string sql = @" SELECT goods.dm, goods.goods_name, goods.spec, sccj.sccj_name as sccjname, goods.goods_unit, batch.pch as pch, price = isnull(batch.price,0.0), stock_remain.qty as zmsl, stock_remain.qty as pdsl, batch.yxq, ' ' as stock_type_id, stock_remain.is_can_sale, batch.str_in_date, stock_remain.batch_id , stock_remain.stock_remain_id, stock_remain.goods_id, 'ddd' as pk_id, 'N' as disobey, stock_remain.qty as zmsl1, stock_remain.qty as pdsl1, price.price as saleprice, batch.mjpch, c.location as location, isnull(( select counter_name from counter where counter.counter_id = c.counter_id), '未设置') as counter , d.style, d.dictate_name, customer_name = (select bb.customer_name from xsht aa,customer bb where aa.customer_id = bb.customer_id and aa.xsht_id = d.order_id ), batch.hwh as 'hwh', goods.cz, goods.ys FROM goods, stock_remain, batch , price , sccj, goods_counter c , prd_dictate d WHERE ( stock_remain.goods_id = goods.goods_id ) and stock_Remain.batch_id = batch.batch_id and batch.dictate_id *= d.dictate_id and goods.sccj_id *= sccj.sccj_id and stock_remain.stockstatus = 'N' and goods.price_id *= price.price_id and stock_remain.store_id = '" + ddlMaterialStock.SelectedItem.Value.Trim() + @"' and stock_remain.goods_id like '%' and goods.goods_id *= c.goods_id and stock_remain.store_id *= c.store_id and 1 = 1" ; DataTable dt = new SelectCommandBuilder().ExecuteDataTable(sql); if (dt == null || dt.Rows.Count == 0) { Response.Write("<script>alert('" + Resources.Resource.alertWsj + "')</script>"); return; } List <string> sqlList = new List <string>(); InsertCommandBuilder ins = new InsertCommandBuilder("pre_pk"); string pkId = CommadMethod.getNextId("HPD", "0101"); ins.InsertColumn("pk_id", pkId); ins.InsertColumn("pk_no", ""); ins.InsertColumn("pk_date", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); ins.InsertColumn("store_id", ddlMaterialStock.SelectedItem.Value.Trim()); ins.InsertColumn("verifier", ""); ins.InsertColumn("operator_id", HttpContext.Current.Request.Cookies["cookie"].Values["id"]); ins.InsertColumn("remark", txtRemark.Text.Trim().ToUpper()); //ins.InsertColumn("str_in_bill_id", getId()); //ins.InsertColumn("str_out_bill_id", getId()); ins.InsertColumn("islocal", "Y"); ins.InsertColumn("pkms", "正常按批次盘库"); sqlList.Add(ins.getInsertCommand()); for (int i = 0; i < dt.Rows.Count; i++) { ins = new InsertCommandBuilder("pre_pk_Detail"); ins.InsertColumn("pk_id", pkId); ins.InsertColumn("stock_remain_id", dt.Rows[i]["stock_remain_id"]); ins.InsertColumn("goods_id", dt.Rows[i]["goods_id"]); ins.InsertColumn("pdsl", 0); ins.InsertColumn("zmsl", dt.Rows[i]["zmsl"]); ins.InsertColumn("batch_id", dt.Rows[i]["batch_id"]); ins.InsertColumn("zmsl1", dt.Rows[i]["zmsl1"]); ins.InsertColumn("pdsl1", dt.Rows[i]["pdsl1"]); ins.InsertColumn("is_can_sale", dt.Rows[i]["is_can_sale"]); sqlList.Add(ins.getInsertCommand()); } ins.ExcutTransaction(sqlList); gvData.DataSource = getData(); gvData.DataBind(); }
protected void btnConfirm_Click(object sender, EventArgs e) { if (ddlVendor.SelectedIndex == 0) { ClientScript.RegisterClientScriptBlock(ClientScript.GetType(), "alert", "<script>alert('请选择供应商')</script>", false); return; } if (string.IsNullOrEmpty(txtDate.Text)) { ClientScript.RegisterClientScriptBlock(ClientScript.GetType(), "alert", "<script>alert('请选择采购日期')</script>", false); return; } List <Details> DList = new List <Details>(); List <string> SList = new List <string>(); for (int i = 0; i < gvDetailData.Rows.Count; i++) { if ((gvDetailData.Rows[i].Cells[0].FindControl("checkbox1") as CheckBox).Checked == true) { if (string.IsNullOrEmpty((gvDetailData.Rows[i].Cells[6].FindControl("txtPrice") as TextBox).Text.Trim())) { ClientScript.RegisterClientScriptBlock(ClientScript.GetType(), "alert", "<script>alert('请输入价格')</script>", false); (gvDetailData.Rows[i].Cells[6].FindControl("txtPrice") as TextBox).Focus(); return; } Details dItem = new Details() { Apply_No = Apply_No, MNo = Mno, Name = gvDetailData.Rows[i].Cells[2].Text.Trim(), Texture = gvDetailData.Rows[i].Cells[3].Text.Trim(), Spec = gvDetailData.Rows[i].Cells[4].Text.Trim(), Qty = Convert.ToInt32(gvDetailData.Rows[i].Cells[5].Text.Trim()), Price = Convert.ToDouble((gvDetailData.Rows[i].Cells[6].FindControl("txtPrice") as TextBox).Text.Trim()), Id = Convert.ToInt64(gvDetailData.Rows[i].Cells[7].Text.Trim()) }; DList.Add(dItem); } } if (DList.Count == 0) { ClientScript.RegisterClientScriptBlock(ClientScript.GetType(), "alert", "<script>alert('无选择数据')</script>", false); return; } string Id = CommadMethod.getNextId("PCH" + DateTime.Now.ToString("yyyyMMdd"), "").Trim(); InsertCommandBuilder insert = new InsertCommandBuilder("m_materails_pch_order_detail"); for (int i = 0; i < DList.Count; i++) { UpdateCommandBuilder up = new UpdateCommandBuilder("m_materails_apply_detail"); up.UpdateColumn("is_check", "Y"); up.ConditionsColumn("Id", DList[i].Id); insert.InsertColumn("Order_No", Id); insert.InsertColumn("name", DList[i].Name); insert.InsertColumn("texture", DList[i].Texture); insert.InsertColumn("spec", DList[i].Spec); insert.InsertColumn("qty", DList[i].Qty); insert.InsertColumn("price", DList[i].Price); insert.InsertColumn("is_end", "N"); insert.InsertColumn("wb_id", ddlwb.SelectedItem.Value); SList.Add(insert.getInsertCommand()); SList.Add(up.getUpdateCommand()); insert.CommandClear(); } InsertCommandBuilder ins = new InsertCommandBuilder("m_materails_pch_order"); ins.InsertColumn("Order_date", txtDate.Text); ins.InsertColumn("Order_No", Id); if (!string.IsNullOrEmpty(Mno)) { ins.InsertColumn("mode_no", Mno); } ins.InsertColumn("Vendor_id", ddlVendor.SelectedItem.Value); ins.InsertColumn("Remark", txtRemark.Text.Trim()); ins.InsertColumn("Operator_id", "0000"); ins.InsertColumn("Operator_Date", "getDate()"); ins.InsertColumn("isCheck", "N"); SList.Add(ins.getInsertCommand()); int count = ins.ExcutTransaction(SList); if (count != 0) { ClientScript.RegisterClientScriptBlock(ClientScript.GetType(), "alert", "<script>alert('保存成功')</script>", false); gvDetailData.DataSource = null; gvDetailData.DataBind(); txtDate.Text = string.Empty; txtRemark.Text = string.Empty; ddlVendor.SelectedIndex = 0; ddlwb.SelectedIndex = 0; string updateSql = ""; int countY = 0; if (string.IsNullOrEmpty(Mno)) { updateSql = "update m_materails_apply set is_confirm = 'E' where apply_no='" + Apply_No.Trim() + "'"; countY = Convert.ToInt32(new SelectCommandBuilder().ExecuteScalar("select count(*) from m_materails_apply_detail where apply_no='" + Id.Trim() + "' and is_check = 'N' ")); } else { updateSql = "update m_materails_apply set is_confirm = 'E' where mode_no = '" + Mno.Trim() + "'"; countY = Convert.ToInt32(new SelectCommandBuilder().ExecuteScalar("select count(*) from m_materails_apply_detail where apply_no='" + Id.Trim() + "' and is_check = 'N' ")); } if (countY == 0) { new UpdateCommandBuilder().ExecuteNonQuery(updateSql); } } else { ClientScript.RegisterClientScriptBlock(ClientScript.GetType(), "alert", "<script>alert('保存失败')</script>", false); } }
protected void Unnamed2_Click(object sender, EventArgs e) { try { if (btnUpload.Text == "预 览") { #region 将上传的Excel数据显示在GridView中 if (FileUpload1.HasFile == false) { ClientScript.RegisterStartupScript(ClientScript.GetType(), "error", "<script>alert('请您选择Excel文件!')</script>"); //Response.Write("<script>alert('请您选择Excel文件')</script> "); return;//当无文件时,返回 } string IsXls = System.IO.Path.GetExtension(FileUpload1.FileName).ToString().ToLower(); if (IsXls != ".xls") { Response.Write("<script>alert('只可以选择Excel文件')</script>"); return;//当选择的不是Excel文件时,返回 } btnUpload.Text = "确认上传"; Button1.Text = "取 消"; string path = Server.MapPath("~/UploadExcel/"); string strpath = FileUpload1.PostedFile.FileName.ToString(); //string filename = FileUpload1.FileName; FileUpload1.PostedFile.SaveAs(path + FileUpload1.FileName); string Filename = path + FileUpload1.FileName; FileStream file = new FileStream(Filename, FileMode.Open, FileAccess.Read); HSSFWorkbook hssfworkbook = new HSSFWorkbook(file); Sheet sheet = hssfworkbook.GetSheetAt(0); DataTable table = new DataTable(); Row headerRow = sheet.GetRow(1); int cellCount = headerRow.LastCellNum; for (int i = headerRow.FirstCellNum; i < cellCount; i++) { DataColumn column = new DataColumn(headerRow.GetCell(i).StringCellValue); table.Columns.Add(column); } int rowCount = sheet.LastRowNum; for (int i = (sheet.FirstRowNum + 2); i < sheet.LastRowNum + 1; i++) { Row row = sheet.GetRow(i); DataRow dataRow = table.NewRow(); if (string.IsNullOrEmpty(row.GetCell(0).ToString())) { continue; } for (int j = row.FirstCellNum; j < cellCount; j++) { if (row.GetCell(j) != null) { dataRow[j] = row.GetCell(j).ToString(); } } table.Rows.Add(dataRow); } hssfworkbook = null; sheet = null; this.gvExcel.DataSource = table; this.gvExcel.DataBind(); File.Delete(Filename); ViewState["value"] = validate(); #endregion } else { #region 确认上传数据 if (Convert.ToInt32(ViewState["value"]) != 0) { Response.Write("<script>alert('系统出现以下错误:\\n验证未通过,请修正背景色为红色的数据后再试!')</script>"); return; } if (gvExcel.Rows.Count == 0) { Response.Write("<script>alert('数据为空,请重新确认后重试!')</script>"); return; } if (ddlCustomer.SelectedItem.Value == "0") { Response.Write("<script>alert('请选择客户名称!')</script>"); return; } List <string> sList = getSQLList(this.gvExcel); InsertCommandBuilder insert = new InsertCommandBuilder(constr, ""); int count = insert.ExcutTransaction(sList); if (count != 0) { Response.Write("<script>alert('上传成功')</script>"); this.gvExcel.DataSource = null; this.gvExcel.DataBind(); btnUpload.Text = "预 览"; } else { Response.Write("<script>alert('上传失败')</script>"); } #endregion } } catch (Exception ex) { Response.Write("<script>alert('系统出现以下错误:\\n" + ex.Message + "!')</script>"); } }
protected void btnSave_Click(object sender, EventArgs e) { txtAlert.Text = string.Empty; try { List <string> sqlList = new List <string>(); InsertCommandBuilder ins = new InsertCommandBuilder("tmp_pk_detail"); //InsertCommandBuilder insert = new InsertCommandBuilder("pre_prd_pk_detail"); string Bill_id = CommadMethod.getNextId("PB", "0101"); for (int i = 0; i < iList.Count; i++) { List <string> sList = getBatch_id(iList[i].pm, iList[i].pch); string detail_id = Bill_id + (i + 1).ToString().PadLeft(4, '0'); //string sql = "INSERT INTO tmp_pk_detail ( Bill_id, Batch_id, Goods_id, Qty, Pch, Detail_id, Price, is_can_sale, hwh ) VALUES ( '" + Bill_id + "', '盘盈入库', '3034', 500.000000, '无库存', 'PB2012072109381211401010938257800002', 1.225000, 'Y', '' )"; ins.CommandClear(); ins.InsertColumn("Bill_id", Bill_id); ins.InsertColumn("Batch_id", sList[1].Trim()); ins.InsertColumn("Goods_id", sList[0].Trim()); ins.InsertColumn("Qty", iList[i].pdsl); ins.InsertColumn("Pch", iList[i].pch); ins.InsertColumn("Detail_id", detail_id); ins.InsertColumn("is_can_sale", "Y"); ins.InsertColumn("hwh", iList[i].hwh); sqlList.Add(ins.getInsertCommand()); //insert.CommandClear(); //insert.InsertColumn("prd_pk_id", ViewState["bill_id"]); //insert.InsertColumn("stock_remain_id", ViewState["bill_no"]); //insert.InsertColumn("materials_id", sList[0].Trim()); //insert.InsertColumn("pdsl", iList[i].pdsl); //insert.InsertColumn("zmsl", 0); //insert.InsertColumn("prd_batch_id", sList[1].Trim()); //insert.InsertColumn("zmsl1", 0); //insert.InsertColumn("pdsl1", iList[i].pdsl); //insert.InsertColumn("is_can_sale", "Y"); //insert.InsertColumn("detail_id", detail_id); //sqlList.Add(insert.getInsertCommand()); } ins.CommandClear(); ins = new InsertCommandBuilder("tmp_pk_bill"); ins.InsertColumn("Bill_Id", Bill_id); ins.InsertColumn("Bill_no", ViewState["bill_no"]); ins.InsertColumn("Pk_id", ViewState["bill_id"]); ins.InsertColumn("store_id", ViewState["s"]); ins.InsertColumn("Crt_emp", HttpContext.Current.Request.Cookies["cookie"].Values["id"]); ins.InsertColumn("Crt_Date", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); ins.InsertColumn("Status", "N"); ins.InsertColumn("isAdd", "Y"); //ins.InsertColumn("Remark", txtRemark.Text.Trim().ToUpper()); sqlList.Add(ins.getInsertCommand()); int c = ins.ExcutTransaction(sqlList); if (c != 0) { //Response.Write("<script>alert('" + Resources.Resource.alterOk + "')</script>"); txtAlert.Text = Resources.Resource.alterOk; gvAddData.DataSource = null; gvAddData.DataBind(); iList.Clear(); } else { //Response.Write("<script>alert('" + Resources.Resource.alterfiald + "')</script>"); txtAlert.Text = Resources.Resource.alterfiald; } } catch (Exception ex) { txtAlert.Text = ex.Message; //Response.Write("<script>alert('" + ex.Message + "')</script>"); } }
protected void Unnamed2_Click(object sender, EventArgs e) { if (btnUpload.Text == Resources.Resource.yl) { #region 将上传的Excel数据显示在GridView中 if (FileUpload1.HasFile == false) { ClientScript.RegisterStartupScript(ClientScript.GetType(), "error", "<script>alert('" + Resources.Resource.alertxzwj + "!')</script>"); return; } string IsXls = System.IO.Path.GetExtension(FileUpload1.FileName).ToString().ToLower(); if (IsXls != ".xls") { Response.Write("<script>alert('" + Resources.Resource.alertxzexcel + "')</script>"); return; } btnUpload.Text = Resources.Resource.qr; Button1.Text = Resources.Resource.qx; string path = Server.MapPath("~/UploadExcel/"); string strpath = FileUpload1.PostedFile.FileName.ToString(); //string filename = FileUpload1.FileName; FileUpload1.PostedFile.SaveAs(path + FileUpload1.FileName); string Filename = path + FileUpload1.FileName; FileStream file = new FileStream(Filename, FileMode.Open, FileAccess.Read); HSSFWorkbook hssfworkbook = new HSSFWorkbook(file); Sheet sheet = hssfworkbook.GetSheetAt(0); DataTable table = new DataTable(); Row headerRow = sheet.GetRow(0); int cellCount = headerRow.LastCellNum; for (int i = headerRow.FirstCellNum; i < cellCount; i++) { DataColumn column = new DataColumn(headerRow.GetCell(i).StringCellValue); table.Columns.Add(column); } int rowCount = sheet.LastRowNum; for (int i = (sheet.FirstRowNum + 1); i < sheet.LastRowNum + 1; i++) { Row row = sheet.GetRow(i); DataRow dataRow = table.NewRow(); for (int j = row.FirstCellNum; j < cellCount; j++) { if (row.GetCell(j) != null) { dataRow[j] = row.GetCell(j).ToString(); } } table.Rows.Add(dataRow); } hssfworkbook = null; sheet = null; this.gvExcel.DataSource = table; this.gvExcel.DataBind(); File.Delete(Filename); #endregion } else { #region 确认上传数据 if (gvExcel.Rows.Count == 0) { Response.Write("<script>alert('" + Resources.Resource.alertksj + "')</script>"); return; } string Text10 = ""; List <string> sList = getSQLList(this.gvExcel); UpdateCommandBuilder up = new UpdateCommandBuilder(); up.ExecuteNonQuery("update Client_FC set status='Y' where len(no_id)>1"); up.ExecuteNonQuery("update Client_FC set delivery_no='" + Text10 + "'+convert(varchar(6),delivery_date,112) where ( len(delivery_no) =0 and status='N')"); up.ExecuteNonQuery("update Client_FC set operation_flag='N' where (operation_flag is null and status='N' )"); SqlParameter[] parm = new SqlParameter[] { new SqlParameter("@Kh_id", txtCName.SelectedItem.Value.Split('|')[0].Trim()), new SqlParameter("@Dly_no", txtCName.SelectedItem.Value.Split('|')[1].Trim() + Convert.ToDateTime(txtDate.Text).ToString("yyyyMM")), new SqlParameter("@dat", Convert.ToDateTime(txtDate.Text).ToString("yyyyMM")) }; SqlHelper.ExecuteNonQuery(base.ConnectionString, CommandType.StoredProcedure, "Client_FC_Ver", parm); up.ExecuteNonQuery("Update Client_FC Set lb1_id = goods.lb1_id FROM Client_FC INNER JOIN goods ON goods.goods_name = Client_FC.goods_name WHERE status = 'N'"); parm = new SqlParameter[] { new SqlParameter("@Op_id", ip.Trim() + HttpContext.Current.Request.Cookies["cookie"].Values["id"].Trim()) }; SqlHelper.ExecuteNonQuery(base.ConnectionString, CommandType.StoredProcedure, "Demands_goods_expand", parm); parm = new SqlParameter[] { new SqlParameter("@Kh_id", txtCName.SelectedItem.Value.Split('|')[0].Trim()), new SqlParameter("@Op_id", ip.Trim() + HttpContext.Current.Request.Cookies["cookie"].Values["id"].Trim()), new SqlParameter("@dat", Convert.ToDateTime(txtDate.Text).ToString("yyyyMM")) }; SqlHelper.ExecuteNonQuery(base.ConnectionString, CommandType.StoredProcedure, "Client_FC_ID", parm); up.ExecuteNonQuery("update Client_FC set status='Y' where len(no_id)>1"); InsertCommandBuilder insert = new InsertCommandBuilder(); int count = insert.ExcutTransaction(sList); if (count != 0) { Response.Write("<script>alert('" + Resources.Resource.alterOk + "')</script>"); this.gvExcel.DataSource = null; this.gvExcel.DataBind(); btnUpload.Text = Resources.Resource.yl; } else { Response.Write("<script>alert('" + Resources.Resource.alterfiald + "')</script>"); } #endregion } }