public int UpdateCMDetail(CuraDtl tbl)
{
try
{
DynamicParameters param;
var rstHdr = 0;
var rstDtl = 0;
var rst = 0;
string sqlcmd, sqlcmdtl;
param = new DynamicParameters();
param.Add("@idDtl", tbl.idDtl);
param.Add("@idHdr", tbl.idHdr);
param.Add("@follow", tbl.FollowUp);
param.Add("@cost", tbl.Cost);
sqlcmd = "update tCMDetail set FollowUp=@follow, Cost=@cost where idDtl=@idDtl ";
rstHdr = _db.Execute(sqlcmd, param);
sqlcmdtl = "update tCMHeader set TglFollowUp=getdate() where idHdr=@idHdr ";
rstDtl = _db.Execute(sqlcmdtl, param);
rst = rstHdr * rstDtl;
return(rst);
}
catch (Exception)
{
throw;
}
}
public int InsCMDetail(CuraDtl tbl)
{
try
{
DynamicParameters param;
var rst = 0;
string sqlcmd;
param = new DynamicParameters();
param.Add("@idHdr", tbl.idHdr);
param.Add("@problem", tbl.Problem);
sqlcmd = "INSERT INTO tCMDetail(idHdr, Problem)" +
" VALUES(@idHdr, @problem) ";
rst = _db.Execute(sqlcmd, param);
return(rst);
}
catch (Exception)
{
throw;
}
}
public int UpdateCMDetail(CuraDtl tbl)
{
WipRepository FixedAsset = new WipRepository();
return(FixedAsset.UpdateCMDetail(tbl));
}
