public SRUploadFile(HttpContext context, string fileKey, string fileType, string fileTitle, string fileFolder)
{
Context = context;
PostFile = context.Request.Files[fileKey];
FileType = fileType;
FileTitle = fileTitle;
FileFolder = fileFolder;
ExtTable.Add("image", "gif,jpg,jpeg,png,bmp");
ExtTable.Add("flash", "swf,flv");
ExtTable.Add("media", "swf,flv,mp3,wav,wma,wmv,mid,avi,mpg,asf,rm,rmvb");
ExtTable.Add("file", "doc,docx,xls,xlsx,ppt,pptx,htm,html,txt,zip,rar,gz,7z,bz2,pdf");
MaxSize = 4194304;
SetStatus(0, "初始状态");
IsCreatFolder = true;
}
/// <summary>
/// 根据PPID取得采购计划
/// </summary>
/// <param name="PPId">采购计划ID</param>
/// <returns></returns>
public PurchasePlanView GetPurchasePlanByPPId(int PPId)
{
try
{
StringBuilder sb = new StringBuilder();
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@PPId", PPId),
};
sb.Append(" SELECT * FROM dbo.PurchasePlan WHERE PPId=@PPId ");
sb.Append(" select * from dbo.ExtTable WHERE ContantId=@PPId");
var ds = SQLHelper.GetDataSet(sb.ToString(), parms);
var dt1 = ds.Tables[0];
var ExtDt = ds.Tables[1];
PurchasePlanView Res = new PurchasePlanView();
if (dt1.Rows.Count > 0)
{
var dr = dt1.Rows[0];
Res.PlanItem = new PurchasePlan()
{
ContantName = Convert.IsDBNull(dr["ContantName"]) ? "" : dr["ContantName"].ToString(),
ContantWay = Convert.IsDBNull(dr["ContantWay"]) ? "" : dr["ContantWay"].ToString(),
CreateDate = Convert.IsDBNull(dr["CreateDate"]) ? new DateTime(1900, 1, 1) : Convert.ToDateTime(dr["CreateDate"]),
EndDateTime = Convert.IsDBNull(dr["EndDateTime"]) ? new DateTime(1900, 1, 1) : Convert.ToDateTime(dr["EndDateTime"]),
HopePrice = Convert.IsDBNull(dr["HopePrice"]) ? 0 : Convert.ToDecimal(dr["HopePrice"]),
LastUpdateDate = Convert.IsDBNull(dr["LastUpdateDate"]) ? new DateTime(1900, 1, 1) : Convert.ToDateTime(dr["LastUpdateDate"]),
PName = Convert.IsDBNull(dr["PName"]) ? "" : dr["PName"].ToString(),
PPId = Convert.IsDBNull(dr["PPId"]) ? 0 : Convert.ToInt32(dr["PPId"]),
PurchaseName = Convert.IsDBNull(dr["PurchaseName"]) ? "" : dr["PurchaseName"].ToString(),
// PurchaseType = Convert.IsDBNull(dr["PurchaseType"]) ? "" : dr["PurchaseType"].ToString(),
Qty = Convert.IsDBNull(dr["Qty"]) ? 0 : Convert.ToInt32(dr["Qty"]),
RequestContant = Convert.IsDBNull(dr["RequestContant"]) ? "" : dr["RequestContant"].ToString(),
RequestManufactureArea = Convert.IsDBNull(dr["RequestManufactureArea"]) ? "" : dr["RequestManufactureArea"].ToString(),
RequestReceiveArea = Convert.IsDBNull(dr["RequestReceiveArea"]) ? "" : dr["RequestReceiveArea"].ToString(),
Spec = Convert.IsDBNull(dr["Spec"]) ? "" : dr["Spec"].ToString(),
State = Convert.IsDBNull(dr["State"]) ? "" : dr["State"].ToString(),
Title = Convert.IsDBNull(dr["Title"]) ? "" : dr["Title"].ToString(),
Unit = Convert.IsDBNull(dr["Unit"]) ? "" : dr["Unit"].ToString(),
PurchaseDetails = Convert.IsDBNull(dr["PurchaseDetails"]) ? "" : dr["PurchaseDetails"].ToString(),
};
}
List <ExtTable> ExtList = new List <ExtTable>();
for (int i = 0; i < ExtDt.Rows.Count; i++)
{
var dr = ExtDt.Rows[i];
ExtTable ExtItem = new ExtTable();
ExtItem.ExtId = Convert.IsDBNull(dr["ExtId"]) ? 0 : Convert.ToInt32(dr["ExtId"]);
ExtItem.ExtName = Convert.IsDBNull(dr["ExtName"]) ? "" : dr["ExtName"].ToString();
ExtItem.ExtValue = Convert.IsDBNull(dr["ExtValue"]) ? "" : dr["ExtValue"].ToString();
ExtItem.ContantId = Convert.IsDBNull(dr["ContantId"]) ? 0 : Convert.ToInt32(dr["ContantId"]);
ExtList.Add(ExtItem);
}
Res.ExtList = ExtList;
return(Res);
}
catch (Exception)
{
return(null);
}
}
