/// <summary> /// /// </summary> void DoCmd() { if (!string.IsNullOrEmpty(this.cmd) && this.ItemID > 0 && this.UserId > 0) { usersIdImageInfo update = new usersIdImageInfo(); update.id = this.ItemID; if (cmd == "ok") { update.status = IdImageStatus.审核成功; } if (cmd == "fail") { update.status = IdImageStatus.审核失败; } update.why = string.Empty; update.checktime = DateTime.Now; update.admin = this.ManageId; update.userId = this.UserId; viviapi.BLL.User.usersIdImage bll = new viviapi.BLL.User.usersIdImage(); if (bll.Check(update)) { AlertAndRedirect("操作成功", "UserIdImgList.aspx?s=1"); } else { AlertAndRedirect("操作失败"); } } }
void Save(string cmd) { usersIdImageInfo update = new usersIdImageInfo(); update.id = ItemInfoId; if (cmd == "ok") { update.status = IdImageStatus.审核成功; } if (cmd == "fail") { update.status = IdImageStatus.审核失败; } update.why = this.txtWhy.Text.Trim(); update.checktime = DateTime.Now; update.admin = this.ManageId; update.userId = ItemInfo.userId; BLL.User.usersIdImage bll = new viviapi.BLL.User.usersIdImage(); if (bll.Check(update)) { WebUtility.AlertAndClose(this, "操作成功"); //AlertAndRedirect("操作成功", "UserIdImgList.aspx?s=1"); } else { WebUtility.AlertAndClose(this, "操作失败"); } }
/// <summary> /// /// </summary> /// <param name="ds"></param> /// <returns></returns> public static usersIdImageInfo GetModelFromDs(DataSet ds) { usersIdImageInfo model = new usersIdImageInfo(); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["userId"].ToString() != "") { model.userId = int.Parse(ds.Tables[0].Rows[0]["userId"].ToString()); } //if (ds.Tables[0].Rows[0]["image_on"].ToString() != "") //{ // model.image_on = (byte[])ds.Tables[0].Rows[0]["image_on"]; //} //if (ds.Tables[0].Rows[0]["image_down"].ToString() != "") //{ // model.image_down = (byte[])ds.Tables[0].Rows[0]["image_down"]; //} model.ptype = ds.Tables[0].Rows[0]["ptype"].ToString(); if (ds.Tables[0].Rows[0]["filesize"].ToString() != "") { model.filesize = int.Parse(ds.Tables[0].Rows[0]["filesize"].ToString()); } model.ptype1 = ds.Tables[0].Rows[0]["ptype1"].ToString(); if (ds.Tables[0].Rows[0]["filesize1"].ToString() != "") { model.filesize1 = int.Parse(ds.Tables[0].Rows[0]["filesize1"].ToString()); } if (ds.Tables[0].Rows[0]["status"].ToString() != "") { model.status = (IdImageStatus)int.Parse(ds.Tables[0].Rows[0]["status"].ToString()); } else { model.status = IdImageStatus.未知; } model.why = ds.Tables[0].Rows[0]["why"].ToString(); if (ds.Tables[0].Rows[0]["admin"].ToString() != "") { model.admin = int.Parse(ds.Tables[0].Rows[0]["admin"].ToString()); } if (ds.Tables[0].Rows[0]["checktime"].ToString() != "") { model.checktime = DateTime.Parse(ds.Tables[0].Rows[0]["checktime"].ToString()); } if (ds.Tables[0].Rows[0]["addtime"].ToString() != "") { model.addtime = DateTime.Parse(ds.Tables[0].Rows[0]["addtime"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Check(usersIdImageInfo model) { try { SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), //new SqlParameter("@userId", SqlDbType.Int,4), //new SqlParameter("@image_on", SqlDbType.Image,16), //new SqlParameter("@image_down", SqlDbType.Image,16), //new SqlParameter("@ptype", SqlDbType.NVarChar,20), //new SqlParameter("@filesize", SqlDbType.Int,4), //new SqlParameter("@ptype1", SqlDbType.NVarChar,20), //new SqlParameter("@filesize1", SqlDbType.Int,4), new SqlParameter("@status", SqlDbType.TinyInt, 1), new SqlParameter("@why", SqlDbType.NVarChar, 150), new SqlParameter("@admin", SqlDbType.Int, 4), new SqlParameter("@checktime", SqlDbType.DateTime), //new SqlParameter("@addtime", SqlDbType.DateTime) }; parameters[0].Value = model.id; //parameters[1].Value = model.userId; //parameters[2].Value = model.image_on; //parameters[3].Value = model.image_down; //parameters[4].Value = model.ptype; //parameters[5].Value = model.filesize; //parameters[6].Value = model.ptype1; //parameters[7].Value = model.filesize1; parameters[1].Value = (int)model.status; parameters[2].Value = model.why; parameters[3].Value = model.admin; parameters[4].Value = model.checktime; bool success = DataBase.ExecuteNonQuery(CommandType.StoredProcedure, "proc_usersIdImage_update", parameters) > 0; if (success && model.status == IdImageStatus.审核成功) { Factory.ClearCache(model.userId.Value); } return(success); } catch (Exception ex) { ExceptionHandler.HandleException(ex); return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(usersIdImageInfo model) { try { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@userId", SqlDbType.Int, 4), new SqlParameter("@image_on", SqlDbType.Image), new SqlParameter("@image_down", SqlDbType.Image), new SqlParameter("@ptype", SqlDbType.NVarChar, 20), new SqlParameter("@filesize", SqlDbType.Int, 4), new SqlParameter("@ptype1", SqlDbType.NVarChar, 20), new SqlParameter("@filesize1", SqlDbType.Int, 4), new SqlParameter("@status", SqlDbType.TinyInt, 1), //new SqlParameter("@why", SqlDbType.NVarChar,150), //new SqlParameter("@admin", SqlDbType.Int,4), //new SqlParameter("@checktime", SqlDbType.DateTime), new SqlParameter("@addtime", SqlDbType.DateTime) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.userId; parameters[2].Value = model.image_on; parameters[3].Value = model.image_down; parameters[4].Value = model.ptype; parameters[5].Value = model.filesize; parameters[6].Value = model.ptype1; parameters[7].Value = model.filesize1; parameters[8].Value = (int)model.status; //parameters[9].Value = model.why; //parameters[10].Value = model.admin; // parameters[11].Value = model.checktime; parameters[9].Value = model.addtime; DataBase.ExecuteNonQuery(CommandType.StoredProcedure, "proc_usersIdImage_add", parameters); return((int)parameters[0].Value); } catch (Exception ex) { ExceptionHandler.HandleException(ex); return(0); } }
public usersIdImageInfo Get(int id) { usersIdImageInfo model = new usersIdImageInfo(); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; IDataReader dataReader = DataBase.ExecuteReader(CommandType.StoredProcedure, "proc_usersIdImage_GetModel", parameters); if (dataReader.Read()) { object ojb = dataReader["image_on"]; if (ojb != null && ojb != DBNull.Value) { model.image_on = (byte[])ojb; } ojb = dataReader["image_down"]; if (ojb != null && ojb != DBNull.Value) { model.image_down = (byte[])ojb; } model.ptype = dataReader["ptype"].ToString(); ojb = dataReader["filesize"]; if (ojb != null && ojb != DBNull.Value) { model.filesize = (int)ojb; } model.ptype1 = dataReader["ptype1"].ToString(); ojb = dataReader["filesize1"]; if (ojb != null && ojb != DBNull.Value) { model.filesize1 = (int)ojb; } } return(model); }