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) { } }