/// <summary>
/// 通过账号和密码得到一个对象实体
/// </summary>
/// <param name="account"></param>
/// <param name="password"></param>
/// <returns></returns>
public HomeAccountingSystem.Model.jt_yh_zl GetLoginUserModel(string account, string password)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 pk,v_yh_no,v_yh_name,v_yh_pwd,i_yh_type,v_phone,t_birthday_gregorian,t_birthday_lunar,t_create_time,i_delete,v_photo,v_age,v_photo_path from jt_yh_zl ");
strSql.Append(" where v_yh_no=@v_yh_no and v_yh_pwd=@v_yh_pwd ");
SqlParameter[] parameters =
{
new SqlParameter("@v_yh_no", SqlDbType.VarChar, 256),
new SqlParameter("@v_yh_pwd", SqlDbType.VarChar, 256)
};
parameters[0].Value = account;
parameters[1].Value = password;
HomeAccountingSystem.Model.jt_yh_zl model = new HomeAccountingSystem.Model.jt_yh_zl();
DataSet ds = SQLServerHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public HomeAccountingSystem.Model.jt_yh_zl DataRowToModel(DataRow row)
{
HomeAccountingSystem.Model.jt_yh_zl model = new HomeAccountingSystem.Model.jt_yh_zl();
if (row != null)
{
if (row["pk"] != null && row["pk"].ToString() != "")
{
model.pk = int.Parse(row["pk"].ToString());
}
if (row["v_yh_no"] != null)
{
model.v_yh_no = row["v_yh_no"].ToString();
}
if (row["v_yh_name"] != null)
{
model.v_yh_name = row["v_yh_name"].ToString();
}
if (row["v_yh_pwd"] != null)
{
model.v_yh_pwd = row["v_yh_pwd"].ToString();
}
if (row["i_yh_type"] != null && row["i_yh_type"].ToString() != "")
{
model.i_yh_type = int.Parse(row["i_yh_type"].ToString());
}
if (row["v_phone"] != null)
{
model.v_phone = row["v_phone"].ToString();
}
if (row["t_birthday_gregorian"] != null && row["t_birthday_gregorian"].ToString() != "")
{
model.t_birthday_gregorian = DateTime.Parse(row["t_birthday_gregorian"].ToString());
}
if (row["t_birthday_lunar"] != null)
{
model.t_birthday_lunar = row["t_birthday_lunar"].ToString();
}
if (row["t_create_time"] != null && row["t_create_time"].ToString() != "")
{
model.t_create_time = DateTime.Parse(row["t_create_time"].ToString());
}
if (row["i_delete"] != null && row["i_delete"].ToString() != "")
{
model.i_delete = int.Parse(row["i_delete"].ToString());
}
//if(row["v_photo"]!=null)
//{
// model.v_photo=row["v_photo"].ToString();
//}
if (row["v_age"] != null)
{
model.v_age = row["v_age"].ToString();
}
if (row["v_photo_path"] != null)
{
model.v_photo_path = row["v_photo_path"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(HomeAccountingSystem.Model.jt_yh_zl model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update jt_yh_zl set ");
strSql.Append("v_yh_no=@v_yh_no,");
strSql.Append("v_yh_name=@v_yh_name,");
strSql.Append("v_yh_pwd=@v_yh_pwd,");
strSql.Append("i_yh_type=@i_yh_type,");
strSql.Append("v_phone=@v_phone,");
strSql.Append("t_birthday_gregorian=@t_birthday_gregorian,");
strSql.Append("t_birthday_lunar=@t_birthday_lunar,");
strSql.Append("t_create_time=@t_create_time,");
strSql.Append("i_delete=@i_delete,");
strSql.Append("v_photo=@v_photo,");
strSql.Append("v_age=@v_age,");
strSql.Append("v_photo_path=@v_photo_path");
strSql.Append(" where pk=@pk ");
SqlParameter[] parameters =
{
new SqlParameter("@v_yh_no", SqlDbType.VarChar, 256),
new SqlParameter("@v_yh_name", SqlDbType.VarChar, 256),
new SqlParameter("@v_yh_pwd", SqlDbType.VarChar, 256),
new SqlParameter("@i_yh_type", SqlDbType.Int, 4),
new SqlParameter("@v_phone", SqlDbType.VarChar, 256),
new SqlParameter("@t_birthday_gregorian", SqlDbType.DateTime),
new SqlParameter("@t_birthday_lunar", SqlDbType.VarChar, 4000),
new SqlParameter("@t_create_time", SqlDbType.DateTime),
new SqlParameter("@i_delete", SqlDbType.Int, 4),
new SqlParameter("@v_photo", SqlDbType.Image),
new SqlParameter("@v_age", SqlDbType.VarChar, 256),
new SqlParameter("@v_photo_path", SqlDbType.VarChar, 256),
new SqlParameter("@pk", SqlDbType.Int, 4)
};
parameters[0].Value = model.v_yh_no;
parameters[1].Value = model.v_yh_name;
parameters[2].Value = model.v_yh_pwd;
parameters[3].Value = model.i_yh_type;
parameters[4].Value = model.v_phone;
parameters[5].Value = model.t_birthday_gregorian;
parameters[6].Value = model.t_birthday_lunar;
parameters[7].Value = model.t_create_time;
parameters[8].Value = model.i_delete;
parameters[9].Value = model.v_photo;
parameters[10].Value = model.v_age;
parameters[11].Value = model.v_photo_path;
parameters[12].Value = model.pk;
int rows = SQLServerHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(HomeAccountingSystem.Model.jt_yh_zl model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into jt_yh_zl(");
strSql.Append("v_yh_no,v_yh_name,v_yh_pwd,i_yh_type,v_phone,t_birthday_gregorian,t_birthday_lunar,t_create_time,i_delete,v_photo,v_age,v_photo_path)");
strSql.Append(" values (");
strSql.Append("@v_yh_no,@v_yh_name,@v_yh_pwd,@i_yh_type,@v_phone,@t_birthday_gregorian,@t_birthday_lunar,@t_create_time,@i_delete,@v_photo,@v_age,@v_photo_path)");
SqlParameter[] parameters =
{
new SqlParameter("@v_yh_no", SqlDbType.VarChar, 256),
new SqlParameter("@v_yh_name", SqlDbType.VarChar, 256),
new SqlParameter("@v_yh_pwd", SqlDbType.VarChar, 256),
new SqlParameter("@i_yh_type", SqlDbType.Int, 4),
new SqlParameter("@v_phone", SqlDbType.VarChar, 256),
new SqlParameter("@t_birthday_gregorian", SqlDbType.DateTime),
new SqlParameter("@t_birthday_lunar", SqlDbType.VarChar, 4000),
new SqlParameter("@t_create_time", SqlDbType.DateTime),
new SqlParameter("@i_delete", SqlDbType.Int, 4),
new SqlParameter("@v_photo", SqlDbType.Image),
new SqlParameter("@v_age", SqlDbType.VarChar, 256),
new SqlParameter("@v_photo_path", SqlDbType.VarChar, 256)
};
parameters[0].Value = model.v_yh_no;
parameters[1].Value = model.v_yh_name;
parameters[2].Value = model.v_yh_pwd;
parameters[3].Value = model.i_yh_type;
parameters[4].Value = model.v_phone;
parameters[5].Value = model.t_birthday_gregorian;
parameters[6].Value = model.t_birthday_lunar;
parameters[7].Value = model.t_create_time;
parameters[8].Value = model.i_delete;
parameters[9].Value = model.v_photo;
parameters[10].Value = model.v_age;
parameters[11].Value = model.v_photo_path;
int rows = SQLServerHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public HomeAccountingSystem.Model.jt_yh_zl GetModel(int pk)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 pk,v_yh_no,v_yh_name,v_yh_pwd,i_yh_type,v_phone,t_birthday_gregorian,t_birthday_lunar,t_create_time,i_delete,v_photo,v_age,v_photo_path from jt_yh_zl ");
strSql.Append(" where pk=@pk ");
SqlParameter[] parameters =
{
new SqlParameter("@pk", SqlDbType.Int, 4)
};
parameters[0].Value = pk;
HomeAccountingSystem.Model.jt_yh_zl model = new HomeAccountingSystem.Model.jt_yh_zl();
DataSet ds = SQLServerHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
