// 出厂编号修改
public int UpdateCcbh(UpdateCcbhDto input) //int id, string ccbh)
{
CZRZDto czrz = new CZRZDto();
czrz.CZNR = "修改 " + input.ID + " 出厂编号：" + input.OCcbh + "->" + input.Ccbh;
czrz.BZSM = input.BZSM;
_czrzAppServices.AddtoCZRZ(czrz);
string strSQL = "update YQSF_SJMX set ccbh = '" + input.Ccbh + "' where id = " + input.ID;
return(_sjmxDapperRepository.Execute(strSQL));
}
public void AddtoCZRZ(CZRZDto czrz)
{
long jdyid = (long)AbpSession.UserId;
var param = new
{
userid = jdyid,
cznr = czrz.CZNR,
bzsm = czrz.BZSM
};
string strSQL = @"insert into SYS_CZRZ(userid,cznr,bzsm) values(@userid,@cznr,@bzsm)";
int ret = _czrzDapperRepository.Execute(strSQL, param);
}
// public static List<int> GetMonthCount(int year) -> StatsAppServices.cs
//重新检定
public int ResetJdzt(string id)
{
string strSQL = "update YQSF_SJD set jdzt='在检' where ID = (select sjdid from YQSF_SJMX as b where b.id = " + id + ")";
_sjmxDapperRepository.Execute(strSQL);
strSQL = "Update YQSF_SJMX set jdzt='登记' where id=" + id;
_sjmxDapperRepository.Execute(strSQL);
strSQL = "Update SJCL_CHYQ set JDRQ=null,jwrq=null,JDYID=null,hyy=null,HYYID=null,PZRID=null,HYYJ='',PZYJ='',PZR='',jdzt=100 where id=" + id;
_sjmxDapperRepository.Execute(strSQL);
CZRZDto czrz = new CZRZDto();
czrz.CZNR = "重新检定：" + id;
_czrzAppServices.AddtoCZRZ(czrz);
return(1);
}