public int delMachineTypeByNames(string machineName)
{
string sql = @"DELETE FROM machineTypes WHERE machineName ='" + machineName + "'";
int delRows = IEBOM_SqlHelper.ExecuteNonQuery(sql);
return(delRows);
}
public int delStandardModulusByCurveNameID(int CurveNameID)
{
string sql = @"UPDATE dbo.StandardModulus SET isDel = 1 WHERE CureNamesID =@CurveNameID";
SqlParameter[] ps =
{
new SqlParameter("CurveNameID", CurveNameID)
};
int result = IEBOM_SqlHelper.ExecuteNonQuery(sql, ps);
return(result);
}
public List <string> saveMachineTypes(DataTable machineDT)
{
List <string> results = new List <string>();
DataTable newDt = new DataTable();
// newDt.Columns.Add(new DataColumn("machineID", typeof(int))); //
newDt.Columns.Add(new DataColumn("machineClass", typeof(string))); //机器类别
newDt.Columns.Add(new DataColumn("MachineName", typeof(string))); //机器类别名称
newDt.Columns.Add(new DataColumn("machineNameEN", typeof(string))); //机器类别名称英文
newDt.Columns.Add(new DataColumn("machinesMark", typeof(string))); //机器备注
newDt.Columns.Add(new DataColumn("isMachinesStatus", typeof(int))); //机器类别状态
newDt.Columns.Add(new DataColumn("CreateDate", typeof(DateTime))); // 创建时间
newDt.Columns.Add(new DataColumn("Creator", typeof(string))); // 创建者
newDt.Columns.Add(new DataColumn("modify", typeof(DateTime))); // 最后修改时间
newDt.Columns.Add(new DataColumn("modifor", typeof(string))); // 最后修改者
for (int i = 0; i < machineDT.Rows.Count; i++)
{
DataRow dr = newDt.NewRow();
dr["machineClass"] = machineDT.Rows[i]["machineClass"];
dr["MachineName"] = machineDT.Rows[i]["MachineName"];
dr["machineNameEN"] = machineDT.Rows[i]["machineNameEN"];
dr["machinesMark"] = machineDT.Rows[i]["machinesMark"];
dr["isMachinesStatus"] = machineDT.Rows[i]["ismachinesStatus"];
dr["CreateDate"] = machineDT.Rows[i]["CreateDate"];
dr["Creator"] = machineDT.Rows[i]["Creator"];
dr["modify"] = machineDT.Rows[i]["modify"];
dr["modifor"] = machineDT.Rows[i]["modifor"];
newDt.Rows.Add(dr);
}
// 清空临时表
string empTmp = @"DELETE FROM machineTypes_tmp";
IEBOM_SqlHelper.ExecuteNonQuery(empTmp);
//写入临时表
string result = IEBOM_SqlHelper.SqlBulkCopyMachineTypes(newDt);
int newData = 0;
// 写入成功 调用存储过程 失败返回原因
if (result == "0")
{
string callStudent = @"exec get_NewMachines;";
newData = IEBOM_SqlHelper.ExecuteNonQuery(callStudent);
// return newData.ToString();
results.Add("0");
results.Add(newData.ToString());
}
else
{
results.Add(result);
results.Add("0");
}
return(results);
}