/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Tunnel.Model.Tunnel_file model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@f_id", SqlDbType.BigInt, 8),
//new SqlParameter("@f_title", SqlDbType.VarChar,100),
//new SqlParameter("@f_file", SqlDbType.VarBinary,100),
//new SqlParameter("@f_size", SqlDbType.VarChar,50),
new SqlParameter("@f_sort", SqlDbType.VarChar, 50),
//new SqlParameter("@f_addtime", SqlDbType.DateTime),
//new SqlParameter("@f_user", SqlDbType.Int,4),
new SqlParameter("@f_juser", SqlDbType.VarChar, 500),
new SqlParameter("@f_type", SqlDbType.Int, 4),
new SqlParameter("@f_user", SqlDbType.Int, 4),
new SqlParameter("@f_ip", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.f_id;
//parameters[1].Value = model.f_title;
//parameters[2].Value = model.f_file;
//parameters[3].Value = model.f_size;
parameters[1].Value = model.f_sort;
//parameters[5].Value = model.f_addtime;
//parameters[6].Value = model.f_user;
parameters[2].Value = model.f_juser;
parameters[3].Value = model.f_Type;
parameters[4].Value = model.f_user;
parameters[5].Value = model.f_Ip;
return(DbHelperSQL.RunProcedure("Tunnel_file_Update", parameters, out rowsAffected));
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <Tunnel.Model.Tunnel_file> DataTableToList(DataTable dt)
{
List <Tunnel.Model.Tunnel_file> modelList = new List <Tunnel.Model.Tunnel_file>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Tunnel.Model.Tunnel_file model;
for (int n = 0; n < rowsCount; n++)
{
model = new Tunnel.Model.Tunnel_file();
model.f_id = Convert.ToInt64(dt.Rows[n]["f_id"].ToString());
model.f_title = dt.Rows[n]["f_title"].ToString();
if (dt.Rows[n]["f_file"].ToString() != "")
{
model.f_file = dt.Rows[n]["f_file"].ToString();
}
model.f_size = dt.Rows[n]["f_size"].ToString();
model.f_sort = Convert.ToInt32(dt.Rows[n]["f_sort"].ToString());
if (dt.Rows[n]["f_addtime"].ToString() != "")
{
model.f_addtime = DateTime.Parse(dt.Rows[n]["f_addtime"].ToString());
}
if (dt.Rows[n]["f_user"].ToString() != "")
{
model.f_user = int.Parse(dt.Rows[n]["f_user"].ToString());
}
model.f_juser = dt.Rows[n]["f_juser"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Tunnel.Model.Tunnel_file model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@f_id", SqlDbType.Int, 8),
new SqlParameter("@f_title", SqlDbType.VarChar, 100),
new SqlParameter("@f_file", SqlDbType.VarChar, 200),
new SqlParameter("@f_size", SqlDbType.VarChar, 50),
new SqlParameter("@f_sort", SqlDbType.Int, 8),
new SqlParameter("@f_addtime", SqlDbType.DateTime),
new SqlParameter("@f_user", SqlDbType.Int, 4),
new SqlParameter("@f_juser", SqlDbType.VarChar, 500),
new SqlParameter("@f_ip", SqlDbType.VarChar, 20),
new SqlParameter("@f_content", SqlDbType.Text),
new SqlParameter("@f_bum", SqlDbType.Int, 8),
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.f_title;
parameters[2].Value = model.f_file;
parameters[3].Value = model.f_size;
parameters[4].Value = model.f_sort;
parameters[5].Value = model.f_addtime;
parameters[6].Value = model.f_user;
parameters[7].Value = model.f_juser;
parameters[8].Value = model.f_Ip;
parameters[9].Value = model.f_Content;
parameters[10].Value = model.f_Bum;
DbHelperSQL.RunProcedure("Tunnel_file_ADD", parameters, out rowsAffected);
return((int)parameters[0].Value);
}
/// <summary>
/// 获得数据列表
/// </summary>
/// <param name="pb">分页基本信息</param>
/// <param name="count">返回总数</param>
/// <returns></returns>
public List <Tunnel.Model.Tunnel_file> GetList(PageBase pb, ref int count)
{
DataTable dt = dal.GetList(pb, ref count).Tables[0];
List <Tunnel.Model.Tunnel_file> modelList = new List <Tunnel.Model.Tunnel_file>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0 && pb.DoCount == 0)
{
Tunnel.Model.Tunnel_file model;
for (int n = 0; n < rowsCount; n++)
{
model = new Tunnel.Model.Tunnel_file();
model.f_id = Convert.ToInt64(dt.Rows[n]["f_id"].ToString());
model.f_title = dt.Rows[n]["f_title"].ToString();
model.f_file = dt.Rows[n]["f_file"].ToString();
model.f_size = dt.Rows[n]["f_size"].ToString();
model.f_sort = Convert.ToInt32(dt.Rows[n]["f_sort"].ToString());
if (dt.Rows[n]["f_addtime"].ToString() != "")
{
model.f_addtime = DateTime.Parse(dt.Rows[n]["f_addtime"].ToString());
}
if (dt.Rows[n]["f_user"].ToString() != "")
{
model.f_user = int.Parse(dt.Rows[n]["f_user"].ToString());
}
model.f_juser = dt.Rows[n]["f_juser"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 上传文件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button1_Click(object sender, EventArgs e)
{
//获得所需参数
string strTitle = tb_Title.Text.Trim();
HttpPostedFile hpf = file1.PostedFile;
string strContent = tb_content.Text.Trim();
if (Convert.ToDouble(hpf.ContentLength) / 1024 / 1024 > 10)
{
Response.Write("<script>alert('附件大小不能大于10MB');</script>");
return;
}
else
{
CreateMdAndFilePaht(hpf);
}
//写入数据库
Tunnel.BLL.Tunnel_file rbll = new Tunnel.BLL.Tunnel_file();
Tunnel.Model.Tunnel_file model = new Tunnel.Model.Tunnel_file();
model.f_title = strTitle;
model.f_size = hpf.ContentLength.ToString();
model.f_file = filePaht;
model.f_addtime = DateTime.Now;
model.f_Content = strContent;
model.f_sort = 0;
model.f_user = ul.LoginID;
model.f_Ip = Tunnel.Common.Common.GetIp();
if (ul.GetUserBean(ul.LoginID) != null)
{
buMId = (int)ul.GetUserBean(ul.LoginID).m_id;
}
model.f_Bum = buMId;
int relt1 = -1;
relt1 = rbll.Add(model);
string str = "上传文件";
string url = "FShaRing_Manage.aspx";
if (relt1 > 0)
{
str += "成功！";
}
else
{
str += "失败！";
}
MessageBox(str, url);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Tunnel.Model.Tunnel_file GetModel(long f_id)
{
SqlParameter[] parameters =
{
new SqlParameter("@f_id", SqlDbType.BigInt)
};
parameters[0].Value = f_id;
Tunnel.Model.Tunnel_file model = new Tunnel.Model.Tunnel_file();
DataSet ds = DbHelperSQL.RunProcedure("Tunnel_file_GetModel", parameters, "ds");
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["f_id"].ToString() != "")
{
model.f_id = long.Parse(ds.Tables[0].Rows[0]["f_id"].ToString());
}
model.f_title = ds.Tables[0].Rows[0]["f_title"].ToString();
if (ds.Tables[0].Rows[0]["f_file"].ToString() != "")
{
model.f_file = ds.Tables[0].Rows[0]["f_file"].ToString();
}
model.f_size = ds.Tables[0].Rows[0]["f_size"].ToString();
model.f_sort = Convert.ToInt32(ds.Tables[0].Rows[0]["f_sort"].ToString());
if (ds.Tables[0].Rows[0]["f_addtime"].ToString() != "")
{
model.f_addtime = DateTime.Parse(ds.Tables[0].Rows[0]["f_addtime"].ToString());
}
if (ds.Tables[0].Rows[0]["f_user"].ToString() != "")
{
model.f_user = int.Parse(ds.Tables[0].Rows[0]["f_user"].ToString());
}
model.f_juser = ds.Tables[0].Rows[0]["f_juser"].ToString();
model.f_Content = ds.Tables[0].Rows[0]["f_content"].ToString();
if (!string.IsNullOrEmpty(ds.Tables[0].Rows[0]["f_Bum"].ToString()))
{
model.f_Bum = Convert.ToInt32(ds.Tables[0].Rows[0]["f_Bum"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Tunnel.Model.Tunnel_file model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Tunnel.Model.Tunnel_file model)
{
return(dal.Add(model));
}
