public int Delete(PSS_PurchaseCompany obj)
{
using (Conn)
{
string query = @"DELETE FROM PSS_PurchaseCompany WHERE CompanyID = @CompanyID";
return(Conn.Execute(query, obj));
}
}
public int Insert(PSS_PurchaseCompany obj)
{
using (Conn)
{
string query = @"INSERT INTO PSS_PurchaseCompany
VALUES(@CompanyName,@PinyinCode,@Bank,@BankNo,@Contact,@Tel,@Address)";
return(Conn.Execute(query, obj));
}
}
public int Update(PSS_PurchaseCompany obj)
{
using (Conn)
{
string query = @"UPDATE PSS_PurchaseCompany
SET CompanyName=@CompanyName,PinyinCode=@PinyinCode,
Bank=@Bank,BankNo=@BankNo,Contact=@Contact,Tel=@Tel,Address=@Address
WHERE CompanyID =@CompanyID";
return(Conn.Execute(query, obj));
}
}
public ActionResult AcceptClick(PSS_PurchaseCompany obj)
{
int isOk = default(int);
//判断ID的值，ID为0表示ID为默认值，插入记录。非0的ID代表数据库已存在记录，则修改
if (obj.CompanyID != 0)
{
isOk = ipss_purchasecompanybll.Update(obj);
}
else
{
isOk = ipss_purchasecompanybll.Insert(obj);
}
return(Content(isOk.ToString()));
}
public int Delete(PSS_PurchaseCompany obj)
{
return(dal.Delete(obj));
}
public int Insert(PSS_PurchaseCompany obj)
{
return(dal.Insert(obj));
}
public int Update(PSS_PurchaseCompany obj)
{
return(dal.Update(obj));
}
