protected void btnDownload_Click(object sender, EventArgs e)
{
int id = GetQueryIntValue("id");
TSM.Model.pms_Attachment modelpms_Attachment = m_bllpms_Attachment.GetModel1(id);
if (modelpms_Attachment == null)
{
// 参数错误，首先弹出Alert对话框然后关闭弹出窗口
Alert.Show("营销员没有上传过附件!");
return;
}
string shortName = modelpms_Attachment.AttachmentName;
shortName = shortName.Remove(0, 19); //去掉字符串的前19个字符
string filename = Server.MapPath("~/upload/attachment/" + modelpms_Attachment.AttachmentName);
Response.Clear();
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "application/octet-stream";
Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(shortName, Encoding.UTF8));
Response.TransmitFile(filename);
Response.End();
}
private void SaveAttachment()
{
if (filePhoto.HasFile)
{
//获取当前登录用户uid
var cookie = HttpContext.Current.Request.Cookies[FormsAuthentication.FormsCookieName];
var ticket = FormsAuthentication.Decrypt(cookie.Value);
string uid = ticket.UserData;
//获取附件名
string fileName = filePhoto.ShortFileName;
TSM.Model.pms_Attachment modelpms_Attachment = new TSM.Model.pms_Attachment();
TSM.BLL.pms_Attachment m_bllpms_Attachment = new TSM.BLL.pms_Attachment();
fileName = fileName.Replace(":", "_").Replace(" ", "_").Replace("\\", "_").Replace("/", "_");
fileName = DateTime.Now.Ticks.ToString() + "_" + fileName;
filePhoto.SaveAs(Server.MapPath("~/upload/attachment/" + fileName));
modelpms_Attachment.ProductInfoID = m_bllpms_Product_Info.GetMaxId() - 1;
modelpms_Attachment.UploadUid = int.Parse(uid);
modelpms_Attachment.AttachmentName = fileName;
modelpms_Attachment.AttachmentAddr = "~/upload/attachment/" + fileName;
modelpms_Attachment.UploadPermission = "营销员";
modelpms_Attachment.UploadTime = DateTime.Now.Date;
m_bllpms_Attachment.Add(modelpms_Attachment);
// 清空文件上传组件
filePhoto.Reset();
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(TSM.Model.pms_Attachment model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update pms_Attachment set ");
strSql.Append("ProductInfoID=@ProductInfoID,");
strSql.Append("UploadUid=@UploadUid,");
strSql.Append("AttachmentName=@AttachmentName,");
strSql.Append("AttachmentAddr=@AttachmentAddr,");
strSql.Append("UploadPermission=@UploadPermission,");
strSql.Append("UploadTime=@UploadTime");
strSql.Append(" where AttachmentID=@AttachmentID ");
SqlParameter[] parameters =
{
new SqlParameter("@AttachmentID", SqlDbType.Int, 4),
new SqlParameter("@ProductInfoID", SqlDbType.Int, 4),
new SqlParameter("@UploadUid", SqlDbType.Int, 4),
new SqlParameter("@AttachmentName", SqlDbType.VarChar, 64),
new SqlParameter("@AttachmentAddr", SqlDbType.VarChar, 64),
new SqlParameter("@UploadPermission", SqlDbType.VarChar, 64),
new SqlParameter("@UploadTime", SqlDbType.DateTime)
};
parameters[0].Value = model.AttachmentID;
parameters[1].Value = model.ProductInfoID;
parameters[2].Value = model.UploadUid;
parameters[3].Value = model.AttachmentName;
parameters[4].Value = model.AttachmentAddr;
parameters[5].Value = model.UploadPermission;
parameters[6].Value = model.UploadTime;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
private void SaveAttachment()
{
if (fileUpload.HasFile)
{
int id = GetQueryIntValue("id");
//获取当前登录用户uid
var cookie = HttpContext.Current.Request.Cookies[FormsAuthentication.FormsCookieName];
var ticket = FormsAuthentication.Decrypt(cookie.Value);
string uid = ticket.UserData;
//保存文件到服务器
string fileName = fileUpload.ShortFileName;
fileName = fileName.Replace(":", "_").Replace(" ", "_").Replace("\\", "_").Replace("/", "_");
fileName = DateTime.Now.Ticks.ToString() + "_" + fileName;
fileUpload.SaveAs(Server.MapPath("~/upload/attachment/" + fileName));
TSM.Model.pms_Attachment modelpms_Attachment = new TSM.Model.pms_Attachment();
TSM.BLL.pms_Attachment m_bllpms_Attachment = new TSM.BLL.pms_Attachment();
TSM.Model.pms_Attachment modelpms_Attachment_1 = m_bllpms_Attachment.GetModel1(id);
if (modelpms_Attachment_1 == null)
{
// 为空则ADD
modelpms_Attachment.ProductInfoID = GetQueryIntValue("id");
modelpms_Attachment.UploadUid = int.Parse(uid);
modelpms_Attachment.AttachmentName = fileName;
modelpms_Attachment.AttachmentAddr = "~/upload/attachment/" + fileName;
modelpms_Attachment.UploadPermission = "营销员";
modelpms_Attachment.UploadTime = DateTime.Now.Date;
m_bllpms_Attachment.Add(modelpms_Attachment);
}
else
{
//非空则UPDATE
modelpms_Attachment.AttachmentID = modelpms_Attachment_1.AttachmentID;
modelpms_Attachment.ProductInfoID = GetQueryIntValue("id");
modelpms_Attachment.UploadUid = int.Parse(uid);
modelpms_Attachment.AttachmentName = fileName;
modelpms_Attachment.AttachmentAddr = "~/upload/attachment/" + fileName;
modelpms_Attachment.UploadPermission = "营销员";
modelpms_Attachment.UploadTime = DateTime.Now.Date;
m_bllpms_Attachment.Update(modelpms_Attachment);
}
// 清空文件上传组件
fileUpload.Reset();
}
}
/// <summary>
/// 得到一个对象实体,通过ProductInfoID,取工艺员上传附件
/// </summary>
public TSM.Model.pms_Attachment GetModel2(int ProductInfoID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 AttachmentID,ProductInfoID,UploadUid,AttachmentName,AttachmentAddr,UploadPermission,UploadTime from pms_Attachment ");
strSql.Append(" where UploadPermission='工艺员' and ProductInfoID=@ProductInfoID ");
SqlParameter[] parameters =
{
new SqlParameter("@ProductInfoID", SqlDbType.Int, 4)
};
parameters[0].Value = ProductInfoID;
TSM.Model.pms_Attachment model = new TSM.Model.pms_Attachment();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["AttachmentID"].ToString() != "")
{
model.AttachmentID = int.Parse(ds.Tables[0].Rows[0]["AttachmentID"].ToString());
}
if (ds.Tables[0].Rows[0]["ProductInfoID"].ToString() != "")
{
model.ProductInfoID = int.Parse(ds.Tables[0].Rows[0]["ProductInfoID"].ToString());
}
if (ds.Tables[0].Rows[0]["UploadUid"].ToString() != "")
{
model.UploadUid = int.Parse(ds.Tables[0].Rows[0]["UploadUid"].ToString());
}
model.AttachmentName = ds.Tables[0].Rows[0]["AttachmentName"].ToString();
model.AttachmentAddr = ds.Tables[0].Rows[0]["AttachmentAddr"].ToString();
model.UploadPermission = ds.Tables[0].Rows[0]["UploadPermission"].ToString();
if (ds.Tables[0].Rows[0]["UploadTime"].ToString() != "")
{
model.UploadTime = DateTime.Parse(ds.Tables[0].Rows[0]["UploadTime"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(TSM.Model.pms_Attachment model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into pms_Attachment(");
strSql.Append("ProductInfoID,UploadUid,AttachmentName,AttachmentAddr,UploadPermission,UploadTime)");
strSql.Append(" values (");
strSql.Append("@ProductInfoID,@UploadUid,@AttachmentName,@AttachmentAddr,@UploadPermission,@UploadTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ProductInfoID", SqlDbType.Int, 4),
new SqlParameter("@UploadUid", SqlDbType.Int, 4),
new SqlParameter("@AttachmentName", SqlDbType.VarChar, 64),
new SqlParameter("@AttachmentAddr", SqlDbType.VarChar, 64),
new SqlParameter("@UploadPermission", SqlDbType.VarChar, 64),
new SqlParameter("@UploadTime", SqlDbType.DateTime)
};
parameters[0].Value = model.ProductInfoID;
parameters[1].Value = model.UploadUid;
parameters[2].Value = model.AttachmentName;
parameters[3].Value = model.AttachmentAddr;
parameters[4].Value = model.UploadPermission;
parameters[5].Value = model.UploadTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
