/// <summary>
/// 向doc文件写入数据
/// </summary>
/// <param name="path"></param>
/// <returns></returns>
public bool WrithDocFile(string path)
{
string Quhua = string.Empty; //区划编码
string CheckType = string.Empty; //检查类型
try
{
//查看其行政区划编码
Quhua = path.Substring(path.IndexOf("(") + 1);
Quhua = Quhua.Substring(0, Quhua.IndexOf(")"));
}
catch (Exception)
{
MessageBox.Show("不合法的文件夹格式");
return(false);
}
if (path.Contains("GTSYQ"))
{
CheckType = "国有土地使用权";
}
else if (path.Contains("JTSYQ"))
{
CheckType = "集体土地使用权";
}
else
{
CheckType = "集体土地所有权";
}
object file = path;
//操作word文档
MSWord.Application wordApp;
MSWord.Document wordDoc;
wordApp = new MSWord.ApplicationClass();
Object nothing = Missing.Value;
wordDoc = wordApp.Documents.Open(ref file, ref nothing, ref nothing, ref nothing);
Bookmarks marks = wordDoc.Bookmarks;
wordDoc.Bookmarks.get_Item("xzqdm").Range.Text = Quhua;//行政区代码
string quHuaName = new QuHuaHelper().GetQuHuaName(Quhua);
wordDoc.Bookmarks.get_Item("rootpath1").Range.Text = quHuaName;//行政区划名称
wordDoc.Bookmarks.get_Item("startdate").Range.Text = DateTime.Now.ToShortDateString();
var sjwzx = from p in ComMsg.ResultShow
where p.Gzlx.Equals("数据完整性")
select p;
wordDoc.Bookmarks.get_Item("sjwzxzqx").Range.Text = (from p in sjwzx where p.Cwdj.Equals("重缺陷") select p).ToList().Count.ToString(); //数据完整性_重缺陷
wordDoc.Bookmarks.get_Item("sjwzxqqx").Range.Text = (from p in sjwzx where p.Cwdj.Equals("轻缺陷") select p).ToList().Count.ToString(); //数据完整性_轻缺陷
wordDoc.Bookmarks.get_Item("sjwzxtotal").Range.Text = sjwzx.ToList().Count.ToString(); //数据完整性_错误合计
var jgfhx = from p in ComMsg.ResultShow
where p.Gzlx.Equals("结构符合性")
select p;
wordDoc.Bookmarks.get_Item("jgfhxzqx").Range.Text = (from p in jgfhx where p.Cwdj.Equals("重缺陷") select p).ToList().Count.ToString(); //结构符合性_重缺陷
wordDoc.Bookmarks.get_Item("jgfhxqqx").Range.Text = (from p in jgfhx where p.Cwdj.Equals("轻缺陷") select p).ToList().Count.ToString(); //结构符合性_轻缺陷
wordDoc.Bookmarks.get_Item("jgfhxtotal").Range.Text = jgfhx.ToList().Count.ToString(); //结构符合性_错误合计
var jczb = from p in ComMsg.ResultShow
where p.Gzlx.Equals("基础指标")
select p;
wordDoc.Bookmarks.get_Item("jczbzqx").Range.Text = (from p in jczb where p.Cwdj.Equals("重缺陷") select p).ToList().Count.ToString(); //基础指标_重缺陷
wordDoc.Bookmarks.get_Item("jczbqqx").Range.Text = (from p in jczb where p.Cwdj.Equals("轻缺陷") select p).ToList().Count.ToString(); //基础指标_轻缺陷
wordDoc.Bookmarks.get_Item("jczbtotal").Range.Text = jczb.ToList().Count.ToString(); //基础指标_错误合计
wordDoc.Bookmarks.get_Item("ljglzqx").Range.Text = "0"; //逻辑关联_重缺陷
wordDoc.Bookmarks.get_Item("ljglqqx").Range.Text = "0"; //逻辑关联_轻缺陷
wordDoc.Bookmarks.get_Item("ljgltotal").Range.Text = "0"; //逻辑关联_错误合计
wordDoc.Bookmarks.get_Item("txjczqx").Range.Text = "0"; //空间图形检查_重缺陷
wordDoc.Bookmarks.get_Item("txjcqqx").Range.Text = "0"; //空间图形检查_轻缺陷
wordDoc.Bookmarks.get_Item("txjctotal").Range.Text = "0"; //空间图形检查_错误合计
var hzbg = from p in ComMsg.ResultShow
select p;
wordDoc.Bookmarks.get_Item("hzbgjczqx").Range.Text = (from p in hzbg where p.Cwdj.Equals("重缺陷") select p).ToList().Count.ToString(); //汇总表格检查_重缺陷
wordDoc.Bookmarks.get_Item("hzbgjcqqx").Range.Text = (from p in hzbg where p.Cwdj.Equals("轻缺陷") select p).ToList().Count.ToString(); //汇总表格检查_轻缺陷
wordDoc.Bookmarks.get_Item("hzbgjctotal").Range.Text = hzbg.ToList().Count.ToString(); //汇总表格检查_错误合计
wordDoc.Bookmarks.get_Item("zqx1").Range.Text = (from p in hzbg where p.Cwdj.Equals("重缺陷") select p).ToList().Count.ToString(); //总计_重缺陷
wordDoc.Bookmarks.get_Item("qqx1").Range.Text = (from p in hzbg where p.Cwdj.Equals("轻缺陷") select p).ToList().Count.ToString(); //总计_轻缺陷
wordDoc.Bookmarks.get_Item("total1").Range.Text = hzbg.ToList().Count.ToString(); //总计_错误合计
wordDoc.Bookmarks.get_Item("zqx2").Range.Text = (from p in hzbg where p.Cwdj.Equals("重缺陷") select p).ToList().Count.ToString(); //总计_重缺陷
wordDoc.Bookmarks.get_Item("qqx2").Range.Text = (from p in hzbg where p.Cwdj.Equals("轻缺陷") select p).ToList().Count.ToString(); //总计_轻缺陷
wordDoc.Bookmarks.get_Item("total2").Range.Text = hzbg.ToList().Count.ToString(); //总计_错误合计
wordDoc.Bookmarks.get_Item("sxsjtotal").Range.Text = hzbg.ToList().Count.ToString(); //属性数据总和
wordDoc.Bookmarks.get_Item("slsjtotal").Range.Text = "0"; //矢量数据总和
wordDoc.Bookmarks.get_Item("checkresult").Range.Text = quHuaName + "(" + Quhua + ")" + CheckType + "土地登记成果检查" + ((from p in hzbg where p.Cwdj.Equals("轻缺陷") select p).ToList().Count > 0 ? "未通过" : "通过");
wordDoc.Bookmarks.get_Item("rootpath2").Range.Text = quHuaName + "(" + Quhua + ")" + CheckType + "土地登记成果";
wordDoc.Bookmarks.get_Item("rootpath3").Range.Text = quHuaName + "(" + Quhua + ")" + CheckType + "土地登记成果";
object oMissing = System.Reflection.Missing.Value;
wordDoc.SaveAs(ref file, ref oMissing, ref oMissing, ref oMissing,
ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing,
ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing,
ref oMissing, ref oMissing);
wordDoc.Close(ref nothing, ref nothing, ref nothing);
wordApp.Quit(ref nothing, ref nothing, ref nothing);
return(true);
}
/// <summary>
/// 向doc文件写入数据
/// </summary>
/// <param name="path"></param>
/// <returns></returns>
public bool WrithDocFile(string path)
{
string Quhua = string.Empty;//区划编码
string CheckType = string.Empty;//检查类型
try
{
//查看其行政区划编码
Quhua = path.Substring(path.IndexOf("(") + 1);
Quhua = Quhua.Substring(0, Quhua.IndexOf(")"));
}
catch (Exception)
{
MessageBox.Show("不合法的文件夹格式");
return false;
}
if (path.Contains("GTSYQ"))
CheckType = "国有土地使用权";
else if (path.Contains("JTSYQ"))
CheckType = "集体土地使用权";
else
CheckType = "集体土地所有权";
object file = path;
//操作word文档
MSWord.Application wordApp;
MSWord.Document wordDoc;
wordApp = new MSWord.ApplicationClass();
Object nothing = Missing.Value;
wordDoc = wordApp.Documents.Open(ref file, ref nothing, ref nothing, ref nothing);
Bookmarks marks = wordDoc.Bookmarks;
wordDoc.Bookmarks.get_Item("xzqdm").Range.Text = Quhua;//行政区代码
string quHuaName = new QuHuaHelper().GetQuHuaName(Quhua);
wordDoc.Bookmarks.get_Item("rootpath1").Range.Text = quHuaName;//行政区划名称
wordDoc.Bookmarks.get_Item("startdate").Range.Text = DateTime.Now.ToShortDateString();
var sjwzx = from p in ComMsg.ResultShow
where p.Gzlx.Equals("数据完整性")
select p;
wordDoc.Bookmarks.get_Item("sjwzxzqx").Range.Text = (from p in sjwzx where p.Cwdj.Equals("重缺陷") select p).ToList().Count.ToString();//数据完整性_重缺陷
wordDoc.Bookmarks.get_Item("sjwzxqqx").Range.Text = (from p in sjwzx where p.Cwdj.Equals("轻缺陷") select p).ToList().Count.ToString();//数据完整性_轻缺陷
wordDoc.Bookmarks.get_Item("sjwzxtotal").Range.Text = sjwzx.ToList().Count.ToString();//数据完整性_错误合计
var jgfhx = from p in ComMsg.ResultShow
where p.Gzlx.Equals("结构符合性")
select p;
wordDoc.Bookmarks.get_Item("jgfhxzqx").Range.Text = (from p in jgfhx where p.Cwdj.Equals("重缺陷") select p).ToList().Count.ToString();//结构符合性_重缺陷
wordDoc.Bookmarks.get_Item("jgfhxqqx").Range.Text = (from p in jgfhx where p.Cwdj.Equals("轻缺陷") select p).ToList().Count.ToString();//结构符合性_轻缺陷
wordDoc.Bookmarks.get_Item("jgfhxtotal").Range.Text = jgfhx.ToList().Count.ToString();//结构符合性_错误合计
var jczb= from p in ComMsg.ResultShow
where p.Gzlx.Equals("基础指标")
select p;
wordDoc.Bookmarks.get_Item("jczbzqx").Range.Text = (from p in jczb where p.Cwdj.Equals("重缺陷") select p).ToList().Count.ToString();//基础指标_重缺陷
wordDoc.Bookmarks.get_Item("jczbqqx").Range.Text = (from p in jczb where p.Cwdj.Equals("轻缺陷") select p).ToList().Count.ToString();//基础指标_轻缺陷
wordDoc.Bookmarks.get_Item("jczbtotal").Range.Text = jczb.ToList().Count.ToString();//基础指标_错误合计
wordDoc.Bookmarks.get_Item("ljglzqx").Range.Text = "0";//逻辑关联_重缺陷
wordDoc.Bookmarks.get_Item("ljglqqx").Range.Text = "0";//逻辑关联_轻缺陷
wordDoc.Bookmarks.get_Item("ljgltotal").Range.Text = "0";//逻辑关联_错误合计
wordDoc.Bookmarks.get_Item("txjczqx").Range.Text = "0";//空间图形检查_重缺陷
wordDoc.Bookmarks.get_Item("txjcqqx").Range.Text = "0";//空间图形检查_轻缺陷
wordDoc.Bookmarks.get_Item("txjctotal").Range.Text = "0";//空间图形检查_错误合计
var hzbg=from p in ComMsg.ResultShow
select p;
wordDoc.Bookmarks.get_Item("hzbgjczqx").Range.Text = (from p in hzbg where p.Cwdj.Equals("重缺陷") select p).ToList().Count.ToString();//汇总表格检查_重缺陷
wordDoc.Bookmarks.get_Item("hzbgjcqqx").Range.Text = (from p in hzbg where p.Cwdj.Equals("轻缺陷") select p).ToList().Count.ToString();//汇总表格检查_轻缺陷
wordDoc.Bookmarks.get_Item("hzbgjctotal").Range.Text = hzbg.ToList().Count.ToString();//汇总表格检查_错误合计
wordDoc.Bookmarks.get_Item("zqx1").Range.Text = (from p in hzbg where p.Cwdj.Equals("重缺陷") select p).ToList().Count.ToString();//总计_重缺陷
wordDoc.Bookmarks.get_Item("qqx1").Range.Text = (from p in hzbg where p.Cwdj.Equals("轻缺陷") select p).ToList().Count.ToString();//总计_轻缺陷
wordDoc.Bookmarks.get_Item("total1").Range.Text =hzbg.ToList().Count.ToString();//总计_错误合计
wordDoc.Bookmarks.get_Item("zqx2").Range.Text = (from p in hzbg where p.Cwdj.Equals("重缺陷") select p).ToList().Count.ToString();//总计_重缺陷
wordDoc.Bookmarks.get_Item("qqx2").Range.Text = (from p in hzbg where p.Cwdj.Equals("轻缺陷") select p).ToList().Count.ToString();//总计_轻缺陷
wordDoc.Bookmarks.get_Item("total2").Range.Text = hzbg.ToList().Count.ToString();//总计_错误合计
wordDoc.Bookmarks.get_Item("sxsjtotal").Range.Text = hzbg.ToList().Count.ToString();//属性数据总和
wordDoc.Bookmarks.get_Item("slsjtotal").Range.Text = "0";//矢量数据总和
wordDoc.Bookmarks.get_Item("checkresult").Range.Text = quHuaName + "(" + Quhua + ")" + CheckType + "土地登记成果检查" + ((from p in hzbg where p.Cwdj.Equals("轻缺陷") select p).ToList().Count > 0 ? "未通过" : "通过");
wordDoc.Bookmarks.get_Item("rootpath2").Range.Text = quHuaName + "(" + Quhua + ")" + CheckType + "土地登记成果";
wordDoc.Bookmarks.get_Item("rootpath3").Range.Text = quHuaName + "(" + Quhua + ")" + CheckType + "土地登记成果";
object oMissing = System.Reflection.Missing.Value;
wordDoc.SaveAs(ref file, ref oMissing, ref oMissing, ref oMissing,
ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing,
ref oMissing, ref oMissing, ref oMissing, ref oMissing, ref oMissing,
ref oMissing, ref oMissing);
wordDoc.Close(ref nothing, ref nothing, ref nothing);
wordApp.Quit(ref nothing, ref nothing, ref nothing);
return true;
}
