/// <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="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="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));
}
