/// <summary>
///
/// </summary>
/// <param name="Uaptitude"></param>
/// <returns></returns>
public ActionResult UpDataUserAptitude(UserAptitude Uaptitude)
{
var ID = Request["ID"];
Acc_Account account = GAccount.GetAccountInfo();
HttpPostedFileBase file = Request.Files[0];
byte[] fileByte = new byte[0];
if (file.FileName != "")
{
Uaptitude.StrFileName = file.FileName.Substring(file.FileName.LastIndexOf('\\') + 1);
int fileLength = file.ContentLength;
if (fileLength != 0)
{
fileByte = new byte[fileLength];
file.InputStream.Read(fileByte, 0, fileLength);
}
}
string strErr = "";
if (UserAptitudeMan.UpdateNewUserAptitude(ID, Uaptitude, fileByte, ref strErr) == true)
{
ViewData["ID"] = ID;
ViewData["msg"] = "保存成功";
return(View("UpdateAptitude", Uaptitude));
}
else
{
ViewData["msg"] = "保存失败";
return(View("UpdateAptitude", Uaptitude));
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public ActionResult AptitudeUserGrid()
{
Acc_Account account = GAccount.GetAccountInfo();
string where = " and a.Unit = '" + account.UnitID + "'";
string strCurPage;
string strRowNum;
string UserName = Request["userName"].ToString();
if (Request["curpage"] != null)
{
strCurPage = Request["curpage"].ToString();
}
if (Request["rownum"] != null)
{
strRowNum = Request["rownum"].ToString();
}
else
{
strRowNum = "10";
}
if (UserName != "")
{
where += " and b.UserName like '%" + UserName + "%'";
}
UIDataTable udtTask = UserAptitudeMan.getNewAptitudeUserGrid(GFun.SafeToInt32(strRowNum), GFun.SafeToInt32(Request["curpage"]) - 1, where);
string strjson = GFun.Dt2Json("", udtTask.DtData);
strjson = strjson.Substring(1);
strjson = strjson.Substring(0, strjson.Length - 1);
string jsonData = "{ \"page\":" + GFun.SafeToInt32(Request["curpage"]) + ", \"total\": " + udtTask.IntTotalPages + ", \"records\": " + udtTask.IntRecords + ", \"rows\": ";
jsonData += strjson + "}";
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
public void DownLoad(string id)
{
string[] arrStr = id.Split('/');
string informNo = arrStr[0];
DataTable dtInfo = UserAptitudeMan.getNewFile(informNo);
if (dtInfo.Rows[0][0].ToString() != "")
{
byte[] bContent = (byte[])dtInfo.Rows[0]["FileInfo"];
Response.Clear();
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.UTF8;
// 添加头信息，为"文件下载/另存为"对话框指定默认文件名
Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode(dtInfo.Rows[0]["FileName"].ToString()));
//Response.BinaryWrite(bContent);
//Response.Flush();
//Response.End();
// 添加头信息，指定文件大小，让浏览器能够显示下载进度
Response.AddHeader("Content-Length", bContent.Length.ToString());
// 指定返回的是一个不能被客户端读取的流，必须被下载
Response.ContentType = "application/msword";
// 把文件流发送到客户端
Response.BinaryWrite((byte[])dtInfo.Rows[0]["FileInfo"]);
System.Web.HttpContext.Current.ApplicationInstance.CompleteRequest();
}
}
/// <summary>
///
/// </summary>
/// <param name="Uaptitude"></param>
/// <returns></returns>
public ActionResult InsertUserAptitude(UserAptitude Uaptitude)
{
Acc_Account account = GAccount.GetAccountInfo();
Uaptitude.StrCreateUser = account.UserID.ToString();
Uaptitude.StrCreateTime = DateTime.Now;
Uaptitude.StrValidate = "v";
Uaptitude.StrUnit = account.UnitID;
HttpPostedFileBase file = Request.Files[0];
byte[] fileByte = new byte[0];
if (file.FileName != "")
{
Uaptitude.StrFileName = file.FileName.Substring(file.FileName.LastIndexOf('\\') + 1);
int fileLength = file.ContentLength;
if (fileLength != 0)
{
fileByte = new byte[fileLength];
file.InputStream.Read(fileByte, 0, fileLength);
}
}
string strErr = "";
if (UserAptitudeMan.InsertNewUserAptitude(Uaptitude, fileByte, ref strErr) == true)
{
ViewData["msg"] = "保存成功";
return(View("AddAptitude", Uaptitude));
}
else
{
ViewData["msg"] = "保存失败";
return(View("AddAptitude", Uaptitude));
}
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult UpdateAptitude(string id)
{
UserAptitude Uaptitude = new UserAptitude();
Uaptitude = UserAptitudeMan.getNewUpdateUserAptitude(id);
ViewData["ID"] = id;
return(View(Uaptitude));
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public ActionResult AptitudeWarnGrid()
{
string where = "";
Acc_Account account = GAccount.GetAccountInfo();
where = " and a.Unit = '" + account.UnitID + "'";
string num = UserAptitudeMan.getNewAptitudeTime();
if (num == "")
{
where += " and DATEDIFF(MONTH,GETDATE(),a.CertificatDate) <= '2'";
}
else
{
where += " and DATEDIFF(MONTH,GETDATE(),a.CertificatDate) <= '" + num + "'";
}
string strCurPage;
string strRowNum;
string UserName = Request["userName"].ToString();
string BusinessType = Request["businessType"].ToString();
string TecoName = Request["tecoName"].ToString();
if (Request["curpage"] != null)
{
strCurPage = Request["curpage"].ToString();
}
if (Request["rownum"] != null)
{
strRowNum = Request["rownum"].ToString();
}
else
{
strRowNum = "10";
}
if (UserName != "")
{
where += " and a.UserName like '%" + UserName + "%'";
}
if (BusinessType != "")
{
where += " and a.BusinessType = '" + BusinessType + "'";
}
if (TecoName != "")
{
where += " and a.TecoName like '%" + TecoName + "%'";
}
UIDataTable udtTask = UserAptitudeMan.getNewAptitudeGrid(GFun.SafeToInt32(strRowNum), GFun.SafeToInt32(Request["curpage"]) - 1, where, account.UnitID);
string strjson = GFun.Dt2Json("", udtTask.DtData);
strjson = strjson.Substring(1);
strjson = strjson.Substring(0, strjson.Length - 1);
string jsonData = "{ \"page\":" + GFun.SafeToInt32(Request["curpage"]) + ", \"total\": " + udtTask.IntTotalPages + ", \"records\": " + udtTask.IntRecords + ", \"rows\": ";
jsonData += strjson + "}";
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
/// <summary>
///
/// </summary>
/// <param name="Lend"></param>
/// <returns></returns>
public ActionResult ReturnLendAptitude(UCertificatLend Lend)
{
string strErr = "";
if (UserAptitudeMan.UpdateNewLendAptitude(Lend, ref strErr) == true)
{
return(Json(new { success = "true", Msg = "保存成功" }));
}
else
{
return(Json(new { success = "false", Msg = "保存失败" + "/" + strErr }));
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public ActionResult deleteFile()
{
var id = Request["data1"];
string[] arr = id.Split('/');
string strErr = "";
if (UserAptitudeMan.deleteNewFile(arr[0], ref strErr) == true)
{
return(Json(new { success = "true", Msg = "删除成功" }));
}
else
{
return(Json(new { success = "false", Msg = "删除出错" + "/" + strErr }));
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public ActionResult GetFile()
{
var id = Request["data1"];
DataTable dt = UserAptitudeMan.getNewFile(id);
string ID = "";
string name = "";
string file = "";
if (dt.Rows.Count > 0)
{
ID = dt.Rows[0]["ID"].ToString();
name = dt.Rows[0]["FileName"].ToString();
file = dt.Rows[0]["FileInfo"].ToString();
}
return(Json(new { success = "true", id = ID, Name = name, File = file }));
}
/// <summary>
///
/// </summary>
/// <param name="Lend"></param>
/// <returns></returns>
public ActionResult InsertLendAptitude(UCertificatLend Lend)
{
Acc_Account account = GAccount.GetAccountInfo();
Lend.StrCreateUser = account.UserID.ToString();
Lend.StrCreateTime = DateTime.Now;
Lend.StrValidate = "v";
string strErr = "";
if (UserAptitudeMan.InsertNewLendAptitude(Lend, ref strErr) == true)
{
return(Json(new { success = "true", Msg = "保存成功" }));
}
else
{
return(Json(new { success = "false", Msg = "保存失败" + "/" + strErr }));
}
}
