public int insCM(CuraHdr tbl)
{
try
{
DynamicParameters param;
var rst = 0;
string sqlcmd;
string refnomer = "";
string tglA = tbl.tgl.Substring(0, 2);
string blnA = tbl.tgl.Substring(3, 2);
string thnA = tbl.tgl.Substring(6, 4);
string thnB = tbl.tgl.Substring(8, 2);
string newTgl = thnA + "/" + blnA + "/" + tglA;
int iThnB = Convert.ToInt16(thnB);
int iBlnB = Convert.ToInt16(blnA);
refnomer = thnB + blnA + ValCM(iThnB, iBlnB, "idHdr", "tcmheader");
param = new DynamicParameters();
param.Add("@ref", refnomer);
param.Add("@tgl", newTgl);
param.Add("@usr", tbl.user);
param.Add("@asset", tbl.idtAsset);
sqlcmd = "INSERT INTO tCMHeader(CM#, TglCM, UserCM, idtAsset)" +
" VALUES(@ref, @tgl, @usr, @asset) ";
rst = _db.Execute(sqlcmd, param);
return(rst);
}
catch (Exception)
{
throw;
}
}
public int updateCM(CuraHdr tbl)
{
try
{
string sqlcmd;
DynamicParameters param;
var rst = 0;
param = new DynamicParameters();
param.Add("@usr", tbl.user);
param.Add("@idHdr", tbl.idHdr);
sqlcmd = "update tCMHeader set UserCM = @usr where idHdr=@idHdr";
rst = _db.Execute(sqlcmd, param);
return(rst);
}
catch (Exception)
{
throw;
}
}
public int updateCM(CuraHdr tbl)
{
WipRepository FixedAsset = new WipRepository();
return(FixedAsset.updateCM(tbl));
}
public int insCM(CuraHdr tbl)
{
WipRepository FixedAsset = new WipRepository();
return(FixedAsset.insCM(tbl));
}
