public int AddSubSystem(SysSubEntity model)
{
string sql = "INSERT INTO SysSub(SubSystemId,ProductId,SystemName,SystemEName,Remark) VALUES(@SubSystemId,@ProductId,@SystemName,@SystemEName,@Remark)";
using (var conn = new SqlConnection(ConnectionStr.FxDb))
{
conn.Open();
return(conn.Execute(sql, model));
}
}
public int UpdateSubSystem(SysSubEntity model)
{
string sql = "UPDATE SysSub SET ProductId=@ProductId,SystemName=@SystemName,SystemEName=@SystemEName,Remark=@Remark WHERE SubSystemId=@SubSystemId";
using (var conn = new SqlConnection(ConnectionStr.FxDb))
{
conn.Open();
return(conn.Execute(sql, model));
}
}
public int AddSubSystem(SysSubEntity model)
{
return(subSystemDal.AddSubSystem(model));
}
public int UpdateSubSystem(SysSubEntity model)
{
return(subSystemDal.UpdateSubSystem(model));
}
