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