/// <summary>
/// 删除数据
/// </summary>
private void DeleteById()
{
int id;
string a = Request["id[]"];
string[] temp = a.Split(',');
for (int j = 0; j < temp.Length; j++)
{
id = Convert.ToInt32(temp[j]);
DAL.WorkingArea.Delete(id);
DAL.WorkingArea dw = new DAL.WorkingArea();
Model.WorkingArea wa = dw.GetModel(id);
string areaName = wa.AreaName;
//DataSet ds = DAL.NewRTKUserPurview.GetList("1=1");
//for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
//{
// Model.NewRTKUserPurview mRTKUserPurview = DAL.NewRTKUserPurview.GetModel(ds.Tables[0].Rows[i]["UserName"].ToString());
// string AreaIDs = "";
// foreach (string Uid in mRTKUserPurview.AreaID.Split(';'))
// {
// if (Uid.Trim() != "")
// {
// if (Uid == areaName)
// {
// }
// else
// {
// AreaIDs += Uid + ";";
// }
// }
// }
// mRTKUserPurview.AreaID = AreaIDs;
// DAL.NewRTKUserPurview.Update(mRTKUserPurview);
//}
//DataSet ComUser = DAL.CompanyPurview.GetList("1=1");
//for (int i = 0; i < ComUser.Tables[0].Rows.Count; i++)
//{
// Model.CompanyPurview mCompanyPurview = DAL.CompanyPurview.GetModel(ComUser.Tables[0].Rows[i]["UserName"].ToString());
// string AreaIDs = "";
// foreach (string Uid in mCompanyPurview.AreaID.Split(';'))
// {
// if (Uid.Trim() != "")
// {
// if (Uid == areaName)
// {
// }
// else
// {
// AreaIDs += Uid + ";";
// }
// }
// }
// mCompanyPurview.AreaID = AreaIDs;
// DAL.CompanyPurview.Update(mCompanyPurview);
//}
}
}
public bool Update(Model.WorkingArea model)
{
string strSql = "update WorkingArea set AreaName=@AreaName, AreaString=@AreaString where ID = " + model.ID.ToString();
SqlParameter AreaName = new SqlParameter("AreaName", SqlDbType.NVarChar); AreaName.Value = model.AreaName;
SqlParameter AreaString = new SqlParameter("AreaString", SqlDbType.VarChar); AreaString.Value = model.AreaString;
return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { AreaName, AreaString }, connectionString) == 1 ? true : false);
}
public bool Add(Model.WorkingArea model)
{
string strSql = "insert into WorkingArea(AreaName, AreaString) values(@AreaName, @AreaString)";
SqlParameter AreaName = new SqlParameter("AreaName", SqlDbType.NVarChar); AreaName.Value = model.AreaName;
SqlParameter AreaString = new SqlParameter("AreaString", SqlDbType.VarChar); AreaString.Value = model.AreaString;
return(DBHelperSQL.GetNums(strSql, new SqlParameter[] { AreaName, AreaString }, connectionString) == 1 ? true : false);
}
private int AddData()
{
string savepath = Server.MapPath("~/upload/WorkingArea/");
string filename = Request.Files[0].FileName;
try
{
Request.Files[0].SaveAs(savepath + filename);
}
catch
{
return(-1);
}
StreamReader sr = new StreamReader(savepath + filename);
try
{
string data = "";
string linedata = sr.ReadLine();
while (linedata != null && linedata.Trim() != "")
{
string[] dds = linedata.Split(',');
if (data != "")
{
data = data + "," + dds[0].Trim() + "," + dds[1].Trim();
}
else
{
data = data + dds[0].Trim() + "," + dds[1].Trim();
}
linedata = sr.ReadLine();
}
Model.WorkingArea mwa = new Model.WorkingArea();
mwa.AreaName = Request["area"];
mwa.AreaString = data;
DAL.WorkingArea dw = new DAL.WorkingArea();
if (dw.Exists(mwa.AreaName))
{
return(-2);//已经存在改名称
}
DAL.WorkingArea dalwa = new DAL.WorkingArea();
dalwa.Add(mwa);
sr.Close();
File.Delete(savepath + filename);
return(0);
}
catch (Exception er)
{
sr.Close(); File.Delete(savepath + filename);
return(1);//格式添加错误
}
}
public Model.WorkingArea GetModel(int ID)
{
string strSql = "select * from WorkingArea where ID = " + ID.ToString();
Model.WorkingArea model = new Model.WorkingArea();
DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString);
model.ID = ID;
if (ds.Tables[0].Rows.Count > 0)
{
model.AreaName = Convert.ToString(ds.Tables[0].Rows[0]["AreaName"]);
model.AreaString = Convert.ToString(ds.Tables[0].Rows[0]["AreaString"]);
return(model);
}
else
{
return(null);
}
}
public Model.WorkingArea GetModel(string AreaName)
{
string strSql = "select * from WorkingArea where AreaName = '" + AreaName + "'";
Model.WorkingArea model = new Model.WorkingArea();
DataSet ds = DBHelperSQL.GetDataSet(strSql, connectionString);
model.AreaName = AreaName;
if (ds.Tables[0].Rows.Count > 0)
{
model.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"]);
model.AreaString = Convert.ToString(ds.Tables[0].Rows[0]["AreaString"]);
return(model);
}
else
{
return(null);
}
}
private void UpdateData()
{
DAL.WorkingArea dalwa = new DAL.WorkingArea();
int id = Convert.ToInt32(Request["ID"].ToString());
DAL.WorkingArea dw = new DAL.WorkingArea();
Model.WorkingArea mwa = DAL.WorkingArea.GetModel(id);
mwa.AreaName = Request["AreaName"].Trim();
flag = 1;
string[] area = Request["AreaString"].ToString().Split(',');
foreach (string a in area)
{
try { Convert.ToDouble(a); }
catch { flag = -1; return; }
}
mwa.AreaString = Request["AreaString"].Trim();
DAL.WorkingArea.Update(mwa);
Response.ContentType = "text/plain";
Response.Write("0");
Response.End();
}
/// <summary>
/// 下载数据
/// </summary>
/// <param name="id">需要下载的ID</param>
private void Download(int id)
{
DAL.WorkingArea bllwa = new DAL.WorkingArea();
DAL.WorkingArea dw = new DAL.WorkingArea();
Model.WorkingArea modelwa = dw.GetModel(id);
string savepath = Server.MapPath("~/upload/WorkingArea/");
string filePath = savepath + modelwa.AreaName + ".txt";
string fileName = "WorkingArea_" + modelwa.AreaName + ".txt";
StreamWriter sw = new StreamWriter(filePath, false);
string[] strs = modelwa.AreaString.Split(',');
for (int i = 0; i < (strs.Length) / 2; i++)
{
sw.WriteLine(strs[2 * i] + "," + strs[2 * i + 1]);
}
sw.Close();
//提交结果给用户
try
{
FileInfo fileInfo = new FileInfo(filePath);
Response.Clear();
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8));
Response.AddHeader("Content-Length", fileInfo.Length.ToString());
Response.AddHeader("Content-Transfer-Encoding", "binary");
//Response.ContentType = "text/plain";
Response.ContentType = "application/octet-stream";
Response.ContentEncoding = System.Text.Encoding.Default;
Response.WriteFile(fileInfo.FullName);
Response.Flush();
// Response.End();
}
catch (Exception er)
{
string text = er.Message;
throw new Exception("处理过程中发生了错误！");
}
}
