public void yrGmDelete(bll_YearlyTarget bllcreate)
{
try
{
cmd = "EXEC Delete_yearlyGM '" + bllcreate.YRGMID + "'";
dataProvider.ExecuteCommand(cmd);
}
catch (Exception e)
{
}
}
public void yrRmInsert(bll_YearlyTarget bllcreate)
{
try
{
cmd = "EXEC Insert_yearlyRM '" + bllcreate.YEAR + "' ,'"
+ bllcreate.MANAGER + "' ,'"
+ bllcreate.RM + "' ,'"
+ bllcreate.TARGETCOPY + "' ,'"
+ bllcreate.AUDITUSER + "' ,'"
+ bllcreate.CREATEDATE + "' ";
dataProvider.ExecuteCommand(cmd);
}
catch (Exception e)
{
}
}
public void yrGmInsert(bll_YearlyTarget bllcreate)
{
try
{
cmd = "EXEC Insert_yearlyGM '" + bllcreate.YEAR + "' ,'"
+ bllcreate.GM + "' ,'"
+ bllcreate.TARGETCOPY + "' ,'"
+ bllcreate.PRVACHIEVEMENT + "' ,'"
+ bllcreate.CURNTACHIEVEMENT + "' ,'"
+ bllcreate.AUDITUSER + "' ,'"
+ bllcreate.CREATEDATE + "' ";
dataProvider.ExecuteCommand(cmd);
}
catch (Exception e)
{
}
}
public void yrManUpdate(bll_YearlyTarget bllcreate)
{
try
{
cmd = "EXEC Update_yearlyManager '"
+ bllcreate.YRMANAGERID + "','"
+ bllcreate.YEAR + "' ,'"
+ bllcreate.GM + "' ,'"
+ bllcreate.MANAGER + "' ,'"
+ bllcreate.TARGETCOPY + "' ,'"
+ bllcreate.AUDITUSER + "' ,'"
+ bllcreate.CREATEDATE + "' ";
dataProvider.ExecuteCommand(cmd);
}
catch (Exception e)
{
}
}
