private void tbbah_Validating(object sender, CancelEventArgs e)
{
char bi;
DataCheck dc = new DataCheck();
if (this.tbbah.Text.Trim() == "")
{
this.dxErrorProvider.SetError(tbbah, "【备案号(VIN)】不能为空！");
}
else if (!dc.CheckCLSBDH(this.tbbah.Text.Trim().ToUpper(), out bi))
{
if (bi == '-')
{
this.dxErrorProvider.SetError(tbbah, "请核对【备案号(VIN)】为17位字母或者数字！");
}
else
{
this.dxErrorProvider.SetError(tbbah, "【备案号(VIN)】校验失败！第9位应为:'" + bi + "'");
}
}
else
{
this.dxErrorProvider.SetError(tbbah, "");
}
}
private void btnCopy_Click(object sender, EventArgs e)
{
string newVin = tbCopyVin.Text.Trim().ToUpper();
if (newVin == "")
{
MessageBox.Show("请输入备案号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (IsVinExit(newVin))
{
MessageBox.Show(string.Format("VIN:{0}数据已经录入", newVin), "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
char bi;
DataCheck dc = new DataCheck();
if (!dc.CheckCLSBDH(this.tbCopyVin.Text.Trim().ToUpper(), out bi))
{
if (bi == '-')
{
MessageBox.Show("请核对【备案号(VIN)】为17位字母或者数字!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
MessageBox.Show("【备案号(VIN)】校验失败！第9位应为:'" + bi + "'", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
return;
}
OleDbConnection conn = new OleDbConnection(AccessHelper.conn);
conn.Open();
OleDbTransaction ts = conn.BeginTransaction();
try
{
string jbxxsql = @"INSERT INTO FC_CLJBXX
(V_ID,VIN,HGSPBM,USER_ID,QCSCQY,JKQCZJXS,CLXH,CLZL,RLLX,ZCZBZL,
ZGCS,LTGG,ZJ,CLZZRQ,UPLOADDEADLINE,TYMC,YYC,ZWPS,ZDSJZZL,EDZK,LJ,
QDXS,STATUS,JYJGMC,JYBGBH,QTXX,CREATETIME,UPDATETIME)
SELECT
NULL AS V_ID,@VIN AS VIN,t.HGSPBM,t.USER_ID,t.QCSCQY,t.JKQCZJXS,t.CLXH,t.CLZL,t.RLLX,t.ZCZBZL,
t.ZGCS,t.LTGG,t.ZJ,t.CLZZRQ,t.UPLOADDEADLINE,t.TYMC,t.YYC,t.ZWPS,t.ZDSJZZL,t.EDZK,t.LJ,
t.QDXS,'1' AS STATUS,t.JYJGMC,t.JYBGBH ,t.QTXX,@CREATETIME AS CREATETIME,@UPDATETIME AS UPDATETIME
FROM FC_CLJBXX t WHERE t.VIN=@TEMP_VIN";
OleDbParameter creTime = new OleDbParameter("@CREATETIME", DateTime.Now);
creTime.OleDbType = OleDbType.DBDate;
OleDbParameter upTime = new OleDbParameter("@UPDATETIME", DateTime.Now);
upTime.OleDbType = OleDbType.DBDate;
OleDbParameter[] param =
{
new OleDbParameter("@VIN", tbCopyVin.Text.Trim().ToUpper()),
creTime,
upTime,
new OleDbParameter("@TEMP_VIN", tempVin.ToUpper())
};
// 复制基本信息
int jbxxcount = AccessHelper.ExecuteNonQuery(ts, jbxxsql, param);
string entitysql = @"INSERT INTO RLLX_PARAM_ENTITY (PARAM_CODE,VIN,PARAM_VALUE,V_ID)
SELECT
PARAM_CODE,@VIN,PARAM_VALUE,NULL AS V_ID
FROM RLLX_PARAM_ENTITY WHERE VIN=@TEMP_VIN";
OleDbParameter[] eneityparam =
{
new OleDbParameter("@VIN", tbCopyVin.Text.Trim().ToUpper()),
new OleDbParameter("@TEMP_VIN", tempVin.ToUpper())
};
// 复制参数信息
int entitycount = AccessHelper.ExecuteNonQuery(ts, entitysql, eneityparam);
ts.Commit();
MessageBox.Show("复制成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
ts.Rollback();
MessageBox.Show("复制失败：" + ex.Message, "异常", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
conn.Close();
}
this.Close();
}
