public int Update_MeasApplianceMan(MeasApplianceMan MAM_Equipinfo)
{//编辑计量器具信息
SqlParameter[] parm = new SqlParameter[13];
parm[0] = new SqlParameter("@MAM_EquipID", SqlDbType.UniqueIdentifier);
parm[0].Value = MAM_Equipinfo.MAM_EquipID;
parm[1] = new SqlParameter("@MAM_EquipName", SqlDbType.VarChar, 50);
parm[1].Value = MAM_Equipinfo.MAM_EquipName;
parm[2] = new SqlParameter("@MAM_ManuCode", SqlDbType.VarChar, 50);
parm[2].Value = MAM_Equipinfo.MAM_ManuCode;
parm[3] = new SqlParameter("@MAM_Location", SqlDbType.VarChar, 40);
parm[3].Value = MAM_Equipinfo.MAM_Location;
parm[4] = new SqlParameter("@MAM_ToDate", SqlDbType.Date);
parm[4].Value = MAM_Equipinfo.MAM_ToDate;
parm[5] = new SqlParameter("@MAM_OAccuracy", SqlDbType.VarChar, 100);
parm[5].Value = MAM_Equipinfo.MAM_OAccuracy;
parm[6] = new SqlParameter("@MAM_IAccuracy", SqlDbType.VarChar, 100);
parm[6].Value = MAM_Equipinfo.MAM_IAccuracy;
parm[7] = new SqlParameter("@MAM_Period", SqlDbType.SmallInt);
parm[7].Value = MAM_Equipinfo.MAM_Period;
parm[8] = new SqlParameter("@MAM_ToBeTestDate", SqlDbType.Date);
parm[8].Value = MAM_Equipinfo.MAM_ToBeTestDate;
parm[9] = new SqlParameter("@MAM_RemindDays", SqlDbType.SmallInt);
parm[9].Value = MAM_Equipinfo.MAM_RemindDays;
parm[10] = new SqlParameter("@MAM_EquipType", SqlDbType.VarChar, 50);
parm[10].Value = MAM_Equipinfo.MAM_EquipType;
parm[11] = new SqlParameter("@MAM_ManuName", SqlDbType.VarChar, 100);
parm[11].Value = MAM_Equipinfo.MAM_ManuName;
parm[12] = new SqlParameter("@MAM_Isunused", SqlDbType.Char, 2);
parm[12].Value = MAM_Equipinfo.MAM_Isunused;
return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_U_MeasApplianceMan", parm));
}
public int Update_MeasApplianceMan(MeasApplianceMan MA)
{
return(iMA.Update_MeasApplianceMan(MA));
}
public int Insert_MeasApplianceMan(MeasApplianceMan MA)
{
return(iMA.Insert_MeasApplianceMan(MA));
}
