public void waitStorge(string label, string goodsName, int Qty, string userId) { InsertData(label, goodsName, Qty, 1, userId); SelectCommandBuilder s = new SelectCommandBuilder(); int count = Convert.ToInt32(s.ExecuteScalar("select count(*) from Material_control_process where label = '" + label + "' and process_id = 1")); string sql = string.Empty; if (count != 0) { UpdateCommandBuilder up = new UpdateCommandBuilder(); sql = "update Material_control_process set InQty = InQty + " + Qty + " ,CurrQty = CurrQty + " + Qty + " where label = '" + label + "' and process_id = 1"; } else { InsertCommandBuilder ins = new InsertCommandBuilder("Material_control_process"); ins.InsertColumn("label", label); ins.InsertColumn("goods_name", goodsName); ins.InsertColumn("process_id", 1); ins.InsertColumn("InQty", Qty); ins.InsertColumn("OutQty", 0); ins.InsertColumn("CurrQty", Qty); ins.InsertColumn("in_date", "getDate()"); sql = ins.getInsertCommand(); } new InsertCommandBuilder().ExecuteNonQuery(sql); }
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,条码???")); }
public void print(string label, string goodsName, int Qty, string userId) { InsertData(label, goodsName, Qty, 3, userId); SelectCommandBuilder s = new SelectCommandBuilder(); int count = Convert.ToInt32(s.ExecuteScalar("select count(*) from Material_control_process where label = '" + label + "' and process_id = 3")); string sql = string.Empty; if (count != 0) { sql = "update Material_control_process set OutQty = InQty + " + Qty + " ,CurrQty = CurrQty + " + Qty + " where label = '" + label + "' and process_id = 3 "; } else { InsertCommandBuilder ins = new InsertCommandBuilder("Material_control_process"); ins.InsertColumn("label", label); ins.InsertColumn("goods_name", goodsName); ins.InsertColumn("process_id", 3); ins.InsertColumn("InQty", Qty); ins.InsertColumn("OutQty", 0); ins.InsertColumn("CurrQty", Qty); ins.InsertColumn("in_date", "getDate()"); sql = ins.getInsertCommand(); } string sql1 = "update Material_control_process set OutQty = OutQty + " + Qty + " ,CurrQty = CurrQty - " + Qty + " where label = '" + label + "' and process_id = 1 "; List <string> list = new List <string>(); list.Add(sql); list.Add(sql1); new InsertCommandBuilder().ExcutTransaction(list); }
protected void btnAdd_Click(object sender, EventArgs e) { if (ddlMaterialStock.SelectedItem.Value == "0") { Response.Write("<script>alert('请选择仓位点')</script>"); return; } if (txtNo.Text.Trim().Equals(string.Empty)) { Response.Write("<script>alert('请输入单号')</script>"); return; } DateTime date = DateTime.Now; string IdLeftPart = "HC" + date.Year.ToString().Substring(2, 2) + date.Month.ToString().PadLeft(2, '0') + date.Day.ToString().PadLeft(2, '0'); string str_out_bill_id = CommadMethod.getNextId(IdLeftPart, ""); InsertCommandBuilder ins = new InsertCommandBuilder(constr, "pre_str_out_bill"); ins.InsertColumn("str_out_bill_id", str_out_bill_id); ins.InsertColumn("str_out_bill_no", txtNo.Text.Trim().ToUpper()); ins.InsertColumn("str_out_type_id", rbtType.SelectedItem.Value); ins.InsertColumn("str_out_date", txtDate.Text); ins.InsertColumn("store_id", ddlMaterialStock.SelectedItem.Value); ins.InsertColumn("operator_id", "0000"); ins.InsertColumn("remark", txtRemark.Text.Trim()); ins.InsertColumn("operator_date", txtDate.Text); ins.InsertColumn("come_to", rbtType.SelectedItem.Text); ins.InsertColumn("islocal", "Y"); ins.InsertColumn("save_state", "Y"); sql = ins.getInsertCommand(); No = txtNo.Text.Trim(); bill_id = str_out_bill_id; Server.Transfer("StockOut_AddData.aspx"); }
public IInsertCommandBeforeOrAfterTargetSyntax InsertPartialView(string viewName, object model) { var commandBuilder = new InsertCommandBuilder(this); commandBuilder.SetPartialView(viewName, model); return(commandBuilder); }
protected void btnSave_Click(object sender, EventArgs e) { if (insList.Count == 0) { Response.Write("<script>alert('无数据保存,请先添加数据')</script>"); return; } List <string> sqlList = new List <string>(); sqlList.Add(ViewState["sql"].ToString()); DateTime date = DateTime.Now; string IdLeftPart = "PH" + date.Year.ToString().Substring(2, 2) + date.Month.ToString().PadLeft(2, '0') + date.Day.ToString().PadLeft(2, '0'); for (int i = 0; i < insList.Count; i++) { string Id = CommadMethod.getNextId(IdLeftPart, ""); InsertCommandBuilder ins = new InsertCommandBuilder(constr, "pre_str_in_bill_detail"); ins.InsertColumn("str_in_bill_id", ViewState["str_in_bill_id"].ToString()); ins.InsertColumn("batch_id", Id); ins.InsertColumn("goods_id", new SelectCommandBuilder(constr, "").ExecuteDataTable("select goods_id from goods_tmp where goods_name = '" + insList[i].goods_name + "'").Rows[0][0].ToString().Trim()); ins.InsertColumn("qty", insList[i].Qty.ToString()); ins.InsertColumn("pch", insList[i].batch); ins.InsertColumn("can_sale", "Y"); ins.InsertColumn("hwh", insList[i].goodsPost); sqlList.Add(ins.getInsertCommand()); } int count = new InsertCommandBuilder(constr, "").ExcutTransaction(sqlList); if (count != 0) { Response.Write("<script>alert('保存成功')</script>"); insList.Clear(); Response.Redirect("StockIn_SaveOk.aspx"); } }
public void ImportData(string tableName, DataTable dataTable) { // Don't continue if no data passed if (dataTable == null) { throw new ArgumentNullException(nameof(dataTable)); } CommandExecutor commandExecutor = new CommandExecutor(); InsertCommandBuilder insertCommandBuilder; // To prevent attempting to import deleted rows, need to accept changes on the passed datatable first dataTable.AcceptChanges(); // Run an INSERT command for each row foreach (DataRow row in dataTable.Rows) { insertCommandBuilder = new InsertCommandBuilder(); insertCommandBuilder.SetTableName(tableName); // Construct INSERT command for (int i = 0; i < dataTable.Columns.Count; i++) { if (dataTable.Columns[i].ColumnName == "_id") { continue; } insertCommandBuilder.AddField(dataTable.Columns[i].ColumnName, row[i]); } // Insert into database commandExecutor.ExecuteNonQuery(insertCommandBuilder.ToString()); } }
protected List <string> getSQLList(GridView dgv) { for (int i = 0; i < dgv.Rows.Count; i++) { for (int j = 0; j < dgv.Rows[i].Cells.Count; j++) { if (dgv.Rows[i].Cells[j].Text == " ") { dgv.Rows[i].Cells[j].Text = ""; } } } List <string> sList = new List <string>(); InsertCommandBuilder ins = new InsertCommandBuilder("Client_FC"); for (int i = 0; i < dgv.Rows.Count; i++) { ins.InsertColumn("NO_id", "1"); ins.InsertColumn("goods_name", dgv.Rows[i].Cells[0].Text.ToString()); //ins.InsertColumn("lb1_id", dgv.Rows[i].Cells[1].Text.ToString()); ins.InsertColumn("client_id", dgv.Rows[i].Cells[2].Text.ToString()); ins.InsertColumn("FC_qty", dgv.Rows[i].Cells[3].Text.ToString()); ins.InsertColumn("delivery_date", Convert.ToDateTime(dgv.Rows[i].Cells[4].Text).ToString("yyyy-MM-dd HH:mm:ss")); ins.InsertColumn("delivery_no", dgv.Rows[i].Cells[5].Text.ToString()); ins.InsertColumn("remark", txtRemark.Text.Trim()); ins.InsertColumn("version_no", txtVer_No.Text.Trim()); ins.InsertColumn("status", "N"); ins.InsertColumn("operation_date", "getDate()"); ins.InsertColumn("operator_id", HttpContext.Current.Request.Cookies["cookie"].Values["id"]); sList.Add(ins.getInsertCommand()); ins.CommandClear(); } return(sList); }
public int Insert(Type itemType, object item, string tableName) { InsertCommandBuilder inserter = InsertCommandBuilder.Create(itemType); DbCommand command = inserter.Build(item, tableName, _database, Connection, Transaction); command.ExecuteNonQuery(); return((int)inserter.GetKey(command)); }
public static InsertCommandBuilder Insert(this IDataContext context, string table) { var builder = new InsertCommandBuilder(context); builder.From(table); return(builder); }
protected List <string> getSQLList(GridView dgv) { int index = 0; List <string> sList = new List <string>(); try { InsertCommandBuilder insert = new InsertCommandBuilder(constr, "Goods_Up"); for (int i = 0; i < dgv.Rows.Count; i++) { string goods_name = dgv.Rows[i].Cells[0].Text.ToString().ToUpper(); index = i; SelectCommandBuilder s = new SelectCommandBuilder(constr, "goods_tmp"); s.SelectColumn("Count(goods_id)"); s.ConditionsColumn("goods_name", goods_name.Trim()); s.getSelectCommand(); int count = Convert.ToInt32(s.ExecuteScalar()); if (count == 0) { sList.Add(InsertData( dgv.Rows[i].Cells[0].Text.ToString().ToUpper(), dgv.Rows[i].Cells[1].Text.ToString().ToUpper(), dgv.Rows[i].Cells[2].Text.ToString().ToUpper(), dgv.Rows[i].Cells[3].Text.ToString().ToUpper(), dgv.Rows[i].Cells[4].Text.ToString().ToUpper(), dgv.Rows[i].Cells[5].Text.ToString().ToUpper(), dgv.Rows[i].Cells[6].Text.ToString().ToUpper(), dgv.Rows[i].Cells[7].Text.ToString().ToUpper(), dgv.Rows[i].Cells[8].Text.ToString().ToUpper(), dgv.Rows[i].Cells[9].Text.ToString().ToUpper(), dgv.Rows[i].Cells[10].Text.ToString().ToUpper(), dgv.Rows[i].Cells[11].Text.ToString().ToUpper(), dgv.Rows[i].Cells[12].Text.ToString().ToUpper(), dgv.Rows[i].Cells[13].Text.ToString().ToUpper(), dgv.Rows[i].Cells[14].Text.ToString().ToUpper(), dgv.Rows[i].Cells[15].Text.ToString().ToUpper(), dgv.Rows[i].Cells[16].Text.ToString().ToUpper(), dgv.Rows[i].Cells[17].Text.ToString().ToUpper(), dgv.Rows[i].Cells[18].Text.ToString().ToUpper(), dgv.Rows[i].Cells[19].Text.ToString().ToUpper(), dgv.Rows[i].Cells[20].Text.ToString().ToUpper(), dgv.Rows[i].Cells[21].Text.ToString().ToUpper().IndexOf('%') != -1 ? (Convert.ToDecimal(dgv.Rows[i].Cells[21].Text.ToString().ToUpper().Split('%')[0]) / 100).ToString() : (Convert.ToDecimal(dgv.Rows[i].Cells[21].Text.ToString().ToUpper()) / 100).ToString(), dgv.Rows[i].Cells[22].Text.ToString().ToUpper(), dgv.Rows[i].Cells[23].Text.ToString().ToUpper(), dgv.Rows[i].Cells[24].Text.ToString().ToUpper(), dgv.Rows[i].Cells[25].Text.ToString().ToUpper(), ddlCustomer.SelectedItem.Value )); } } } catch (Exception ex) { Response.Write("<script>alert('系统出现以下错误:" + ex.Message + "!')</script>"); gvExcel.Rows[index].BackColor = System.Drawing.Color.Red; } return(sList); }
public void Build_Throws_When_FieldValues_Are_Empty() { // Arrange var input = new InsertCommandBuilder().Into("MyTable").AddFieldNames("Field1", "Field2", "Field3"); // Act & Assert input.Invoking(x => x.Build()) .Should().Throw <InvalidOperationException>() .WithMessage("field values are missing"); }
public void Build_Throws_When_TableName_Is_Missing() { // Arrange var input = new InsertCommandBuilder(); // Act & Assert input.Invoking(x => x.Build()) .Should().Throw <InvalidOperationException>() .WithMessage("table name is missing"); }
public IInsertCommandBeforeOrAfterTargetSyntax InsertContent(PartialViewResult partialViewResult) { if (partialViewResult == null) { throw new ArgumentNullException("partialViewResult"); } var commandBuilder = new InsertCommandBuilder(this); commandBuilder.SetContent(partialViewResult); return(commandBuilder); }
public void Build_Throws_When_FieldNames_And_FieldValues_Count_Are_Not_Equal() { // Arrange var input = new InsertCommandBuilder().Into("MyTable") .AddFieldNames(new[] { "Field1", "Field2", "Field3" }.AsEnumerable()) .AddFieldValues(new[] { "Value1", "Value2" }.AsEnumerable()); // Act & Assert input.Invoking(x => x.Build()) .Should().Throw <InvalidOperationException>() .WithMessage("field name count should be equal to field value count"); }
public IInsertCommandBeforeOrAfterTargetSyntax InsertContent(string html) { if (html == null) { throw new ArgumentNullException("html"); } var commandBuilder = new InsertCommandBuilder(this); commandBuilder.SetContent(html); return(commandBuilder); }
public void Test() { DBConnection connection = TestSettings.CreateConnection(); InsertCommandBuilder builder = new InsertCommandBuilder(connection); builder.TableName = "Table1"; builder.AddParameter("value", "1"); IDbCommand command = builder.Build(); Assert.IsNotNull(command); Assert.AreEqual(1, connection.ExecuteNonQuery(command)); }
protected void btnAdd_Click(object sender, EventArgs e) { if (ddlMaterialStock.SelectedItem.Value == "0") { Response.Write("<script>alert('请选择仓位点')</script>"); return; } if (txtNo.Text.Trim().Equals(string.Empty)) { Response.Write("<script>alert('请输入单号')</script>"); txtNo.Focus(); return; } if (rbtType.SelectedIndex != 0) { if (txtgoodsName.Text == string.Empty) { Response.Write("<script>alert('请输入部番')</script>"); txtgoodsName.Focus(); return; } if (gvList.SelectedIndex == -1) { Response.Write("<script>alert('没有选择计划')</script>"); return; } } DateTime date = DateTime.Now; string IdLeftPart = "HC" + date.Year.ToString().Substring(2, 2) + date.Month.ToString().PadLeft(2, '0') + date.Day.ToString().PadLeft(2, '0'); string str_in_bill_id = CommadMethod.getNextId(IdLeftPart, ""); InsertCommandBuilder ins = new InsertCommandBuilder(constr, "pre_str_in_bill"); ins.InsertColumn("str_in_bill_id", str_in_bill_id); ins.InsertColumn("str_in_bill_no", txtNo.Text); ins.InsertColumn("operator_id", "0000"); ins.InsertColumn("operator_date", txtDate.Text); ins.InsertColumn("store_id", ddlMaterialStock.SelectedItem.Value.Trim()); ins.InsertColumn("str_in_type_id", rbtType.SelectedItem.Value); ins.InsertColumn("come_from", rbtType.SelectedIndex == 0 ? rbtType.SelectedItem.Text.Trim() : gvList.SelectedRow.Cells[1].Text.Trim()); ins.InsertColumn("is_state", "Y"); sql = ins.getInsertCommand(); No = txtNo.Text.Trim(); bill_id = str_in_bill_id; if (rbtType.SelectedIndex == 0) { Server.Transfer("StockIn_AddData.aspx"); } else if (rbtType.SelectedIndex == 1) { DId = gvList.SelectedRow.Cells[1].Text.Trim(); Server.Transfer("StockIn_AddDictateData.aspx"); } }
protected void btnAdd_Click(object sender, EventArgs e) { if (checkInput() != true) { return; } Id = CommadMethod.getNextId("Fix" + DateTime.Now.ToString("yyyyMMdd"), "").Trim(); string docType = System.IO.Path.GetExtension(FileUpload1.FileName).ToString().ToLower(); imgId = Id + docType; InsertCommandBuilder ins = new InsertCommandBuilder("Repair_records"); ins.InsertColumn("id", Id); ins.InsertColumn("eqp_no", tags.Text); ins.InsertColumn("rely_date", txtDate.Text); ins.InsertColumn("repair_time", Convert.ToDecimal(txtHours.Text)); ins.InsertColumn("repair_record", txtRecords.Text); ins.InsertColumn("type", ddlType.SelectedItem.Text); ins.InsertColumn("rely_dept", ddlDept.SelectedItem.Text); string person = string.Empty; for (int i = 0; i < cblPerson.Items.Count; i++) { if (cblPerson.Items[i].Selected == true) { person += cblPerson.Items[i].Text + ","; } } if (!string.IsNullOrEmpty(txtPerson.Text)) { person += txtPerson.Text; } else { person = person.Substring(0, person.Length - 1); } ins.InsertColumn("repairman", person); ins.InsertColumn("create_date", "getdate()"); ins.InsertColumn("doc_url", imgId); ins.getInsertCommand(); int count = ins.ExecuteNonQuery(); if (count != 0) { ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "<script>alert('添加成功')</script>", false); uploadImg(); } else { ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "<script>alert('添加失败')</script>", false); } }
private static void InsertData(string label, string goodsName, int Qty, int areaId, string userId) { InsertCommandBuilder ins = new InsertCommandBuilder("Material_control"); ins.InsertColumn("label", label); ins.InsertColumn("goods_name", goodsName); ins.InsertColumn("process_id", areaId); ins.InsertColumn("qty", Qty); ins.InsertColumn("operate_time", "getDate()"); ins.InsertColumn("operator", userId); ins.getInsertCommand(); ins.ExecuteNonQuery(); }
public int excutInsert(string Barcode, string goods_name, int qty, string pdate, string sn, string customerID) { InsertCommandBuilder insert = new InsertCommandBuilder("BarCodeRecords"); insert.InsertColumn("Barcode", Barcode); insert.InsertColumn("goods_name", goods_name); insert.InsertColumn("qty", qty); insert.InsertColumn("pdate", pdate); insert.InsertColumn("sn", sn); insert.InsertColumn("customerId", customerID); insert.InsertColumn("create_date", "getdate()"); insert.getInsertCommand(); return(insert.ExecuteNonQuery()); }
protected void Button1_Click(object sender, EventArgs e) { string userID = TextBox1.Text; string department = TextBox2.Text; string name = TextBox3.Text; InsertCommandBuilder icd = new InsertCommandBuilder(); string sqlinsert = @"insert into shatter_Parts_Password (userid,department,name) values('" + userID + "','" + department + "','" + name + "')"; Debug.WriteLine(sqlinsert); icd.ExecuteNonQuery(sqlinsert); Response.Redirect("UserManage.aspx"); }
public void Build_Generates_Command_With_Output() { // Arrange var input = new InsertCommandBuilder().Into("MyTable") .AddFieldNames(new[] { "Field1", "Field2", "Field3" }.AsEnumerable()) .AddFieldValues(new[] { "\"Value1\"", "\"Value2\"", "\"Value3\"" }.AsEnumerable()) .AddOutputFields(new[] { "INSERTED.Field1", "INSERTED.Field2", "INSERTED.Field3" }.AsEnumerable()); // Act var actual = input.Build(); // Assert actual.Operation.Should().Be(DatabaseOperation.Insert); actual.CommandText.Should().Be("INSERT INTO MyTable(Field1, Field2, Field3) OUTPUT INSERTED.Field1, INSERTED.Field2, INSERTED.Field3 VALUES(\"Value1\", \"Value2\", \"Value3\")"); }
/// <summary> /// Creates the insert command. /// </summary> /// <returns></returns> private void CreateInsertCommand() { var builder = new InsertCommandBuilder(_connection.Factory); builder.TableName = TableName; foreach (PropertyInfo field in _fields) { builder.AddParameter(field.Name, field.PropertyType); } _insertCommand = builder.Build(); //insertCommand.Prepare(); }
public void Can_Clear_Builder() { // Arrange var input = new InsertCommandBuilder().Into("MyTable") .AddFieldNames("Field1", "Field2", "Field3") .AddFieldValues("@Field1", "@Field2", "@Field3") .AppendParameters(new { Field1 = "Value1", Field2 = "Value2", Field3 = "Value3" }); // Act input.Clear(); // Assert input.Invoking(x => x.Build()) .Should().Throw <InvalidOperationException>() .WithMessage("table name is missing"); }
public void AddParameter() { InsertCommandBuilder builder = new InsertCommandBuilder(TestSettings.CreateConnection()); builder.TableName = "Table1"; builder.AddParameter("p1", DbType.Date); builder.AddParameter("p2", typeof(DateTime)); builder.AddParameter("p3", 1); builder.AddParameter("p4", "par4", true); IDbCommand command = builder.Build(); Assert.AreEqual(command.CommandType, CommandType.Text); Assert.IsNotNull(command.Parameters["@p1"]); Assert.IsNotNull(command.Parameters["@p2"]); Assert.IsNotNull(command.Parameters["@p3"]); Assert.IsNotNull(command.Parameters["@par4"]); }
protected void btnReConAll_Click(object sender, EventArgs e) { List <string> sqlList = new List <string>(); for (int i = 0; i < gvData.Rows.Count; i++) { string sql = "update tmp_pk_bill set status ='N' where bill_id ='" + gvData.Rows[i].Cells[0].Text.Trim() + "' "; sqlList.Add(sql); } int c**t = new InsertCommandBuilder().ExcutTransaction(sqlList); if (c**t != 0) { Response.Write("<script>alert('" + Resources.Resource.alterOk + "!')</script>"); btnSearch_Click(sender, e); } }
protected void btnDelete_Click(object sender, EventArgs e) { if (gvData.SelectedIndex == -1) { Response.Write("<script>alert('" + Resources.Resource.alterwxz + "!')</script>"); return; } string sql = "delete from pd where bill_id='" + ViewState["billId"].ToString() + "'"; string detailsql = "delete from pd_detail where bill_id='" + ViewState["billId"].ToString() + "'"; int c**t = new InsertCommandBuilder().ExecuteNonQuery(sql); c**t += new InsertCommandBuilder().ExecuteNonQuery(detailsql); if (c**t != 0) { Response.Write("<script>alert('" + Resources.Resource.alterOk + "!')</script>"); btnSearch_Click(sender, e); } }
private void btnOK_Click(object sender, EventArgs e) { if (!UIValidtion.Create() .Null(txtName, "名称") .Len(2, 16) .My(p => { if (Symbol.TypeExtensions.Convert <int>(Program.DataContext.ExecuteScalar("select top 1 [Id] from [Funds] where [UserId]=@p1 and [Name]=@p2", Program.CurrentUser.Id, p.LastValue), 0) > 0) { p.Return(false) .Msg("此资金库已经存在!") .LastControl.Focus(); } }) .Null(txtMoney, "余额") .NumDec() .Null(txtOrder, "顺序") .NumDec() .Null(txtBankName, "银行", chkIsBank.Checked) .Len(2, 16) .Null(txtCardNumber, "卡号", chkIsBank.Checked) .Len(2, 32) .Result) { return; } _model = new Funds() { UserId = Program.CurrentUser.Id, Name = txtName.Text, Money = Symbol.TypeExtensions.Convert <decimal>(txtMoney.Text, 0M), Order = Symbol.TypeExtensions.Convert <double>(txtOrder.Text, 0D), IsBank = chkIsBank.Checked, BankName = txtBankName.Text, CardNumber = txtCardNumber.Text, }; using (InsertCommandBuilder builder = new InsertCommandBuilder("Funds")) { builder.Fields.SetValues(_model); builder.Fields.Remove("Id"); _model.Id = Symbol.TypeExtensions.Convert <int>(Program.DataContext.ExecuteScalar(builder.CommandText, builder.Values), 0); } DialogResult = System.Windows.Forms.DialogResult.OK; }
protected void btnCannel_Click(object sender, EventArgs e) { string sql1 = "delete from pre_str_out_bill where str_out_bill_id='" + ViewState["Id"].ToString() + "'"; string sql2 = "delete from pre_str_out_bill_detail where str_out_bill_id='" + ViewState["Id"].ToString() + "'"; List <string> sList = new List <string>(); sList.Add(sql1); sList.Add(sql2); int count = new InsertCommandBuilder(constr, "").ExcutTransaction(sList); if (count != 0) { Response.Redirect("StockIn_SaveOk.aspx", false); } else { Response.Write("<script>alert('操作失败')</script>"); } }