/// <summary> /// 查询是否已核对 /// </summary> /// <param name="wonoStr">工单号</param> /// <returns></returns> private static bool IsChecked(string wonoStr) { var sql = $"SELECT checked FROM tf_sgdantwo WHERE shigongdanhao='{wonoStr}'"; var isChecked = SqlHelper.ExecuteScalar(SqlHelper.GetConnSting(), CommandType.Text, sql); return(isChecked != null && (bool)isChecked); }
/// <summary> /// 新增 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnInsert_Click(object sender, EventArgs e) { var orderId = DateTime.Now.ToString("yyMM").Substring(1, 3); var ddaa = orderId + "0001"; var aadd = orderId + "9999"; var sql = $"SELECT Max(twoid) FROM mf_sgdan WHERE twoid>={ddaa} AND twoid<={aadd}"; var scalar = SqlHelper.ExecuteScalar(SqlHelper.GetConnection(), CommandType.Text, sql); if (scalar.ToString() == "") { txtWONo.Text = ddaa; btnInsert.Enabled = false; btnSave.Enabled = true; txtOriWONo.Focus(); txtSn.Text = @"1"; } else { if (scalar.ToString() == aadd) { MessageBox.Show(@"手工工单已经达到9999份上限,编号要重新生成!", Resources.T提示); } else { var maxtid = (int)scalar; maxtid += 1; txtWONo.Text = maxtid.ToString(); btnInsert.Enabled = false; btnSave.Enabled = true; txtOriWONo.Focus(); txtSn.Text = @"1"; } } EnableCtrls(true); }