private void Do() { Mno.Focus(); Invalid.Text = ""; Resend.Hide(); SendB.Text = "Send"; Mno.Text = ""; otp.Text = ""; otp.Enabled = false; UserID.Enabled = true; Password.Enabled = true; Mno.Enabled = true; }
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); } }