public void Add(QMCardOP model) { string sql = "insert into QM_CardOperation(cardNo, OpSeq, iQuantity, dRepDate) values(@cardNo, @OpSeq, @iQuantity, @dRepDate)"; using (var conn = DbHelperSQL.GetConnection()) { conn.Execute(sql, model); } }
private void BtnOk_Click(object sender, EventArgs e) { var cardD = cardM.curOperation; if (string.IsNullOrEmpty(txt_qty.Text) || Convert.ToDecimal(txt_qty.Text) <= 0) { throw new Exception("报检数量不能小于等0"); } QMCardOP model = new QMCardOP() { CardNo = cardD.CardNo, OpSeq = cardD.OpSeq, iQuantity = Convert.ToDecimal(txt_qty.Text) }; new QmCardOPDAL().Add(model); this.DialogResult = DialogResult.OK; }