//// <summary>
/// 这里保存上传的文件到服务器上面
/// </summary>
/// <param name="file">上传文件实例,名称应该和前台页面上的上传控件name属性一致</param>
/// <returns></returns>
public ActionResult Order_PL(HttpPostedFileBase file)
{
retValue ret = new retValue();
ret.result = true;
if (file == null)
{
ret.result = false;
ret.reason = "请选择上传文件!";
}
else
{
PMS.Models.UserModel userModel = Session["UserModel"] as PMS.Models.UserModel;
int userid = userModel._ID;
Random r = new Random();
var fileExt = System.IO.Path.GetExtension(file.FileName).Substring(1);
var filename = DateTime.Now.ToString("yyyyMMddHHmmss") + r.Next(10000) + "." + fileExt;
var filepath = System.IO.Path.Combine(Server.MapPath("~/Images"), filename);
var savepath = "/Images/" + filename;
file.SaveAs(filepath);
BLL.OrderInfoBLL _bll = new OrderInfoBLL();
BLL.OrgInfoBLL _Org = new OrgInfoBLL();
DataTable dt = OpenFile(filepath);
//删除文件
FileInfo fileInfo = new FileInfo(filepath);
fileInfo.Delete();
if (dt == null || dt.Rows.Count == 0)
{
ret.result = false;
ret.reason = "Excel中没有数据";
}
else
{
int count = 0;
SqlHelp dbhelper = new SqlHelp();
SqlConnection conn = new SqlConnection(dbhelper.SqlConnectionString);
conn.Open();
using (SqlTransaction tran = conn.BeginTransaction())
{
try
{
foreach (DataRow item in dt.Rows)
{
int orgid = _Org.GetIDByName(item["OrgName"]._ToStrTrim());
if (orgid == 0)
{
ret.result = false;
ret.reason = "第" + (dt.Rows.IndexOf(item) + 1) + "行数据机构填写不正确";
break;
}
else if (string.IsNullOrEmpty(item["BKDH"]._ToStrTrim()))
{
ret.result = false;
ret.reason = "第" + (dt.Rows.IndexOf(item) + 1) + "行数据报刊代号不能为空"; break;
}
else if (item["OrderNum"]._ToInt32() <= 0)
{
ret.result = false;
ret.reason = "第" + (dt.Rows.IndexOf(item) + 1) + "行数据订购数必须大于0"; break;
}
else if (item["OrderMonths"]._ToInt32() <= 0)
{
ret.result = false;
ret.reason = "第" + (dt.Rows.IndexOf(item) + 1) + "行数据订购月数必须大于0"; break;
}
else if (string.IsNullOrEmpty(item["Indate"]._ToStrTrim()))
{
ret.result = false;
ret.reason = "第" + (dt.Rows.IndexOf(item) + 1) + "行数据订购起始日期不能为空"; break;
}
else if (string.IsNullOrEmpty(item["OrderNo"]._ToStrTrim()))
{
ret.result = false;
ret.reason = "第" + (dt.Rows.IndexOf(item) + 1) + "行数据订户单位编号不能为空"; break;
}
else
{
ret = _bll.Insert(item["BKDH"]._ToStrTrim(), item["OrderNum"]._ToInt32(), item["OrderMonths"]._ToInt32(), item["Indate"]._ToStrTrim(), userid._ToStr(),
0, item["OrderNo"]._ToStrTrim(), item["UnitName"]._ToStrTrim(), item["Address"]._ToStrTrim(), item["Name"]._ToStrTrim(), item["Phone"]._ToStrTrim(), orgid._ToStr(), tran, userid._ToStr());
count++;
if (!ret.result)
{
tran.Rollback();
return(Json(JsonConvert.SerializeObject(ret), JsonRequestBehavior.AllowGet));
}
}
}
if (!ret.result)
{
tran.Rollback();
}
else
{
tran.Commit();
ret.result = true;
ret.data = "导入成功";
}
}
catch (Exception ex)
{
ret.result = false;
ret.reason = ex.Message;
tran.Rollback();
}
}
conn.Close();
}
}
var js = JsonConvert.SerializeObject(ret);
return(Json(js, JsonRequestBehavior.AllowGet));
}
public ActionResult Order_AddEdits(string str)
{
retValue ret = new retValue();
PMS.Models.UserModel userModel = Session["UserModel"] as PMS.Models.UserModel;
int userid = userModel._ID;
BLL.OrderInfoBLL _BLL = new OrderInfoBLL();
JObject o = null;
if (!string.IsNullOrEmpty(str))
{
o = JObject.Parse(str);
string ID = o["ID"]._ToStrTrim();
string NGUID = o["NGUID"]._ToStrTrim();
string CostID = o["CostID"]._ToStrTrim();
string Month = o["Month"]._ToStrTrim();
string OrderNum = o["OrderNumber"]._ToStrTrim();
string PersonID = o["OrderPeople"]._ToStrTrim();
string Poster = o["Poster"]._ToStrTrim();
string BKDH = o["NewspaperName"]._ToStrTrim();
string FullPrice = o["FullPrice"]._ToStrTrim();
string MoneyPayed = o["Pay"]._ToStrTrim();
string test1 = o["test1"]._ToStrTrim();
if (string.IsNullOrEmpty(ID))
{
SqlHelp dbhelper = new SqlHelp();
SqlConnection conn = new SqlConnection(dbhelper.SqlConnectionString);
conn.Open();
using (SqlTransaction tran = conn.BeginTransaction())
{
try
{
ret = _BLL.Insert(tran, BKDH, PersonID._ToInt32(), OrderNum._ToInt32(), Month._ToInt32(),
test1, userid._ToStr(), Poster._ToInt32(), FullPrice._ToDecimal());
tran.Commit();
}
catch (Exception ex)
{
ret.result = false;
ret.reason = ex.Message;
tran.Rollback();
throw;
}
}
}
else
{
ret = _BLL.UpdateByPK(ID._ToInt32(), Month._ToInt32(), OrderNum._ToInt32(), BKDH,
PersonID._ToInt32(), userid, Poster._ToInt32(), test1, NGUID);
if (ret.result)
{
CostBLL costBLL = new CostBLL();
costBLL.UpdateByPK(CostID._ToInt32(), FullPrice._ToDecimal(), MoneyPayed._ToDecimal(), userid);
}
}
}
var js = JsonConvert.SerializeObject(ret);
return(Json(js, JsonRequestBehavior.AllowGet));
}