/// <summary>
/// 用username/ygbh获取信息
/// </summary>
/// <param name="sbbh">username/ygbh</param>
/// <returns>bool</returns>
public SYS.Model.YGB getXXbyuserName(string userName)
{
string sql = "select * from YGB where YGBH=@userName or User_Name=@userName";
SqlParameter[] spr =
{
new SqlParameter("@userName", userName)
};
try
{
SYS.Model.YGB sb = new SYS.Model.YGB();
DataTable dt = new DataTable();
dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr);
if (dt.Rows.Count > 0)
{
sb.YGBH = dt.Rows[0]["YGBH"].ToString();
sb.YGXM = dt.Rows[0]["YGXM"].ToString();
sb.DHHM = dt.Rows[0]["DHHM"].ToString();
sb.YGZWBH = int.Parse(dt.Rows[0]["YGZWBH"].ToString());
sb.YGSFZ = dt.Rows[0]["YGSFZ"].ToString();
sb.YGZT = dt.Rows[0]["YGZT"].ToString();
sb.User_Name = dt.Rows[0]["User_Name"].ToString();
sb.Password = dt.Rows[0]["Password"].ToString();
}
return(sb);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 用username和password检测是否存在
/// </summary>
/// <param name="sbbh">设备编号</param>
/// <returns>bool</returns>
public bool checkYgbhIsAlive(string ygbh)
{
string sql = "select * from YGB where YGBH=@ygbh";
SqlParameter[] spr =
{
new SqlParameter("@ygbh", ygbh)
};
try
{
SYS.Model.YGB sb = new SYS.Model.YGB();
DataTable dt = new DataTable();
dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr);
if (dt.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// 用username和password检测是否存在
/// </summary>
/// <param name="sbbh">设备编号</param>
/// <returns>bool</returns>
public bool checkIsRight(string userName, string password)
{
string sql = "select * from YGB where (YGBH=@userName or User_Name=@userName) and Password=@password";
SqlParameter[] spr =
{
new SqlParameter("@userName", userName),
new SqlParameter("@password", password)
};
try
{
SYS.Model.YGB sb = new SYS.Model.YGB();
DataTable dt = new DataTable();
dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr);
if (dt.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
}
public bool Update(SYS.Model.YGB model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ygb set ");
strSql.Append("YGBH=@YGBH,"); //=@PZLX,");
strSql.Append("YGXM=@YGXM,"); //=@JCCLPH,");
strSql.Append("DHHM=@DHHM,"); //=@CLXHBH,");
strSql.Append("YGZWBH=@YGZWBH,"); //=@JCCS,");
strSql.Append("YGSFZ=@YGSFZ,"); //=@CCRQ,");
strSql.Append("YGZT=@YGZT,"); //=@DJRQ,");
strSql.Append("User_Name=@User_Name,"); //=@FDJH,");
strSql.Append("Password=@Password "); //=@CJH,");
strSql.Append("where ygbh=@YGBH or User_Name=@User_Name");
SqlParameter[] parameters =
{
new SqlParameter("@YGBH", SqlDbType.VarChar, 32),
new SqlParameter("@YGXM", SqlDbType.VarChar, 32),
new SqlParameter("@DHHM", SqlDbType.VarChar, 32),
new SqlParameter("@YGZWBH", SqlDbType.Int, 4),
new SqlParameter("@YGSFZ", SqlDbType.VarChar, 32),
new SqlParameter("@YGZT", SqlDbType.VarChar, 32),
new SqlParameter("@User_Name", SqlDbType.VarChar, 32),
new SqlParameter("@Password", SqlDbType.VarChar, 32)
};
parameters[0].Value = model.YGBH;
parameters[1].Value = model.YGXM;
parameters[2].Value = model.DHHM;
parameters[3].Value = model.YGZWBH;
parameters[4].Value = model.YGSFZ;
parameters[5].Value = model.YGZT;
parameters[6].Value = model.User_Name;
parameters[7].Value = model.Password;
try
{
int rows = DBHelperSQL.Execute(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
public bool AddNewUser(SYS.Model.YGB model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ygb (");
strSql.Append("YGBH,"); //=@PZLX,");
strSql.Append("YGXM,"); //=@JCCLPH,");
strSql.Append("DHHM,"); //=@CLXHBH,");
strSql.Append("YGZWBH,"); //=@JCCS,");
strSql.Append("YGSFZ,"); //=@CCRQ,");
strSql.Append("YGZT,"); //=@DJRQ,");
strSql.Append("User_Name,"); //=@FDJH,");
strSql.Append("Password)"); //=@CJH,");
strSql.Append("values (@YGBH,@YGXM,@DHHM,@YGZWBH,@YGSFZ,@YGZT,@User_Name,@Password)");
SqlParameter[] parameters =
{
new SqlParameter("@YGBH", SqlDbType.VarChar, 32),
new SqlParameter("@YGXM", SqlDbType.VarChar, 32),
new SqlParameter("@DHHM", SqlDbType.VarChar, 32),
new SqlParameter("@YGZWBH", SqlDbType.Int, 4),
new SqlParameter("@YGSFZ", SqlDbType.VarChar, 32),
new SqlParameter("@YGZT", SqlDbType.VarChar, 32),
new SqlParameter("@User_Name", SqlDbType.VarChar, 32),
new SqlParameter("@Password", SqlDbType.VarChar, 32)
};
parameters[0].Value = model.YGBH;
parameters[1].Value = model.YGXM;
parameters[2].Value = model.DHHM;
parameters[3].Value = model.YGZWBH;
parameters[4].Value = model.YGSFZ;
parameters[5].Value = model.YGZT;
parameters[6].Value = model.User_Name;
parameters[7].Value = model.Password;
try
{
if (DBHelperSQL.Execute(strSql.ToString(), parameters) > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
throw;
}
}
