/// <summary>
/// 添加附件
/// </summary>
/// <param name="BusinessID"></param>
/// <param name="FileName"></param>
/// <param name="FileUrl"></param>
/// <param name="fileStream"></param>
private void AddAttachments(Guid BusinessID, string FileName, string FileUrl, FileStream fileStream)
{
string _Size = string.Empty;
if (fileStream.Length > 1024 * 1024)
{
_Size = (fileStream.Length / (1024 * 1024)).ToString("D2") + " M";
}
else
{
_Size = (fileStream.Length / (1024)).ToString("D2") + " KB";
}
B_Attachment Att = new B_Attachment()
{
BusinessID = BusinessID,
FileName = FileName,
Url = FileUrl,
BusinessType = "系统生成Excel",
CreateTime = DateTime.Now,
CreatorName = "SystemTargetPlan",
IsDeleted = false,
Size = _Size
};
//判断是否存在
var AttList = B_AttachmentOperator.Instance.GetAttachmentList(BusinessID, "系统生成Excel").ToList();
if (AttList != null && AttList.Count > 0)
{
var UAtt = AttList.Where(A => A.FileName == FileName).FirstOrDefault();
if (UAtt != null)
{
UAtt.BusinessID = BusinessID;
UAtt.FileName = FileName;
UAtt.Url = FileUrl;
UAtt.BusinessType = "系统生成Excel";
UAtt.CreateTime = DateTime.Now;
UAtt.CreatorName = "SystemTargetPlan";
UAtt.IsDeleted = false;
UAtt.Size = _Size;
B_AttachmentOperator.Instance.UpdateAttachment(UAtt); // 更新
}
else
{
B_AttachmentOperator.Instance.AddAttachment(Att);
}
}
else
{
B_AttachmentOperator.Instance.AddAttachment(Att);
}
}
public static string PrepareOrderAttrImg(string sid)
{
string r = "";
StringBuilder hstr = new StringBuilder();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
Sys_Domain sd = sdb.Query(" and dtype='p'");
string zt = bosb.QueryOrderStateImg(sid);
B_Attachment ba = bmib.Query(" and sid='" + sid + "'");
CB_OrderState cos = cbsb.Query("and sid='" + sid + "'");
hstr.Append("<table style='border:none; width:100%'> ");
hstr.AppendFormat("<tr><td align='center' height='40'><strong>状态：</strong></td><td align='center'><img src='{0}'></td></tr>", zt);
hstr.AppendFormat("<tr><td align='center'height='40'><strong>日志：</strong></td><td align='center'><img src='" + sd.url + "/Image/opeimage/makep.png' id='{0}' onclick='ShowLogs(this.id)' style='cursor:pointer'/></td></tr>", sid);
if (ba != null)
{
hstr.AppendFormat("<tr><td align='center'height='40'><strong>附件：</strong></td><td align='center'><img src='" + sd.url + "/Image/opeimage/zip.gif' id='{0}' onclick='ShowAttachment(this.id)'style='cursor:pointer'/></td></tr>", sid);
}
if (cos != null)
{
if (cos.iproduce > 0)
{
hstr.AppendFormat("<tr><td align='center'height='40'><strong>工单：</strong></td><td align='center'><img src='" + sd.url + "/Image/opeimage/has.png' id='{0}' style='cursor:pointer'/></td></tr>", sid);
}
else
{
hstr.AppendFormat("<tr><td align='center'height='40'><strong>工单：</strong></td><td align='center'><img src='" + sd.url + "/Image/opeimage/cancel.png' id='{0}' style='cursor:pointer'/></td></tr>", sid);
}
if (cos.iwjbh > 0)
{
hstr.AppendFormat("<tr><td align='center'height='40'><strong>备货：</strong></td><td align='center'><img src='" + sd.url + "/Image/opeimage/has.png' id='{0}' style='cursor:pointer'/></td></tr>", sid);
}
else
{
hstr.AppendFormat("<tr><td align='center'height='40'><strong>备货：</strong></td><td align='center'><img src='" + sd.url + "/Image/opeimage/cancel.png' id='{0}' style='cursor:pointer'/></td></tr>", sid);
}
}
hstr.Append("</table>");
r = hstr.ToString();
}
else
{
r = iv.badstr;
}
return(r);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["sid"] != null)
{
string filePath = "";
string fileName = "";
string sid = Request.QueryString["sid"].ToString();
string otype = Request.QueryString["otype"].ToString();
string ftype = Request.QueryString["ftype"].ToString();
bool urlencode = true;
string brower = Request.Browser.Browser;
if (brower == "Firefox")
{
urlencode = false;
}
#region//附件
if (otype == "")
{
if (ftype == "a")
{
B_Attachment ba = bmib.Query(" and id=" + sid + "");
if (ba != null)
{
filePath = Server.MapPath(ba.furl);
fileName = ba.fname;
}
}
if (ftype == "d")
{
B_DesignPlan ba = bdpb.Query(" and id=" + sid + "");
if (ba != null)
{
filePath = Server.MapPath(ba.durl);
fileName = ba.dname;
}
}
}
#endregion
#region //木门单下载
#endregion
#region //木作单下载
if (otype == "mz")
{
if (ftype == "rplan")
{
B_MzRequstDesign bp = bmrdpb.Query(" and id=" + sid + "");
if (bp != null)
{
filePath = Server.MapPath(bp.url);
fileName = bp.pname;
}
}
if (ftype == "plan")
{
B_MzDesignPlan bp = bmdpb.Query(" and id=" + sid + "");
if (bp != null)
{
filePath = Server.MapPath(bp.purl);
fileName = bp.pname;
}
}
if (ftype == "bj")
{
B_MzPriceFile bp = bmpfb.Query(" and id=" + sid + "");
if (bp != null)
{
filePath = Server.MapPath(bp.furl);
fileName = bp.fname;
}
}
}
#endregion
#region//反馈单下载
if (otype == "fk")
{
if (ftype == "bj")
{
B_AfterPriceFile bp = bapfb.Query(" and id=" + sid + "");
if (bp != null)
{
filePath = Server.MapPath(bp.furl);
fileName = bp.fname;
}
}
}
#endregion
if (filePath != "" && fileName != "")
{
Downfiles(filePath, fileName, urlencode);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string r = "", sid = "", gsid = "", fname = "", ftype = "";
SessionUserValidate iv = SysValidateBll.ValidateSession();
B_AttachmentBll bmib = new B_AttachmentBll();
if (iv.f)
{
HttpFileCollection files = Request.Files;
if (Request.QueryString["sid"] != null)
{
sid = Request.QueryString["sid"];
}
if (Request.QueryString["gsid"] != null)
{
gsid = Request.QueryString["gsid"];
}
if (Request.QueryString["fname"] != null)
{
fname = Request.QueryString["fname"];
}
if (Request.QueryString["ftype"] != null)
{
ftype = Request.QueryString["ftype"];
}
string newname = DateTime.Now.ToString("yyyyMMddhhmmssfff");
UpFile uf = new UpFile();
ArrayList efile = new ArrayList();
B_Attachment spi = new B_Attachment();
string url = "/UpFile/Attachment/";
string ur = uf.UpFiles(files[0], newname, url, 102400000);
if (ur.Length > 1)
{
string xname = uf.GetFileExName(files[0]);
spi.sid = sid;
spi.gsid = gsid;
spi.maker = iv.u.ename;
spi.fname = fname + xname;
spi.furl = url + ur;
spi.ftype = ftype;
spi.cdate = DateTime.Now.ToString();
if (bmib.Add(spi) > 0)
{
r = "S";
}
else
{
r = "F";
}
}
else
{
r = ur;
}
}
else
{
r = iv.badstr;
}
Response.Write("{ msg:'" + r + "'}");
Response.End();
}
public static string OrderAttrImg(string sid)
{
string r = "";
StringBuilder hstr = new StringBuilder();
SessionUserValidate iv = SysValidateBll.ValidateSession();
if (iv.f)
{
Sys_Domain sd = sdb.Query(" and dtype='p'");
string zt = bosb.QueryOrderStateImg(sid);
B_Attachment ba = bmib.Query(" and sid='" + sid + "'");
CB_OrderState cos = cbsb.Query("and sid='" + sid + "'");
CB_OrderProduceType ct = coptb.Query("and sid='" + sid + "'");
B_FeedBackImg bfi = bfbib.Query(" and sid='" + sid + "'");
B_DesignPlan bdp = bdpb.Query(" and osid='" + sid + "' and dtype='0'");
B_DesignPlan bdpt = bdpb.Query(" and osid='" + sid + "' and dtype='1'");
hstr.Append("<table style='border:none; width:100%'> ");
hstr.AppendFormat("<tr><td align='center' height='40'><strong>状态：</strong></td><td align='center'><img src='{0}'></td></tr>", zt);
hstr.AppendFormat("<tr><td align='center'height='40'><strong>日志：</strong></td><td align='center'><img src='" + sd.url + "/Image/opeimage/makep.png' id='{0}' onclick='ShowLogs(this.id)' style='cursor:pointer'/></td></tr>", sid);
if (ba != null)
{
hstr.AppendFormat("<tr><td align='center'height='40'><strong>附件：</strong></td><td align='center'><img src='" + sd.url + "/Image/opeimage/zip.gif' id='{0}' onclick='ShowAttachment(this.id)'style='cursor:pointer'/></td></tr>", sid);
}
if (bdp != null)
{
hstr.AppendFormat("<tr><td align='center'height='40'><strong>方案：</strong></td><td align='center'><img src='" + sd.url + "/Image/opeimage/design.gif' id='{0}' onclick='ShowDesign(this.id,0)'style='cursor:pointer'/></td></tr>", sid);
}
if (bdpt != null)
{
hstr.AppendFormat("<tr><td align='center'height='40'><strong>二次方案：</strong></td><td align='center'><img src='" + sd.url + "/Image/opeimage/design.gif' id='{0}' onclick='ShowDesign(this.id,1)'style='cursor:pointer'/></td></tr>", sid);
}
if (bfi != null)
{
hstr.AppendFormat("<tr><td align='center'height='40'><strong>售后：</strong></td><td align='center'><img src='" + sd.url + "/Image/opeimage/afterimg.gif' id='{0}' onclick='ShowAfterImg()'style='cursor:pointer'/></td></tr>", sid);
}
if (ct != null)
{
if (ct.gytype == "线上")
{
hstr.AppendFormat("<tr><td align='center'height='40'><strong>生产：</strong></td><td align='center'><img src='" + sd.url + "/Image/opeimage/online.gif' style='cursor:pointer'/></td></tr>");
}
if (ct.gytype == "线下")
{
hstr.AppendFormat("<tr><td align='center'height='40'><strong>生产：</strong></td><td align='center'><img src='" + sd.url + "/Image/opeimage/offline.gif' style='cursor:pointer'/></td></tr>");
}
}
if (cos != null)
{
if (cos.inewpp > 0)
{
hstr.AppendFormat("<tr><td align='center'height='40'><strong>新报价：</strong></td><td align='center'><img src='" + sd.url + "/Image/opeimage/nbj.png' id='{0}' style='cursor:pointer'/></td></tr>", sid);
}
if (cos.ipdraw == 1)
{
hstr.AppendFormat("<tr><td align='center'height='40'><strong>绘图中：</strong></td><td align='center'><img src='" + sd.url + "/Image/opeimage/drawing.png' id='{0}' style='cursor:pointer'/></td></tr>", sid);
}
if (cos.ipdraw == 2)
{
hstr.AppendFormat("<tr><td align='center'height='40'><strong>已绘图：</strong></td><td align='center'><img src='" + sd.url + "/Image/opeimage/drawed.png' id='{0}' onclick='ShowDrawImage(this.id)'style='cursor:pointer'/></td></tr>", sid);
}
if (cos.imeasure == 1)
{
hstr.AppendFormat("<tr><td align='center'height='40'><strong>测量中：</strong></td><td align='center'><img src='" + sd.url + "/Image/opeimage/measuring.png' id='{0}' style='cursor:pointer'/></td></tr>", sid);
}
if (cos.imeasure == 2)
{
hstr.AppendFormat("<tr><td align='center'height='40'><strong>已测量：</strong></td><td align='center'><img src='" + sd.url + "/Image/opeimage/measured.png' id='{0}' style='cursor:pointer'/></td></tr>", sid);
}
}
hstr.Append("</table>");
r = hstr.ToString();
}
else
{
r = iv.badstr;
}
return(r);
}
public void ProcessRequest(HttpContext context)
{
string r = "", sid = "", gsid = "", fname = "", ftype = "";
SessionUserValidate iv = SysValidateBll.ValidateSession();
B_AttachmentBll bmdpb = new B_AttachmentBll();
B_TempUpFileBll btufb = new B_TempUpFileBll();
if (iv.f)
{
string rfname = context.Request["fileName"].ToString();
string pfname = context.Request["partName"].ToString();
HttpFileCollection files = context.Request.Files;
if (context.Request.QueryString["sid"] != null)
{
sid = context.Request.QueryString["sid"];
}
if (context.Request.QueryString["gsid"] != null)
{
gsid = context.Request.QueryString["gsid"];
}
if (context.Request.QueryString["fname"] != null)
{
fname = context.Request.QueryString["fname"];
}
if (context.Request.QueryString["ftype"] != null)
{
ftype = context.Request.QueryString["ftype"];
}
string newname = DateTime.Now.ToString("yyyyMMddhhmmssfff");
UpFile uf = new UpFile();
ArrayList efile = new ArrayList();
B_Attachment spi = new B_Attachment();
HttpPostedFile file = files[0];
if (sid != "")
{
string[] f = pfname.Split('-');
if (f[1] == "0")
{
try
{
List <B_TempUpFile> lufp = btufb.QueryList("and fname like '" + rfname + "' and sid='" + sid + "' order by fdate asc");
if (lufp != null)
{
foreach (B_TempUpFile u in lufp)
{
File.Delete(u.furl);
}
btufb.Delete(" and fname = '" + rfname + "' and sid='" + sid + "' ");
}
}
catch (Exception e)
{
Log4.WriteLog(e.ToString());
}
}
if (btufb.Exists(" and sid='" + sid + "' and fpname='" + pfname + "'"))
{
}
else
{
string url = "/UpFile/Attachment/Temp";
string durl = "/UpFile/Attachment/";
string temSavePath = context.Server.MapPath(url);
string SavePath = context.Server.MapPath(durl);
string saveFileName = String.Format("{0}{1}", DateTime.Now.ToString("yyyyMMddhhmmssffff"), Path.GetExtension(rfname));//保存文件名称
string fileName = String.Format(@"{0}\{1}", temSavePath, saveFileName);
string sfname = SavePath + "/" + newname + Path.GetExtension(rfname);
string xsfname = durl + "/" + newname + Path.GetExtension(rfname);
B_TempUpFile btuf = new B_TempUpFile();
btuf.sid = sid;
btuf.fname = rfname;
btuf.fover = 0;
btuf.fpname = pfname;
btuf.fsize = file.ContentLength;
btuf.furl = fileName;
btufb.Add(btuf);
try
{
if (System.IO.File.Exists(fileName))
{
File.Delete(fileName);
}
file.SaveAs(fileName);
if (GetFileSize(fileName) != file.ContentLength)
{
r = "F";
}
else
{
btufb.Add(btuf);
}
}
catch
{
r = "F";
}
if (r != "F")
{
btufb.UpOver(" and sid='" + sid + "' and fpname='" + pfname + "'");
if (btufb.Exists(" and fname like '" + rfname + "%' and fsize<1000000 and sid='" + sid + "'"))
{
try
{
List <B_TempUpFile> lufp = btufb.QueryList("and fname like '" + rfname + "' and sid='" + sid + "' order by fdate asc");
if (lufp != null)
{
System.IO.FileStream fileStram = File.Open(sfname, FileMode.Create, FileAccess.Write);
foreach (B_TempUpFile u in lufp)
{
FileStream save = new FileStream(u.furl, FileMode.Open, FileAccess.Read);
byte[] bt = new byte[1024];
int count = -1;
while ((count = save.Read(bt, 0, bt.Length)) > 0)
{
fileStram.Write(bt, 0, count);
}
save.Close();
save.Dispose();
}
fileStram.Close();
fileStram.Dispose();
spi.sid = sid;
spi.gsid = gsid;
spi.maker = iv.u.ename;
spi.fname = fname + Path.GetExtension(rfname);
spi.furl = xsfname;
spi.ftype = ftype;
spi.cdate = DateTime.Now.ToString();
if (bmdpb.Add(spi) > 0)
{
r = "S";
}
else
{
r = "F";
}
foreach (B_TempUpFile u in lufp)
{
File.Delete(u.furl);
}
btufb.Delete(" and fname = '" + rfname + "' and sid='" + sid + "' ");
}
}
catch (Exception e)
{
Log4.WriteLog(e.ToString());
}
}
}
}
}
}
else
{
r = iv.badstr;
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
HttpPostedFile file = context.Request.Files["FileData"];
string action = context.Request["action"];
string BizID = context.Request["BusinessID"];
string[] actions = action.Split(new char[] { '|' });
string filePath = "Attachments\\" + WebHelper.DateTimeNow.ToString("yyyy_MM") + "\\";
//string uploadpath = context.Server.MapPath(filePath);
string uploadpath = Path.Combine(UploadFilePath, filePath);
if (file != null)
{
try
{
if (!Directory.Exists(uploadpath))
{
Directory.CreateDirectory(uploadpath);
}
B_Attachment _attachment = new B_Attachment();
_attachment.CreatorName = "System"; // WebHelper.GetCurrentUser().DisplayName; 当前上传附件的人，记录下来
Guid ID = B_AttachmentOperator.Instance.AddAttachment(_attachment);
string filename = ID + Path.GetExtension(file.FileName);
_attachment.ID = ID;
_attachment.BusinessType = action;
if (actions.Count() > 1)
{
_attachment.BusinessType = actions[0];
if (string.IsNullOrEmpty(actions[1]))
{
_attachment.BusinessID = Guid.Empty;
}
else
{
_attachment.BusinessID = Guid.Parse(actions[1]);
}
}
if (_attachment.BusinessID == Guid.Empty && !string.IsNullOrEmpty(BizID))
{
_attachment.BusinessID = Guid.Parse(BizID);
}
_attachment.FileName = file.FileName;
_attachment.Url = filePath + filename;
if (file.ContentLength > 1024 * 1024)
{
_attachment.Size = (file.ContentLength / (1024 * 1024)).ToString("D2") + " M";
}
else
{
_attachment.Size = (file.ContentLength / (1024)).ToString("D2") + " KB";
}
file.SaveAs(uploadpath + filename);
context.Response.Write(filePath + filename);
B_AttachmentOperator.Instance.UpdateAttachment(_attachment);
string response = "{"
+ string.Format("ID:\"{0}\",CreatorName:\"{1}\",CreateTime:\"{2}\",Url:\"{3}\",Size:\"{4}\",FileName:\"{5}\""
, new string[] {
_attachment.ID.ToString(),
_attachment.CreatorName,
_attachment.CreateTime.ToShortDateString(),
HttpUtility.UrlEncode(_attachment.Url),
_attachment.Size,
_attachment.FileName
})
+ "}";
response = Encoding.GetEncoding("GB2312").GetString(Encoding.Default.GetBytes(response));
context.Response.Write(response);
}
catch (Exception exp)
{
context.Response.Write("Faild:" + exp.Message);
}
}
else
{
context.Response.Write("Faild:Empty file.");
}
}