/// <summary>
/// 保存数据
/// </summary>
private void DataSave()
{
#region 得到 post 提交的数据
int dataLength = Request.Form.Count + 3;
string[] filedName = new string[dataLength];
object[] filedValue = new object[dataLength];
for (int i = 0; i < Request.Form.Count; i++)
{
string controlName = Request.Form.Keys[i];
filedName[i] = controlName;
filedValue[i] = Request.Form[controlName].Trim();//添加去除空格
}
if (Request.Files.Count > 0 && Request.Files[0].FileName != "")
{
//保存二进制数据
filedName[dataLength - 3] = Request.Files.Keys[0];
HttpPostedFile postedFile = Request.Files[0];
byte[] buffer = new byte[postedFile.ContentLength];
postedFile.InputStream.Read(buffer, 0, postedFile.ContentLength);
postedFile.InputStream.Close();
filedValue[dataLength - 3] = buffer;
//保存文件格式
filedName[dataLength - 2] = "imgFormat";
filedValue[dataLength - 2] = postedFile.FileName.Remove(0, postedFile.FileName.LastIndexOf('.'));
}
#endregion
string config_id = "1005";
GetFormInfo getfrom = new GetFormInfo();
string message = "";
//得到操作类型 Detail、Update、Add
string operate_Type = "Update";
string desc = "";
string pk_Field = "ID";
string pk_Value = GetID();
string sqlWhere = " where " + pk_Field + " = '" + pk_Value + "'";
message = getfrom.DataSave(config_id, filedName, filedValue, sqlWhere);
desc = " ID 为 " + pk_Value;
#region 操作记录
string IP = GetSystemProperties.GetIP();
string Mac = GetSystemProperties.GetMacBySendARP(IP);
string userID = getSession("userID");
string userName = getSession("userName");
LogInformation.OperationLog(userID, userName, operate_Type, config_id, desc, IP, Mac);
#endregion
Response.Write(message);
Response.End();
}
/// <summary>
/// 导入保存数据
/// </summary>
private void ImportSave()
{
string message = "";
DataTable dt = SaveToServer();
dt = RemoveNullRow(dt);
if (ConfigurationManager.AppSettings["ImportRemoveDuplicate"].ToString() == "true")
{
GetFormInfo getF = new GetFormInfo();
string[] strCK = getF.ImportCheckDuplicate(Request.Form["config_Id"].ToString(), dt);
#region 导入有重复，弹出对话框
if (strCK[0] != null)
{
SQLHelper sqlh = new SQLHelper();
DataSet dsCK = sqlh.ExecuteSQLDataSet(strCK[0]);
//若果有重复数据
if (dsCK.Tables[0].Rows.Count > 0)
{
string rowNum = "";
for (int i = 0; i < dsCK.Tables[0].Rows.Count; i++)
{
rowNum += (i + 1).ToString();
if (i + 1 < dsCK.Tables[0].Rows.Count)
{
rowNum += "、";
}
}
message = " 导入Excel中，有 " + dsCK.Tables[0].Rows.Count + " 行重复数据，<br/>行号：" + rowNum + "! ";
Session["ExcelData"] = dt;
//将重复的行号、删除重复记录的sql保存到session中
strCK[0] = rowNum;
Session["ExcelSql"] = strCK;
Response.Clear();
Response.Write(message);
Response.End();
return;
}
}
#endregion
}
message = ImportData(dt);
Response.Clear();
Response.Write(message);
Response.End();
}
/// <summary>
/// 导入数据
/// </summary>
/// <param name="dt">需要导入数据表</param>
/// <returns>提示信息</returns>
private string ImportData(DataTable dt)
{
GetFormInfo getF = new GetFormInfo();
int executeRowNum = getF.ImportExcelData(Request.Form["config_Id"].ToString(), dt);
string message = " 成功导入数据 " + executeRowNum.ToString() + " 行! ";
#region 操作记录
string IP = GetSystemProperties.GetIP();
string Mac = GetSystemProperties.GetMacBySendARP(IP);
string userID = getSession("userID");
string userName = getSession("userName");
LogInformation.OperationLog(userID, userName, "Import", Request.QueryString["Config_ID"], message, IP, Mac);
#endregion
return(message);
}
/// <summary>
/// 第一次加载数据
/// </summary>
private void DataLoad()
{
//用户信息 config_id 直接写死
string config_id = "1005";
GetFormInfo getfrom = new GetFormInfo();
//得到操作类型 Detail、Update、Add、DetailNoReturn
string operate_Type = "Update";
strManageTitle = getfrom.GetFormTitle("编辑信息", "edit");
strManageButton = getfrom.GetFormButton(false, true);
string pk_Field = "ID";
string pk_Value = GetID();
strManageBody = getfrom.GetDetailUpdate(config_id, pk_Field, pk_Value, 2, operate_Type);
}
/// <summary>
/// 第一次加载数据
/// </summary>
private void DataLoad()
{
string config_id = Request.QueryString["config_Id"].ToString();
GetFormInfo getfrom = new GetFormInfo();
//得到操作类型 Detail、Update、Add
string operate_Type = Request.QueryString["operate_Type"].ToString();
if (operate_Type == "Add")
{
strManageTitle = getfrom.GetFormTitle("添加信息", "edit");
strManageButton = getfrom.GetFormButton(true, true);
strManageBody = getfrom.GetFormAdd(config_id, 2);
}
else
{
if (operate_Type == "Detail")
{
strManageTitle = getfrom.GetFormTitle("详细信息", "book");
strManageButton = getfrom.GetFormButton(true, false);
}
else if (operate_Type == "DetailNoReturn")
{
strManageTitle = getfrom.GetFormTitle("详细信息", "book");
strManageButton = getfrom.GetFormButton(false, false);
}
else
{
strManageTitle = getfrom.GetFormTitle("编辑信息", "edit");
strManageButton = getfrom.GetFormButton(true, true);
}
string pk_Field = Request.QueryString["pk_Field"].ToString();
string pk_Value = Request.QueryString["pk_Value"].ToString();
strManageBody = getfrom.GetDetailUpdate(config_id, pk_Field, pk_Value, 2, operate_Type);
}
}
/// <summary>
/// 保存数据
/// </summary>
private void DataSave()
{
string config_id = Request.Form["config_Id"].ToString();
GetFormInfo getfrom = new GetFormInfo();
#region 得到 post 提交的数据
int dataLength = Request.Form.Count + 3;
string[] filedName = new string[dataLength];
object[] filedValue = new object[dataLength];
for (int i = 0; i < Request.Form.Count; i++)
{
string controlName = Request.Form.Keys[i];
filedName[i] = controlName;
filedValue[i] = Request.Form[controlName].Trim();//添加去除空格
}
if (Request.Files.Count > 0 && Request.Files[0].FileName != "")
{
//保存二进制数据
filedName[dataLength - 3] = Request.Files.Keys[0];
HttpPostedFile postedFile = Request.Files[0];
string type = getfrom.CheckSaveFileAddress(config_id, Request.Files.Keys[0]);
if (type == "文件上传控件_Disk")
{
string uploadPath =
HttpContext.Current.Server.MapPath("upfiles") + "\\" + config_id + "\\";
if (postedFile != null)
{
if (!Directory.Exists(uploadPath))
{
Directory.CreateDirectory(uploadPath);
}
string fileName = DateTime.Now.ToString("yyyy-MM-dd_HHmmss") + "-" + postedFile.FileName;
postedFile.SaveAs(uploadPath + fileName);
filedValue[dataLength - 3] = fileName;
//保存文件格式
filedName[dataLength - 2] = "imgFormat";
filedValue[dataLength - 2] = postedFile.FileName.Remove(0, postedFile.FileName.LastIndexOf('.'));
}
}
else
{
byte[] buffer = new byte[postedFile.ContentLength];
postedFile.InputStream.Read(buffer, 0, postedFile.ContentLength);
postedFile.InputStream.Close();
filedValue[dataLength - 3] = buffer;
//保存文件格式
filedName[dataLength - 2] = "imgFormat";
filedValue[dataLength - 2] = postedFile.FileName.Remove(0, postedFile.FileName.LastIndexOf('.'));
}
}
#endregion
//联合主键
if (Request.Form["Composite_FieldName"] != null && Request.Form["Composite_FieldName"] != "undefined")
{
filedName[dataLength - 1] = "." + Request.Form["Composite_FieldName"].ToString();
filedValue[dataLength - 1] = Request.Form["Composite_FieldValue"].ToString();
}
string message = "";
//得到操作类型 Detail、Update、Add
string operate_Type = Request.Form["operate_Type"].ToString();
string desc = "";
if (operate_Type == "Update")
{
string pk_Field = Request.Form["pk_Field"].ToString();
string pk_Value = Request.Form["pk_Value"].ToString();
string sqlWhere = " where " + pk_Field + " = '" + pk_Value + "'";
message = getfrom.DataSave(config_id, filedName, filedValue, sqlWhere);
desc = Request.Form["pk_Field"].ToString() + " 为 " + Request.Form["pk_Value"].ToString();
}
else
{
message = getfrom.DataSave(config_id, filedName, filedValue);
desc = message;
}
#region 操作记录
string IP = GetSystemProperties.GetIP();
string Mac = GetSystemProperties.GetMacBySendARP(IP);
string userID = getSession("userID");
string userName = getSession("userName");
LogInformation.OperationLog(userID, userName, operate_Type, config_id, desc, IP, Mac);
#endregion
Response.Write(message);
Response.End();
}