/// <summary> /// 得到一个对象实体 /// </summary> public viviapi.Model.User.UserLoginByPartner DataRowToModel(DataRow row) { viviapi.Model.User.UserLoginByPartner model = new viviapi.Model.User.UserLoginByPartner(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["userid"] != null && row["userid"].ToString() != "") { model.userid = int.Parse(row["userid"].ToString()); } if (row["plant"] != null && row["plant"].ToString() != "") { model.plant = int.Parse(row["plant"].ToString()); } if (row["plantname"] != null) { model.plantname = row["plantname"].ToString(); } if (row["openid"] != null) { model.openid = row["openid"].ToString(); } if (row["available"] != null && row["available"].ToString() != "") { model.available = int.Parse(row["available"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(viviapi.Model.User.UserLoginByPartner model) { int rowsAffected = 0; SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@userid", SqlDbType.Int, 4), new SqlParameter("@plant", SqlDbType.TinyInt, 1), new SqlParameter("@plantname", SqlDbType.VarChar, 50), new SqlParameter("@openid", SqlDbType.VarChar, 100), new SqlParameter("@available", SqlDbType.TinyInt, 1) }; parameters[0].Value = model.id; parameters[1].Value = model.userid; parameters[2].Value = model.plant; parameters[3].Value = model.plantname; parameters[4].Value = model.openid; parameters[5].Value = model.available; DbHelperSQL.RunProcedure("proc_UserLoginByPartner_Update", parameters, out rowsAffected); if (rowsAffected > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public viviapi.Model.User.UserLoginByPartner GetModel(int id) { SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; viviapi.Model.User.UserLoginByPartner model = new viviapi.Model.User.UserLoginByPartner(); DataSet ds = DbHelperSQL.RunProcedure("proc_UserLoginByPartner_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public viviapi.Model.User.UserLoginByPartner GetModel(int plant, string openid) { IDataParameter[] parameters = { new SqlParameter("@plant", SqlDbType.Int, 4), new SqlParameter("@openid", SqlDbType.VarChar, 100) }; parameters[0].Value = plant; parameters[1].Value = openid; var model = new viviapi.Model.User.UserLoginByPartner(); DataSet ds = DbHelperSQL.RunProcedure("proc_userLoginByPartner_GetModelByOpenId", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(viviapi.Model.User.UserLoginByPartner model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@userid", SqlDbType.Int, 4), new SqlParameter("@plant", SqlDbType.TinyInt, 1), new SqlParameter("@plantname", SqlDbType.VarChar, 50), new SqlParameter("@openid", SqlDbType.VarChar, 100), new SqlParameter("@available", SqlDbType.TinyInt, 1) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.userid; parameters[2].Value = model.plant; parameters[3].Value = model.plantname; parameters[4].Value = model.openid; parameters[5].Value = model.available; DbHelperSQL.RunProcedure("proc_UserLoginByPartner_ADD", parameters, out rowsAffected); return((int)parameters[0].Value); }