public static bool ModifyCompanyDepartMent(CompanyDepartMent model)
{
string sql = string.Format(@"update {0} set [Name]=@Name,[PId]=@PId,[CompanyId]=@CompanyId,[CompanyName]=@CompanyName,[ModifyDate]=getdate()
where Id=@Id", TableName);
return(DBAccess.ExecuteSqlWithEntity(sql, model));
}
public static bool ModifyAccount(Account model)
{
string sql = string.Format(@"update {0} set [Mobile]=@Mobile,[Email]=@Email,[AccountName]=@AccountName
where Id=@Id", TableName);
return(DBAccess.ExecuteSqlWithEntity(sql, model));
}
public static bool AddCompanyDepartMent(CompanyDepartMent model)
{
string sql = string.Format("insert into {0}(Name,PId,CompanyId,[CompanyName],CreateDate,IsDeleted) values(@Name,@PId,@CompanyId,@CompanyName,getdate(),0)", TableName);
return(DBAccess.ExecuteSqlWithEntity(sql, model));
}
