/// <summary> /// 获取一条资源信息 /// </summary> /// <param name="ResourceID"></param> /// <returns></returns> public Tz888.Model.Info.InfoResourceModel GetModel(long ResourceID) { SqlParameter[] parameters = { new SqlParameter("@ResourceID", SqlDbType.BigInt, 8) }; parameters[0].Value = ResourceID; Tz888.Model.Info.InfoResourceModel model = new Tz888.Model.Info.InfoResourceModel(); DataSet ds = DbHelperSQL.RunProcedure("InfoResourceTab_GetModel", parameters, "ds"); model.ResourceID = ResourceID; if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["InfoID"].ToString() != "") { model.InfoID = int.Parse(ds.Tables[0].Rows[0]["InfoID"].ToString()); } model.ResourceName = ds.Tables[0].Rows[0]["ResourceName"].ToString(); model.ResourceTitle = ds.Tables[0].Rows[0]["ResourceTitle"].ToString(); model.ResourceDescrib = ds.Tables[0].Rows[0]["ResourceDescrib"].ToString(); model.ResourceType = Convert.ToInt32(ds.Tables[0].Rows[0]["ResourceType"]); model.ResourceAddr = ds.Tables[0].Rows[0]["ResourceAddr"].ToString(); if (ds.Tables[0].Rows[0]["ResourceProperty"].ToString() != "") { model.ResourceProperty = int.Parse(ds.Tables[0].Rows[0]["ResourceProperty"].ToString()); } if (ds.Tables[0].Rows[0]["ResourcePassword"].ToString() != "") { model.ResourcePassword = (new UnicodeEncoding()).GetBytes(ds.Tables[0].Rows[0]["ResourcePassword"].ToString()); } if (ds.Tables[0].Rows[0]["UpDate"].ToString() != "") { model.UpDate = DateTime.Parse(ds.Tables[0].Rows[0]["UpDate"].ToString()); } if (ds.Tables[0].Rows[0]["IsDel"].ToString() != "") { if ((ds.Tables[0].Rows[0]["IsDel"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsDel"].ToString().ToLower() == "true")) { model.IsDel = true; } else { model.IsDel = false; } } model.remark = ds.Tables[0].Rows[0]["remark"].ToString(); return(model); } else { return(null); } }
public void AddRes(string filename, string filetype) { Tz888.Model.Info.InfoResourceModel model = new Tz888.Model.Info.InfoResourceModel(); Tz888.BLL.Info.InfoResourceBLL dal = new Tz888.BLL.Info.InfoResourceBLL(); model.InfoID = _infoid; model.ResourceAddr = filename; model.ResourceName = infotype.Trim(); model.ResourceTitle = txtFileName.Value.Trim(); model.ResourceType = Convert.ToInt32(filetype); model.UpDate = DateTime.Now; model.IsDel = false; long i = dal.Insert(model); if (i > 0) { Tz888.Common.MessageBox.ResponseScript(this.Page, "alert('上传成功..');parent.init();parent.Lock_CheckForm();"); } else { Tz888.Common.MessageBox.ResponseScript(this.Page, "alert('上传失败..')"); } }
private const string SP_InfoResource_InsertMany = "InfoResourceTab_InsertMany"; //上传多个文件 #region 添加资源信息 /// <summary> /// 添加资源信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public long Insert(Tz888.Model.Info.InfoResourceModel model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@ResourceID", SqlDbType.BigInt, 8), new SqlParameter("@InfoID", SqlDbType.BigInt, 8), new SqlParameter("@ResourceName", SqlDbType.VarChar, 100), new SqlParameter("@ResourceTitle", SqlDbType.Char, 13), new SqlParameter("@ResourceDescrib", SqlDbType.VarChar, 1000), new SqlParameter("@ResourceType", SqlDbType.SmallInt, 2), new SqlParameter("@ResourceAddr", SqlDbType.VarChar, 300), new SqlParameter("@ResourceProperty", SqlDbType.SmallInt, 2), new SqlParameter("@ResourcePassword", SqlDbType.Binary, 1), new SqlParameter("@UpDate", SqlDbType.DateTime), new SqlParameter("@IsDel", SqlDbType.Bit, 1), new SqlParameter("@remark", SqlDbType.VarChar, 100) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.InfoID; parameters[2].Value = model.ResourceName; parameters[3].Value = model.ResourceTitle; parameters[4].Value = model.ResourceDescrib; parameters[5].Value = model.ResourceType; parameters[6].Value = model.ResourceAddr; parameters[7].Value = model.ResourceProperty; parameters[8].Value = model.ResourcePassword; parameters[9].Value = model.UpDate; parameters[10].Value = model.IsDel; parameters[11].Value = model.remark; DbHelperSQL.RunProcedure(SP_InfoResource_Insert, parameters, out rowsAffected); return((long)parameters[0].Value); }
/// <summary> /// 添加资源信息(带事务控制的方法2.一次上传多个文件并写入库中) /// </summary> /// <param name="sqlConn"></param> /// <param name="sqlTran"></param> /// <param name="model"></param> /// <param name="IsMany">1表示为一次上传多个文件并写入表中</param> /// <returns></returns> public bool InsertInfoResource(SqlConnection sqlConn, SqlTransaction sqlTran, Tz888.Model.Info.InfoResourceModel model, int IsMany) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@ResourceID", SqlDbType.BigInt, 8), new SqlParameter("@InfoID", SqlDbType.BigInt, 8), new SqlParameter("@ResourceName", SqlDbType.VarChar, 100), new SqlParameter("@ResourceTitle", SqlDbType.Char, 13), new SqlParameter("@ResourceDescrib", SqlDbType.VarChar, 1000), new SqlParameter("@ResourceType", SqlDbType.SmallInt, 2), new SqlParameter("@ResourceAddr", SqlDbType.VarChar, 300), new SqlParameter("@ResourceProperty", SqlDbType.SmallInt, 2), new SqlParameter("@ResourcePassword", SqlDbType.Binary, 1), new SqlParameter("@UpDate", SqlDbType.DateTime), new SqlParameter("@IsDel", SqlDbType.Bit, 1), new SqlParameter("@remark", SqlDbType.VarChar, 100) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.InfoID; parameters[2].Value = model.ResourceName; parameters[3].Value = model.ResourceTitle; parameters[4].Value = model.ResourceDescrib; parameters[5].Value = model.ResourceType; parameters[6].Value = model.ResourceAddr; parameters[7].Value = model.ResourceProperty; parameters[8].Value = model.ResourcePassword; parameters[9].Value = model.UpDate; parameters[10].Value = model.IsDel; parameters[11].Value = model.remark; if (IsMany == 1) //将多个文件写入表中 { DbHelperSQL.RunProcedure(sqlConn, sqlTran, SP_InfoResource_InsertMany, parameters, out rowsAffected); } else { DbHelperSQL.RunProcedure(sqlConn, sqlTran, SP_InfoResource_Insert, parameters, out rowsAffected); } if (rowsAffected > 0) { return(true); } return(false); }