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