partial void DeletebranchInfo(branchInfo instance);
partial void UpdatebranchInfo(branchInfo instance);
/// <summary>
/// 添加部门的方法
/// </summary>
/// <param name="branchInfo">部门实体</param>
/// <returns>受影响的行数</returns>
public int AddBranch(branchInfo branchInfo)
{
string sql = @"insert into branchInfo values('" + branchInfo.branchName + "'," + branchInfo.pBranchId + ",'" + branchInfo.branchPrincipal + "','" + branchInfo.branchPhone + "','" + branchInfo.branchFax + "','" + branchInfo.branchRemark + "','"+branchInfo.temp1+"','','','','','','','','','')";
return SqlServerHelper.ExecuteSql(sql);
}
partial void InsertbranchInfo(branchInfo instance);
/// <summary>
/// 修改部门信息
/// </summary>
/// <param name="branchInfo">部门信息实体</param>
/// <returns>受影响的行数</returns>
public int UpdateBranch(branchInfo branchInfo)
{
string sql = @"update branchInfo set branchName='" + branchInfo.branchName
+ "',pBranchid=" + branchInfo.pBranchId
+ ",branchPrincipal='"+ branchInfo.branchPrincipal
+ "',branchPhone='" + branchInfo.branchPhone
+ "',branchFax='" + branchInfo.branchFax
+ "',branchRemark='" + branchInfo.branchRemark
+"',temp1='" + branchInfo.temp1
+"' where branchID=" + branchInfo.branchID + "";
return SqlServerHelper.ExecuteSql(sql);
}
