//添加结果
public JsonResult AddResult(int parentId, int level, string name)
{
string time = DateTime.Now.ToString();
string id;
string query = "SELECT * FROM DEPART_BASE WHERE parentID = @Id ORDER BY departID DESC LIMIT 1";
depart temp = (depart)db.Query <depart>(query, new { Id = parentId }).SingleOrDefault();
if (temp == null)
{
string queryparent = "SELECT * FROM DEPART_BASE WHERE departID = @Id";
depart parent = (depart)db.Query <depart>(queryparent, new { Id = parentId }).SingleOrDefault();
id = parent.departNum + "01";
}
else
{
string str = temp.departNum;
string num = str.Substring(str.Length - 2);
int id1 = int.Parse(num) + 1;
if (id1 < 10)
{
id = str.Substring(0, str.Length - 2) + "0" + id1.ToString();
}
else
{
id = str.Substring(0, str.Length - 2) + id1.ToString();
}
}
string sql = "INSERT INTO DEPART_BASE(departNum,departName,departLevel,parentID,createTime,createStaffID) VALUES(@Num,@Name,@Level,@ParentId,@CreateTime,@CreateStaffId)";
int result = db.Execute(sql, new { Num = id, Name = name, Level = level + 1, ParentId = parentId, CreateTime = time, CreateStaffId = 1 });
return(Json(result, JsonRequestBehavior.AllowGet));
}
//返回单个部门信息
public JsonResult LoadSingleDepart(int id)
{
CheckConnect();
string query = "SELECT * FROM DEPART_BASE WHERE departID = @Id";
depart dep = db.Query <depart>(query, new { Id = id }).SingleOrDefault();
return(Json(dep, JsonRequestBehavior.AllowGet));
}
//[HttpGet]
//public ActionResult Delete(int id)
//{
// NORTHWNDEntities db = new NORTHWNDEntities();
// var data = db.departs.Find(id);
// return View(data);
//}
//[HttpPost]
public ActionResult Delete(depart d)
{
NORTHWNDEntities db = new NORTHWNDEntities();
var data = db.departs.Find(d.Id);
db.departs.Remove(data);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(depart d)
{
if (ModelState.IsValid)
{
NORTHWNDEntities db = new NORTHWNDEntities();
db.Entry(d).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("index"));
}
return(View());
}
public ActionResult Create(depart d)
{
if (ModelState.IsValid)
{
NORTHWNDEntities db = new NORTHWNDEntities();
db.departs.Add(d);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
//返回单个员工信息
public JsonResult LoadSingleStaff(int id)
{
CheckConnect();
string query1 = "SELECT * FROM STAFF_BASE WHERE staffID = @Id";
string query2 = "SELECT * FROM DEPART_BASE WHERE departID = @Id";
string query4 = "SELECT * FROM DEPART_BASE WHERE departLevel = @Level";
staff sta = (staff)db.Query <staff>(query1, new { Id = id }).SingleOrDefault();
depart dep = (depart)db.Query <depart>(query2, new { Id = sta.departID }).SingleOrDefault();
List <depart> deps = (List <depart>)db.Query <depart>(query4, new { Level = dep.departLevel });
string query3 = "SELECT classNum,className FROM CLASS_ITEM WHERE classNum LIKE '020" + dep.departLevel.ToString() + "%'";
List <position> pos = (List <position>)db.Query <position>(query3);
staffInfoModel model = new staffInfoModel {
sta = sta, dep = dep, deps = deps, pos = pos
};
return(Json(model, JsonRequestBehavior.AllowGet));
}
protected void btn_print_Click(object sender, EventArgs e)
{
try
{
RemoveFiles(Server.MapPath(".") + "\\");
}
catch (Exception exp)
{
Log.log alog = new Log.log();
alog.Log(exp.Message.ToString() + DateTime.Now.ToString());
}
Random rd = new Random();
int oid = rd.Next(10000);
Word.Application app = new Word.Application();
Word.Document doc = new Word.Document();
object missing = System.Reflection.Missing.Value;
object IsSave = true;
try
{
DataSet ds_depart = new MyDataOp("select * from t_企业信息 inner join t_M_ClientInfo on 所属镇街道=t_M_ClientInfo.id inner join t_行业信息 on t_行业信息.id=行业类别 inner join t_生产状态 on t_生产状态.id=生产状态 where t_企业信息.id='" + Editid + "'").CreateDataSet();
depart departobj = new depart();
if (ds_depart.Tables[0].Rows.Count > 0)
{
departobj.departid = ds_depart.Tables[0].Rows[0]["id"].ToString().Trim();
departobj.departname = ds_depart.Tables[0].Rows[0]["单位全称"].ToString().Trim();
departobj.address = ds_depart.Tables[0].Rows[0]["单位详细地址"].ToString().Trim();
departobj.fddb = ds_depart.Tables[0].Rows[0]["法定代表人"].ToString().Trim();
departobj.frdm = ds_depart.Tables[0].Rows[0]["单位法人代码"].ToString().Trim();
departobj.frdh = ds_depart.Tables[0].Rows[0]["tel1"].ToString().Trim();
departobj.frsj = ds_depart.Tables[0].Rows[0]["mobile1"].ToString().Trim();
departobj.fzrsfw = ds_depart.Tables[0].Rows[0]["市府网1"].ToString().Trim();
departobj.fgr = ds_depart.Tables[0].Rows[0]["环保分管人"].ToString().Trim();
departobj.fgdh = ds_depart.Tables[0].Rows[0]["tel2"].ToString().Trim();
departobj.fgsj = ds_depart.Tables[0].Rows[0]["mobile2"].ToString().Trim();
departobj.fgsfw = ds_depart.Tables[0].Rows[0]["市府网2"].ToString().Trim();
departobj.fzr = ds_depart.Tables[0].Rows[0]["环保负责人"].ToString().Trim();
departobj.fzdh = ds_depart.Tables[0].Rows[0]["tel3"].ToString().Trim();
departobj.fzrsj = ds_depart.Tables[0].Rows[0]["mobile3"].ToString().Trim();
departobj.fzrsfw = ds_depart.Tables[0].Rows[0]["市府网3"].ToString().Trim();
departobj.sczt = ds_depart.Tables[0].Rows[0]["des2"].ToString().Trim();
departobj.ssjd = ds_depart.Tables[0].Rows[0]["des"].ToString().Trim();
departobj.yzbm = ds_depart.Tables[0].Rows[0]["邮政编码"].ToString().Trim();
departobj.dzyx = ds_depart.Tables[0].Rows[0]["电子邮箱"].ToString().Trim();
departobj.czhm = ds_depart.Tables[0].Rows[0]["传真号码"].ToString().Trim();
departobj.hy = ds_depart.Tables[0].Rows[0]["des1"].ToString().Trim();
if (ds_depart.Tables[0].Rows[0]["污水是否入网"].ToString().Trim() == "1")
{
departobj.wsrw = "是";
}
else
{
departobj.wsrw = "否";
}
if (ds_depart.Tables[0].Rows[0]["污水入网时间"].ToString() != "1900-1-1 0:00:00" && ds_depart.Tables[0].Rows[0]["污水入网时间"].ToString() != "")
{
departobj.rwsj = ds_depart.Tables[0].Rows[0]["污水入网时间"].ToString().Trim();
}
else
{
departobj.rwsj = "";
}
if (ds_depart.Tables[0].Rows[0]["集中供热是否入网"].ToString().Trim() == "1")
{
departobj.jzgr = "是";
}
else
{
departobj.jzgr = "否";
}
if (ds_depart.Tables[0].Rows[0]["集中供热入网时间"].ToString() != "1900-1-1 0:00:00" && ds_depart.Tables[0].Rows[0]["集中供热入网时间"].ToString() != "")
{
departobj.grsj = ds_depart.Tables[0].Rows[0]["集中供热入网时间"].ToString().Trim();
}
else
{
departobj.grsj = "";
}
departobj.yyzzfw = ds_depart.Tables[0].Rows[0]["工商营业执照经营范围"].ToString().Trim();
if (ds_depart.Tables[0].Rows[0]["单位设立时间"].ToString() != "1900-1-1 0:00:00" && ds_depart.Tables[0].Rows[0]["单位设立时间"].ToString() != "")
{
departobj.jcsj = DateTime.Parse(ds_depart.Tables[0].Rows[0]["单位设立时间"].ToString().Trim()).ToString("yyyy-mm-dd");
}
else
{
departobj.jcsj = "";
}
departobj.jncp = ds_depart.Tables[0].Rows[0]["企业近年产品产量"].ToString().Trim();
departobj.cym = ds_depart.Tables[0].Rows[0]["单位曾用名全称"].ToString().Trim();
int j = 0;
//string DocPath = ConfigurationManager.AppSettings["DocPath"].ToString();
string DocPath = Server.MapPath("../");
string TemplateFile = "";
//if (hpxs == "环评书")
TemplateFile = DocPath + "BaseData\\template\\qydjtemplate.doc";
//else if (hpxs == "环评表")
// TemplateFile = DocPath + "\\template\\template_pf_nocs.doc";
//生成的具有模板样式的新文件
string FileName = DocPath + "BaseData\\" + oid.ToString() + ".doc";
File.Copy(TemplateFile, FileName);
object Obj_FileName = FileName;
object Visible = false;
object ReadOnly = false;
//PageSetupDialog dlgPageSetup = new PageSetupDialog();
//打开文件
//WORD程序不可见
app.Visible = false;
//不弹出警告框
app.DisplayAlerts = Word.WdAlertLevel.wdAlertsNone;
//先保存默认的打印机
string defaultPrinter = app.ActivePrinter;
doc = app.Documents.Open(ref Obj_FileName,
ref missing, ref ReadOnly, ref missing,
ref missing, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref Visible,
ref missing, ref missing, ref missing,
ref missing);
doc.Activate();
// 单位全称，企业地址，法人代表，机构代码，试用类型，COD，废水排放量，
//string[] sqArr = { "departname", "address", "frdb", "jgdm", "sytype", "infectant1", "water", "infectant1nd", "infectant2", "infectant2nd", "remark" };
foreach (Word.Bookmark bm in doc.Bookmarks)
{
switch (bm.Name)
{
case "c_dwmc": bm.Select(); bm.Range.Text = departobj.departname.ToString(); break;
case "c_xxdz": bm.Select(); bm.Range.Text = departobj.address.ToString(); break;
case "c_frdm": bm.Select(); bm.Range.Text = departobj.frdm.ToString(); break;
case "c_ssjd": bm.Select(); bm.Range.Text = departobj.ssjd.ToString(); break;
case "c_yzbm": bm.Select(); bm.Range.Text = departobj.yzbm.ToString(); break;
case "c_czhm": bm.Select(); bm.Range.Text = departobj.czhm.ToString(); break;
case "c_dzyx": bm.Select(); bm.Range.Text = departobj.dzyx.ToString(); break;
case "c_sczt": bm.Select(); bm.Range.Text = departobj.sczt.ToString(); break;
case "c_hy": bm.Select(); bm.Range.Text = departobj.hy.ToString(); break;
case "c_frdb": bm.Select(); bm.Range.Text = departobj.fddb.ToString(); break;
case "c_frdh": bm.Select(); bm.Range.Text = departobj.frdh.ToString(); break;
case "c_frsj": bm.Select(); bm.Range.Text = departobj.frsj.ToString(); break;
case "c_frsfw": bm.Select(); bm.Range.Text = departobj.frsfw.ToString(); break;
case "c_fgr": bm.Select(); bm.Range.Text = departobj.fgr.ToString(); break;
case "c_fgrdh": bm.Select(); bm.Range.Text = departobj.fgdh.ToString(); break;
case "c_fgrsj": bm.Select(); bm.Range.Text = departobj.fgsj.ToString(); break;
case "c_fgrsfw": bm.Select(); bm.Range.Text = departobj.fgsfw.ToString(); break;
case "c_zrr": bm.Select(); bm.Range.Text = departobj.fzr.ToString(); break;
case "c_zrrdh": bm.Select(); bm.Range.Text = departobj.fzdh.ToString(); break;
case "c_zrrsj": bm.Select(); bm.Range.Text = departobj.fzrsj.ToString(); break;
case "c_zrrsfw": bm.Select(); bm.Range.Text = departobj.fzrsfw.ToString(); break;
case "c_wsrw": bm.Select(); bm.Range.Text = departobj.wsrw.ToString(); break;
case "c_wsrwsj": bm.Select(); bm.Range.Text = departobj.rwsj.ToString(); break;
case "c_jzgr": bm.Select(); bm.Range.Text = departobj.jzgr.ToString(); break;
case "c_jzgrsj": bm.Select(); bm.Range.Text = departobj.grsj.ToString(); break;
case "c_yyzzfw": bm.Select(); bm.Range.Text = departobj.yyzzfw.ToString(); break;
case "c_jncp": bm.Select(); bm.Range.Text = departobj.jncp.ToString(); break;
case "c_jcsj": bm.Select(); bm.Range.Text = departobj.jcsj.ToString(); break;
case "c_cym": bm.Select(); bm.Range.Text = departobj.cym.ToString(); break;
}
}
doc.Save();
object Background = true;
//doc.PrintPreview();
//doc.PrintOut(ref Background, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing);
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "window.open('" + oid.ToString() + ".doc','theNewWindow',' left=0,top=0,width='+ (screen.availWidth - 10) +',height='+ (screen.availHeight-50) +',scrollbars,resizable=yes,toolbar=no')", true);
}
}
catch (Exception mes)
{
//ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('打印机连接失败！请先测试打印机连接状态！')", true);
Log.log alog = new Log.log();
alog.Log(mes.Message.ToString() + DateTime.Now.ToString());
}
finally
{
doc.Close(ref IsSave, ref missing, ref missing);
app.Application.Quit(ref missing, ref missing, ref missing);
doc = null;
app = null;
}
}
private void button2_Click(object sender, EventArgs e)
{
depart d0 = new depart();
d0.ShowDialog();
}
