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