/// <summary>
/// 亮度测试更新
/// </summary>
/// <param name="piLD"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int updateProjectorInformation_MainTable_LDZ2Dal(ProjectorInformation_LD piLD, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
{
Value = piLD.FuselageCode
},
new SqlParameter("@IlluminationValue", SqlDbType.VarChar, 50)
{
Value = piLD.IlluminationValue
},
new SqlParameter("@WiredMAC", SqlDbType.VarChar, 50)
{
Value = piLD.WiredMAC
},
new SqlParameter("@wirelessMAC", SqlDbType.VarChar, 50)
{
Value = piLD.wirelessMAC
},
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 打光机更新
/// </summary>
/// <param name="pdg"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int updateProjectorInformation_MainTableDal(ProjectorInformation_DG pdg, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@OpticalCode", SqlDbType.VarChar, 80)
{
Value = pdg.OpticalCode
},
new SqlParameter("@PolishingMachineTime", SqlDbType.DateTime)
{
Value = pdg.PolishingMachineTime
},
new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
{
Value = pdg.FuselageCode
},
new SqlParameter("@MainBoardCode", SqlDbType.VarChar, 50)
{
Value = pdg.MainBoardCode
},
new SqlParameter("@MainBoardTime", SqlDbType.DateTime)
{
Value = pdg.MainBoardTime
},
new SqlParameter("@ZhiDan", SqlDbType.VarChar, 50)
{
Value = pdg.ZhiDan
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 老化后测试查找是否是第二次测试
/// </summary>
/// <param name="FuselageCode"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public ProjectorInformation_LHH selectProjectorInformation_MainTable_LHHDal(string FuselageCode, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
ProjectorInformation_LHH pif = new ProjectorInformation_LHH();
DateTime dt = new DateTime(1993, 5, 17);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
{
Value = FuselageCode
}
};
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text, pms))
{
if (reader.HasRows)
{
while (reader.Read())
{
pif.FuselageCode = reader.GetString(0);
pif.PostAgingTestTime = reader.IsDBNull(1) ? dt : reader.GetDateTime(1);
pif.PostAgingTestTime2 = reader.IsDBNull(2) ? null : reader.GetDateTime(2).ToString();
}
}
return(pif);
}
}
/// <summary>
/// 查询前缀表
/// </summary>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public List <ProjectorInformation_EncodingRules> selectProjectorInformation_EncodingRulesDal(string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
List <ProjectorInformation_EncodingRules> list = new List <ProjectorInformation_EncodingRules>();
try
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text))
{
if (reader.HasRows)
{
while (reader.Read())
{
list.Add(new ProjectorInformation_EncodingRules
{
TypeName = reader.GetString(0),
Prefix_BodyCode = reader.IsDBNull(1)?"":reader.GetString(1),
Prefix_OpticalCode = reader.IsDBNull(2)?"":reader.GetString(2),
Prefix_MotherboardEncoding = reader.IsDBNull(3)?"":reader.GetString(3)
});
}
}
return(list);
}
}
catch
{
throw;
}
}
/// <summary>
/// 插入前缀表
/// </summary>
/// <param name="list"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int insertProjectorInformation_EncodingRulesDal(List <ProjectorInformation_EncodingRules> list, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@TypeName", SqlDbType.VarChar, 50)
{
Value = list[0].TypeName
},
new SqlParameter("@Prefix_BodyCode", SqlDbType.VarChar, 50)
{
Value = list[0].Prefix_BodyCode
},
new SqlParameter("@Prefix_OpticalCode", SqlDbType.VarChar, 50)
{
Value = list[0].Prefix_OpticalCode
},
new SqlParameter("@Prefix_MotherboardEncoding", SqlDbType.VarChar, 50)
{
Value = list[0].Prefix_MotherboardEncoding
},
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 前缀订单更新表
/// </summary>
/// <param name="projeSelect"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int updateProjectorInformation_SelectPrefixDal(ProjectorInformation_SelectPrefix projeSelect, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@TypeName", SqlDbType.VarChar, 50)
{
Value = projeSelect.TypeName
},
new SqlParameter("@Prefix_BodyCode", SqlDbType.VarChar, 50)
{
Value = projeSelect.Prefix_BodyCode
},
new SqlParameter("@Prefix_OpticalCode", SqlDbType.VarChar, 50)
{
Value = projeSelect.Prefix_OpticalCode
},
new SqlParameter("@Prefix_MotherboardEncoding", SqlDbType.VarChar, 50)
{
Value = projeSelect.Prefix_MotherboardEncoding
},
new SqlParameter("@ZhiDan", SqlDbType.VarChar, 50)
{
Value = projeSelect.ZhiDan
},
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 维修更新
/// </summary>
/// <param name="piWX"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int updateProjectorInformation_MainTable_WXDal(ProjectorInformation_WX piWX, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
{
Value = piWX.FuselageCode
},
new SqlParameter("@RepairText", SqlDbType.VarChar, 500)
{
Value = "++" + piWX.RepairText
},
new SqlParameter("@RepairTime", SqlDbType.DateTime)
{
Value = piWX.RepairTime
},
new SqlParameter("@AfterMaintenanceOpticalCode", SqlDbType.VarChar, 80)
{
Value = piWX.AfterMaintenanceOpticalCode
},
new SqlParameter("@AfterMaintenanceMainBoardCode", SqlDbType.VarChar, 50)
{
Value = piWX.AfterMaintenanceMainBoardCode
},
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
public ProjectorInformation_SelectPrefix selecctProjectorInformation_SelectPrefixDal(string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
ProjectorInformation_SelectPrefix projeSelect = new ProjectorInformation_SelectPrefix();
try
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text))
{
if (reader.HasRows)
{
while (reader.Read())
{
projeSelect.TypeName = reader.GetString(0);
projeSelect.Prefix_BodyCode = reader.IsDBNull(1) ? "" : reader.GetString(1);
projeSelect.Prefix_OpticalCode = reader.IsDBNull(2) ? "" : reader.GetString(2);
projeSelect.Prefix_MotherboardEncoding = reader.IsDBNull(3) ? "" : reader.GetString(3);
projeSelect.ZhiDan = reader.IsDBNull(4) ? "" : reader.GetString(4);
}
}
return(projeSelect);
}
}
catch
{
throw;
}
}
/// <summary>
/// 主板表查询是否存在主板编码
/// </summary>
/// <param name="MainBoardCode"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int selectCountProjectorInformation_MainBoardDal(string MainBoardCode, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@MainBoardCode", SqlDbType.VarChar, 50)
{
Value = MainBoardCode
}
};
return((int)SQLhelp.ExecuteScalar(sql, CommandType.Text, pms));
}
/// <summary>
/// 查询登录密码
/// </summary>
/// <param name="txt_Password"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int selectCountProjectorInformation_AdminiDal(string txt_Password, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@AdminiPassword", SqlDbType.VarChar, 50)
{
Value = txt_Password
}
};
return((int)SQLhelp.ExecuteScalar(sql, CommandType.Text, pms));
}
/// <summary>
/// 按机身码删除数据
/// </summary>
/// <param name="FuselageCode"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int deleteProjectorInformation_MainTableFuselageCodeDal(string FuselageCode, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
{
Value = FuselageCode
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 老化前测试更新
/// </summary>
/// <param name="FuselageCode"></param>
/// <param name="PreAgingTestTime"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int updateProjectorInformation_MainTable_LHQDal(string FuselageCode, DateTime PreAgingTestTime, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
{
Value = FuselageCode
},
new SqlParameter("@PreAgingTestTime", SqlDbType.DateTime)
{
Value = PreAgingTestTime
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 查询有没有存在机身编码
/// </summary>
/// <param name="FuselageCode"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int selectCountProjectorInformation_MainTableDal(string FuselageCode, string ZhiDan, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
{
Value = FuselageCode
},
new SqlParameter("@ZhiDan", SqlDbType.VarChar, 50)
{
Value = ZhiDan
}
};
return((int)SQLhelp.ExecuteScalar(sql, CommandType.Text, pms));
}
/// <summary>
/// 老化下架时间更新
/// </summary>
/// <param name="lhx"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int updateProjectorInformation_MainTable_LHXDal(ProjectorInformation_LHX lhx, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
{
Value = lhx.FuselageCode
},
new SqlParameter("@AgeingEndTime", SqlDbType.DateTime)
{
Value = lhx.AgeingEndTime
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 老化后插入数据
/// </summary>
/// <param name="proje"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int insertProjectorInformation_MainTable_LHHDal(ProjectorInformation_LHH proje, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
{
Value = proje.FuselageCode
},
new SqlParameter("@PostAgingTestTime", SqlDbType.DateTime)
{
Value = proje.PostAgingTestTime
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 主板表更新数据
/// </summary>
/// <param name="proje"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int updateProjectorInformation_MainBoardDal(ProjectorInformation_MainBoard proje, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@MainBoardCode", SqlDbType.VarChar, 50)
{
Value = proje.MainBoardCode
},
new SqlParameter("@MainBoardTime", SqlDbType.DateTime)
{
Value = proje.MainBoardTime
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
/// <summary>
/// 包装更新
/// </summary>
/// <param name="piBZ"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int updateProjectorInformation_MainTable_BZDal(ProjectorInformation_BZ piBZ, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
{
Value = piBZ.FuselageCode
},
new SqlParameter("@PackingTime", SqlDbType.VarChar, 500)
{
Value = piBZ.PackingTime
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
public int updateProjectorInformation_MACDal(ProjectorInformation_MAC pmac, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@MAC", SqlDbType.VarChar, 80)
{
Value = pmac.MAC
},
new SqlParameter("@selectedTab", SqlDbType.VarChar, 50)
{
Value = pmac.selectedTab
},
new SqlParameter("@LHSX", SqlDbType.Bit)
{
Value = pmac.LHSX
}
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
public List <ProjectorInformation_MAC> selectProjectorInformation_MAC(string MAC, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
List <ProjectorInformation_MAC> list = new List <ProjectorInformation_MAC>();
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@MAC", SqlDbType.VarChar, 80)
{
Value = MAC
}
};
try
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql, CommandType.Text, pms))
{
if (reader.HasRows)
{
while (reader.Read())
{
list.Add(new ProjectorInformation_MAC()
{
MAC = reader.GetString(0),
selectedTab = reader.GetString(1),
LHSX = reader.GetBoolean(2)
});
}
}
return(list);
}
}
catch
{
throw;
}
}
/// <summary>
/// 主表按机身码查询
/// </summary>
/// <param name="FuselageCode"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public List <ProjectorInformation_MainTable_STR> selectProjectorInformation_MainTableDal(string FuselageCode, string ZhiDan, string OpticalCode, string MainBoardCode, string WiredMAC, string wirelessMAC, string SQLCommand)
{
StringBuilder sql = new StringBuilder(SQLhelp.GetSQLCommand(SQLCommand));
List <ProjectorInformation_MainTable_STR> list = new List <ProjectorInformation_MainTable_STR>();
List <SqlParameter> listsqlpar = new List <SqlParameter>();
List <string> wherelist = new List <string>();
if (FuselageCode.Length > 0)
{
wherelist.Add(" FuselageCode=@FuselageCode ");
listsqlpar.Add(new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
{
Value = FuselageCode
});
}
if (ZhiDan.Length > 0)
{
wherelist.Add(" ZhiDan=@ZhiDan ");
listsqlpar.Add(new SqlParameter("@ZhiDan", SqlDbType.VarChar, 50)
{
Value = ZhiDan
});
}
if (OpticalCode.Length > 0)
{
wherelist.Add(" OpticalCode=@OpticalCode ");
listsqlpar.Add(new SqlParameter("@OpticalCode", SqlDbType.VarChar, 80)
{
Value = OpticalCode
});
}
if (MainBoardCode.Length > 0)
{
wherelist.Add(" MainBoardCode=@MainBoardCode ");
listsqlpar.Add(new SqlParameter("@MainBoardCode", SqlDbType.VarChar, 50)
{
Value = MainBoardCode
});
}
if (WiredMAC.Length > 0)
{
wherelist.Add(" WiredMAC=@WiredMAC ");
listsqlpar.Add(new SqlParameter("@WiredMAC", SqlDbType.VarChar, 50)
{
Value = WiredMAC
});
}
if (wirelessMAC.Length > 0)
{
wherelist.Add(" wirelessMAC=@wirelessMAC ");
listsqlpar.Add(new SqlParameter("@wirelessMAC", SqlDbType.VarChar, 50)
{
Value = wirelessMAC
});
}
if (wherelist.Count > 0)
{
sql.Append(" where ");
sql.Append(string.Join(" and ", wherelist));
}
try
{
if (listsqlpar.Count > 0)
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql.ToString(), CommandType.Text, listsqlpar.ToArray()))
{
if (reader.HasRows)
{
while (reader.Read())
{
list.Add(new ProjectorInformation_MainTable_STR()
{
FuselageCode = reader.GetString(0),
OpticalCode = reader.IsDBNull(1) ? "" : reader.GetString(1),
PolishingMachineTime = reader.IsDBNull(2) ? "" : reader.GetDateTime(2).ToString(),
PreAgingTestTime = reader.IsDBNull(3) ? "" : reader.GetDateTime(3).ToString(),
AgeingBeginTime = reader.IsDBNull(4) ? "" : reader.GetDateTime(4).ToString(),
AgeingEndTime = reader.IsDBNull(5) ? "" : reader.GetDateTime(5).ToString(),
PostAgingTestTime = reader.IsDBNull(6) ? "" : reader.GetDateTime(6).ToString(),
PreAgingTestTime2 = reader.IsDBNull(7) ? "" : reader.GetDateTime(7).ToString(),
PostAgingTestTime2 = reader.IsDBNull(8) ? "" : reader.GetDateTime(8).ToString(),
IlluminationValue = reader.IsDBNull(9) ? "" : reader.GetString(9),
WiredMAC = reader.IsDBNull(10) ? "" : reader.GetString(10),
wirelessMAC = reader.IsDBNull(11) ? "" : reader.GetString(11),
LuminanceTestTime = reader.IsDBNull(12) ? "" : reader.GetDateTime(12).ToString(),
RepairText = reader.IsDBNull(13) ? "" : reader.GetString(13),
RepairTime = reader.IsDBNull(14) ? "" : reader.GetDateTime(14).ToString(),
PackingTime = reader.IsDBNull(15) ? "" : reader.GetDateTime(15).ToString(),
MainBoardCode = reader.IsDBNull(16) ? "" : reader.GetString(16),
MainBoardTime = reader.IsDBNull(17) ? "" : reader.GetDateTime(17).ToString(),
ZhiDan = reader.IsDBNull(18) ? "" : reader.GetString(18),
AfterMaintenanceOpticalCode = reader.IsDBNull(19)?"":reader.GetString(19),
AfterMaintenanceMainBoardCode = reader.IsDBNull(20)?"":reader.GetString(20),
LuminanceTestQTime = reader.IsDBNull(21) ? "" : reader.GetDateTime(21).ToString(),
});
}
}
return(list);
}
}
else
{
using (SqlDataReader reader = SQLhelp.ExecuteReader(sql.ToString(), CommandType.Text))
{
if (reader.HasRows)
{
while (reader.Read())
{
list.Add(new ProjectorInformation_MainTable_STR()
{
FuselageCode = reader.GetString(0),
OpticalCode = reader.IsDBNull(1) ? "" : reader.GetString(1),
PolishingMachineTime = reader.IsDBNull(2) ? "" : reader.GetDateTime(2).ToString(),
PreAgingTestTime = reader.IsDBNull(3) ? "" : reader.GetDateTime(3).ToString(),
AgeingBeginTime = reader.IsDBNull(4) ? "" : reader.GetDateTime(4).ToString(),
AgeingEndTime = reader.IsDBNull(5) ? "" : reader.GetDateTime(5).ToString(),
PostAgingTestTime = reader.IsDBNull(6) ? "" : reader.GetDateTime(6).ToString(),
PreAgingTestTime2 = reader.IsDBNull(7) ? "" : reader.GetDateTime(7).ToString(),
PostAgingTestTime2 = reader.IsDBNull(8) ? "" : reader.GetDateTime(8).ToString(),
IlluminationValue = reader.IsDBNull(9) ? "" : reader.GetString(9),
WiredMAC = reader.IsDBNull(10) ? "" : reader.GetString(10),
wirelessMAC = reader.IsDBNull(11) ? "" : reader.GetString(11),
LuminanceTestTime = reader.IsDBNull(12) ? "" : reader.GetDateTime(12).ToString(),
RepairText = reader.IsDBNull(13) ? "" : reader.GetString(13),
RepairTime = reader.IsDBNull(14) ? "" : reader.GetDateTime(14).ToString(),
PackingTime = reader.IsDBNull(15) ? "" : reader.GetDateTime(15).ToString(),
MainBoardCode = reader.IsDBNull(16) ? "" : reader.GetString(16),
MainBoardTime = reader.IsDBNull(17) ? "" : reader.GetDateTime(17).ToString(),
ZhiDan = reader.IsDBNull(18) ? "" : reader.GetString(18),
AfterMaintenanceOpticalCode = reader.IsDBNull(19) ? "" : reader.GetString(19),
AfterMaintenanceMainBoardCode = reader.IsDBNull(20) ? "" : reader.GetString(20),
LuminanceTestQTime = reader.IsDBNull(21) ? "" : reader.GetDateTime(21).ToString(),
});
}
}
return(list);
}
}
}
catch
{
throw;
}
}
/// <summary>
/// 多条件删除
/// </summary>
/// <param name="FuselageCode"></param>
/// <param name="ZhiDan"></param>
/// <param name="OpticalCode"></param>
/// <param name="MainBoardCode"></param>
/// <param name="WiredMAC"></param>
/// <param name="wirelessMAC"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int deleteProjectorInformation_MainTableDal(string FuselageCode, string ZhiDan, string OpticalCode, string MainBoardCode, string WiredMAC, string wirelessMAC, string SQLCommand)
{
StringBuilder sql = new StringBuilder(SQLhelp.GetSQLCommand(SQLCommand));
List <SqlParameter> listsqlpar = new List <SqlParameter>();
List <string> wherelist = new List <string>();
if (FuselageCode.Length > 0)
{
wherelist.Add(" FuselageCode=@FuselageCode ");
listsqlpar.Add(new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
{
Value = FuselageCode
});
}
if (ZhiDan.Length > 0)
{
wherelist.Add(" ZhiDan=@ZhiDan ");
listsqlpar.Add(new SqlParameter("@ZhiDan", SqlDbType.VarChar, 50)
{
Value = ZhiDan
});
}
if (OpticalCode.Length > 0)
{
wherelist.Add(" OpticalCode=@OpticalCode ");
listsqlpar.Add(new SqlParameter("@OpticalCode", SqlDbType.VarChar, 80)
{
Value = OpticalCode
});
}
if (MainBoardCode.Length > 0)
{
wherelist.Add(" MainBoardCode=@MainBoardCode ");
listsqlpar.Add(new SqlParameter("@MainBoardCode", SqlDbType.VarChar, 50)
{
Value = MainBoardCode
});
}
if (WiredMAC.Length > 0)
{
wherelist.Add(" WiredMAC=@WiredMAC ");
listsqlpar.Add(new SqlParameter("@WiredMAC", SqlDbType.VarChar, 50)
{
Value = WiredMAC
});
}
if (wirelessMAC.Length > 0)
{
wherelist.Add(" wirelessMAC=@wirelessMAC ");
listsqlpar.Add(new SqlParameter("@wirelessMAC", SqlDbType.VarChar, 50)
{
Value = wirelessMAC
});
}
if (wherelist.Count > 0)
{
sql.Append(" where ");
sql.Append(string.Join(" and ", wherelist));
}
if (listsqlpar.Count > 0)
{
return(SQLhelp.ExecuteNonQuery(sql.ToString(), CommandType.Text, listsqlpar.ToArray()));
}
else
{
return(SQLhelp.ExecuteNonQuery(sql.ToString(), CommandType.Text));
}
}