public bool UpdateWorkplan(Workplan element)
{
string sql = "update TF_Workplan set 销售=" + element.销售.ID + ", 日期='" + element.日期 + "', 带人数=" + element.带人数 + ", 号码数=" + element.号码数 + ", 成单数=" + element.成单数 + ", 回访数=" + element.回访数 + ", 备注='" + element.备注 + "' where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateFinanceDetail(FinanceDetail element)
{
string sql = "update TF_FinanceDetail set 项目='" + element.项目 + "', 金额=" + element.金额 + ", 是否进账=" + (element.是否进账 ? "1" : "0") + ", 责任人=" + element.责任人.ID + ", 备注='" + element.备注 + "', Flag=" + element.Flag + ", 提交时间=getdate() where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateTaskInfo(TaskInfo element)
{
string sql = "update TaskInfo set EntityId=" + element.EntityId + ", FlowID=" + element.Flow.ID + ", Sponsor='" + element.Sponsor + "', Remark='" + element.Remark + "' where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateFollowup(Followup element)
{
string sql = "update TF_Followup set MemberID=" + element.Member.ID + ", 跟进方式=" + element.回访方式.ID + ", 跟进结果=" + element.跟进结果.ID + ", 跟进时间='" + element.跟进时间 + "', 备注='" + element.备注 + "', 跟进人=" + element.跟进人.ID + " where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateProperty(Property element)
{
string sql = "update TF_Property set 名称='" + element.称 + "', 单位='" + element.单位 + "', 用途='" + element.用途 + "', 价格=" + element.价格 + ", 备注='" + element.备注 + "' where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateMember(Member element)
{
string sql = "update TF_Member set 卡种=" + element.卡种.ID + ", 姓名='" + element.姓名 + "', 性别=" + (int)element.性别 + ", 开卡日='" + element.开卡日.ToString("yyyy-MM-dd") + "', 到期日='" + element.到期日.ToString("yyyy-MM-dd") + "', 卡号='" + element.卡号 + "', 生日='" + element.生日.ToString("yyyy-MM-dd") + "', 电话='" + element.电话 + "', 住址='" + element.住址 + "', 备注='" + element.备注 + "' where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateFinance(Finance element)
{
string sql = "update TF_Finance set 项目='" + element.项目 + "', 金额=" + element.金额 + ", 是否进账=" + (element.是否进账 ? "1" : "0") + ", 余款=" + element.余款 + ", 日期='" + element.日期 + "', 经手人='" + element.经手人 + "', 接收人='" + element.接收人 + "', Detail='" + element.Detail + "' where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateFlowTemplate(FlowTemplate element)
{
string sql = "update FlowTemplate set Name='" + element.Name + "', Stages='" + element.StageIds + "' where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateUserGroup(UserGroup ug)
{
string sql = "update TF_UserGroup set Name='" + ug.Name + "', Remark='" + ug.Remark + "' where ID=" + ug.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateProduct(Product element)
{
string sql = "update TF_Product set 品名='" + element.品名 + "', 种类=" + element.种类.ID + ", 单位='" + element.单位 + "', 进价=" + element.进价 + ", 售价=" + element.售价 + ", 厂家='" + element.厂家 + "', 姓名='" + element.姓名 + "', 电话='" + element.电话 + "', 地址='" + element.地址 + "', 备注='" + element.备注 + "' where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateFlow(Flow element)
{
string sql = "update Flow set Name='" + element.Name + "', TemplateID=" + element.Template.ID + ", CurrentIndex=" + element.CurrentIndex + ", Stages='" + element.StageIds + "', Remark='" + element.Remark + "' where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateAlert(Alert element)
{
string sql = "update TF_Alert set 提醒项目='" + element.提醒项目 + "', 提醒时间='" + element.提醒时间 + "', 提醒方式=" + (int)element.提醒方式 + ", 提醒对象='" + element.提醒对象 + "', Flag=" + element.Flag + ", 备注='" + element.备注 + "' where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateDairy(Dairy element)
{
string sql = "update TF_Dairy set Pos机会籍=" + element.Pos机会籍 + ", Pos机私教=" + element.Pos机私教 + ", 现金会籍=" + element.现金会籍 + ", 现金私教=" + element.现金私教 + ", 微信会籍=" + element.微信会籍 + ", 微信私教=" + element.微信私教 + ", 现金存水=" + element.现金存水 + ", 微信存水=" + element.微信存水 + ", 水吧余=" + element.水吧余 + ", 总金额=" + element.总金额 + ", 备注='" + element.备注 + "', 经手人=" + element.经手人.ID + ",日期='" + element.日期 + "' where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateProductType(ProductType element)
{
string sql = "update TF_ProductType set 类型='" + element.类型 + "', Flag=" + (element.Flag ? "1" : "0") + ", 备注='" + element.备注 + "' where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateWorklog(Worklog element)
{
string sql = "update TF_Worklog set 销售=" + element.销售.ID + ", 日期='" + element.日期 + "', 客户='" + element.客户 + "', 电话='" + element.电话 + "', 是否自访=" + (element.是否自访 ? "1" : "0") + ", 是否老会员=" + (element.是否老会员 ? "1" : "0") + ", 是否电话拜访=" + (element.是否电话拜访 ? "1" : "0") + ", 性别=" + (int)element.性别 + ", 意向='" + element.意向 + "', 住址='" + element.住址 + "', 备注='" + element.备注 + "' where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateRole(Role role)
{
string sql = "update TF_Role set Name='" + role.Name + "', Permissions='" + Common.GetPermissionsStr(role.Permissions) + "', Flag=" + (role.Flag ? "1" : "0") + ", Remark='" + role.Remark + "' where ID=" + role.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateFollowupType(FollowupType element)
{
string sql = "update TF_FollowupType set 方式='" + element.方式 + "', Flag=" + (element.Flag ? "1" : "0") + ", 备注='" + element.备注 + "' where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateRenew(Renew element)
{
string sql = "update TF_Renew set MemberID=" + element.Member.ID + ", 卡种=" + element.卡种.ID + ", 卡号='" + element.卡号 + "', 续卡时间='" + element.续卡时间 + "', 备注='" + element.备注 + "', 经手人=" + element.经手人.ID + " where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateStaffCondition(StaffCondition element)
{
string sql = "update TF_StaffCondition set 状态='" + element.状态 + "', 是否在职=" + (element.是否在职 ? "1" : "0") + ", 备注='" + element.备注 + "' where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateCardType(CardType element)
{
string sql = "update TF_CardType set 卡种='" + element.卡种 + "', 是否电子芯片=" + (element.是否电子芯片 ? "1" : "0") + ", 备注='" + element.备注 + "' where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdatePermission(Permission perm)
{
string sql = "update TF_Permission set Name='" + perm.Name + "',TheModule=" + perm.TheModule.ID + ", TheAction=" + perm.TheAction.ID + ", Remark='" + perm.Remark + "' where ID=" + perm.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateModule(Module module)
{
string sql = "update TF_Module set Name='" + module.Name + "', FormName='" + module.FormName + "', ControlName='" + module.ControlName + "', Remark='" + module.Remark + "' where ID=" + module.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateUser(User user)
{
string sql = "update TF_User set Username='******',Password='******', Depart='" + Common.GetDepartmentsStr(user.Departments) + "', Flag=" + user.Flag + ", Roles='" + Common.GetRolesStr(user.Roles) + "', Usergroup='" + Common.GetUserGroupsStr(user.Usergroups) + "', Remark='" + user.Remark + "' where ID=" + user.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateTaskStageTemplate(TaskStageTemplate element)
{
string sql = "update TaskStageTemplate set Name='" + element.Name + "', Executors='" + element.Executors + "', Approvers='" + element.Approvers + "' where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateAttachment(Attachment attach)
{
string sql = "update TF_Attachment set AttachmentFilename='" + attach.AttachmentFilename + "', Size=" + attach.Size + ", Uploader='" + attach.Uploader.ID + "' where ID=" + attach.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateFollowupResult(FollowupResult element)
{
string sql = "update TF_FollowupResult set 结果='" + element.结果 + "', Flag=" + (element.Flag ? "1" : "0") + ", 备注='" + element.备注 + "' where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateAction(Action action)
{
string sql = "update TF_Action set Name='" + action.Name + "', FormName='" + action.FormName + "', ControlName='" + action.ControlName + "', Remark='" + action.Remark + "' where ID=" + action.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateStaff(Staff element)
{
string sql = "update TF_Staff set Depart=" + element.Depart.ID + ", Condition=" + element.Condition.ID + ", 姓名='" + element.姓名 + "', 性别=" + (int)element.性别 + ", 生日='" + element.生日 + "', 电话='" + element.电话 + "', 宿舍='" + element.宿舍 + "', 钥匙数=" + element.钥匙数 + ", 工衣数=" + element.工衣数 + ", 工牌数=" + element.工牌数 + ", 是否全部回收=" + (element.是否全部回收 ? "1" : "0") + ", 备注='" + element.备注 + "' where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdatePersonalTrain(PersonalTrain element)
{
string sql = "update TF_PersonalTrain set MemberID=" + element.Member.ID + ", 私教项目='" + element.私教项目 + "', 次数=" + element.次数 + ", 开始日期='" + element.开始日期 + "', 结束日期='" + element.结束日期 + "', 教练=" + element.教练.ID + ", 备注='" + element.备注 + "' where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}
public bool UpdateMemberMoney(MemberMoney element)
{
string sql = "update TF_MemberMoney set 会员姓名='" + element.会员姓名 + "', 会员电话='" + element.会员电话 + "', 账户余额=" + element.账户余额 + ", 备注='" + element.备注 + "' where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
return(r > 0);
}