/// <summary> /// 单个查询 /// </summary> /// <param name="id"></param> /// <returns></returns> public Node GetModel(int id) { BranchRecord model = new BranchRecord(); model.GetModel(id); Node node = new Node(); node.id = model.id.ToString(); node.NSRMC = model.NSRMC; node.NSRSBH = model.NSRSBH; node.JYDZ = model.JYDZ; node.ZGSWJG = model.ZGSWJG; node.SFNSZT = model.SFNSZT ? 1 : 0; node.KYSJ = model.KYSJ.ToString("yyyy-MM-dd"); if (model.ZXSJ != null) { node.ZXSJ = Convert.ToDateTime(model.ZXSJ).ToString("yyyy-MM-dd"); } else { node.ZXSJ = ""; } node.SJJGMC = model.SJJGMC; node.SJJGSFNSZT = model.SJJGSFNSZT ? 1 : 0; node.CREATEID = model.CREATEID; node.CREATETIME = model.CREATETIME.ToString("yyyy-MM-dd HH:mm:ss"); return(node); }
/// <summary> /// 批量导入 /// </summary> /// <param name="list"></param> /// <returns></returns> public bool BatchAdd(IList <Node> list) { //将IList<Node>转成DataTable DataTable dt = new DataTable("BranchRecord"); dt.Columns.Add("id"); dt.Columns.Add("NSRMC"); dt.Columns.Add("NSRSBH"); dt.Columns.Add("JYDZ"); dt.Columns.Add("ZGSWJG"); dt.Columns.Add("SFNSZT", typeof(bool)); dt.Columns.Add("KYSJ", typeof(DateTime)); dt.Columns.Add("ZXSJ", typeof(DateTime)); dt.Columns.Add("SJJGMC"); dt.Columns.Add("SJJGSFNSZT", typeof(bool)); dt.Columns.Add("ISDELETE", typeof(bool)); dt.Columns.Add("CREATEID", typeof(int)); dt.Columns.Add("CREATETIME", typeof(DateTime)); dt.Columns.Add("EDITID", typeof(int)); dt.Columns.Add("EDITTIME", typeof(DateTime)); dt.Columns.Add("DELETEID", typeof(int)); dt.Columns.Add("DELETETIME", typeof(DateTime)); for (int i = 0; i < list.Count; i++) { string NSRMC = list[i].NSRMC; string NSRSBH = list[i].NSRSBH; if (this.Count(NSRMC, string.Empty) != 0) { throw new ArgumentException(string.Format("纳税人名称:{0},已存在", NSRMC)); } if (this.Count("", NSRSBH) != 0) { throw new ArgumentException(string.Format("纳税人识别号:{0},已存在", NSRSBH)); } DataRow row = dt.NewRow(); row[1] = list[i].NSRMC; row[2] = list[i].NSRSBH; row[3] = list[i].JYDZ; row[4] = list[i].ZGSWJG; row[5] = list[i].SFNSZT == 1 ? true : false; row[6] = list[i].KYSJ; DateTime Temp_ZXSJ = new DateTime(); if (DateTime.TryParse(list[i].ZXSJ, out Temp_ZXSJ)) { row[7] = list[i].ZXSJ; } row[8] = list[i].SJJGMC; row[9] = list[i].SJJGSFNSZT; row[10] = false; row[11] = list[i].CREATEID; row[12] = list[i].CREATETIME; dt.Rows.Add(row); } BranchRecord branch = new BranchRecord(); return(branch.BatchAdd(dt)); }
/// <summary> /// 查询列表 /// </summary> /// <returns></returns> public Grid GetList(BranchListQueryParm parm) { BranchRecord model = new BranchRecord(); StringBuilder builder = new StringBuilder(); if (parm != null) { #region 拼接SQL筛选条件 if (!string.IsNullOrEmpty(parm.NSRMC) && parm.NSRMC.Trim().Length > 0) { builder.Append(string.Format(" AND NSRMC like '%{0}%' ", parm.NSRMC)); } if (!string.IsNullOrEmpty(parm.NSRSBH) && parm.NSRSBH.Trim().Length > 0) { builder.Append(string.Format(" AND NSRSBH like '%{0}%' ", parm.NSRSBH)); } if (parm.SFNSZT == 0 || parm.SFNSZT == 1) { builder.Append(string.Format(" AND SFNSZT = {0} ", parm.SFNSZT)); } #endregion } Grid grid = new Grid(); DataTable table = model.GetList(builder.ToString()); foreach (DataRow row in table.Rows) { Node node = new Node(); node.id = row["id"].ToString(); node.NSRMC = row["NSRMC"].ToString(); node.NSRSBH = row["NSRSBH"].ToString(); node.JYDZ = row["JYDZ"].ToString(); node.ZGSWJG = row["ZGSWJG"].ToString(); node.SFNSZT = ConvertHelper.ToBoolean(row["SFNSZT"]) ? 1 : 0; node.KYSJ = Convert.ToDateTime(row["KYSJ"]).ToString("yyyy-MM-dd"); if (row["ZXSJ"] != DBNull.Value) { node.ZXSJ = Convert.ToDateTime(row["ZXSJ"]).ToString("yyyy-MM-dd"); } else { node.ZXSJ = ""; } node.SJJGMC = row["SJJGMC"].ToString(); node.SJJGSFNSZT = ConvertHelper.ToBoolean(row["SJJGSFNSZT"]) ? 1 : 0; grid.Rows.Add(node); } grid = GetTreeMap(grid); //按显示的数据导出Excel return(grid); }
/// <summary> /// 编辑 /// </summary> /// <param name="node"></param> /// <returns></returns> public int Edit(Node node) { BranchRecord branch = new BranchRecord(); branch.id = ConvertHelper.ToInt(node.id); branch.NSRMC = node.NSRMC; branch.NSRSBH = node.NSRSBH; branch.JYDZ = node.JYDZ; branch.ZGSWJG = node.ZGSWJG; branch.SFNSZT = node.SFNSZT == 1 ? true : false; branch.KYSJ = Convert.ToDateTime(node.KYSJ); if (string.IsNullOrEmpty(node.ZXSJ)) { branch.ZXSJ = null; } else { branch.ZXSJ = Convert.ToDateTime(node.ZXSJ); } branch.SJJGMC = node.SJJGMC; branch.SJJGSFNSZT = node.SJJGSFNSZT == 1 ? true : false; branch.CREATEID = node.CREATEID; branch.CREATETIME = Convert.ToDateTime(node.CREATETIME); branch.EDITID = node.EDITID; branch.EDITTIME = DateTime.Now; //验证上级机构是否存在 if (node.SJJGMC.Length > 0 && Count(node.SJJGMC, string.Empty) == 0) { throw new ArgumentException("上级机构名称: " + branch.SJJGMC + ", 不存在,请先录入该机构"); } //检查纳税人名称是否不存在 if (this.Count(branch.id, branch.NSRMC, string.Empty) != 0) { throw new ArgumentException("纳税人名称:" + branch.NSRMC + ",已存在"); } if (this.Count(branch.id, string.Empty, branch.NSRSBH) != 0) { throw new ArgumentException("纳税人识别号:" + branch.NSRSBH + ",已存在"); } bool flag = branch.Update(); if (flag == true) { return(1); } else { return(0); } }
/// <summary> /// 纳税人名称与纳税人识别号是否唯一,除了某个ID之外,编辑时会用到 /// </summary> /// <param name="id"></param> /// <returns></returns> public int Count(int id, string NSRMC, string NSRSBH) { BranchRecord branch = new BranchRecord(); if (NSRMC.Length == 0 && NSRSBH.Length > 0) { return(branch.CountNSRSBH(NSRSBH, id)); } else if (NSRMC.Length > 0 && NSRSBH.Length == 0) { return(branch.CountNSRMC(NSRMC, id)); } else { throw new Exception("纳税人名称与识别号不能为空,也不能同时有值"); } }
/// <summary> /// 添加 /// </summary> /// <param name="node"></param> /// <returns></returns> public int Add(Node node) { BranchRecord branch = new BranchRecord(); branch.NSRMC = node.NSRMC; branch.NSRSBH = node.NSRSBH; branch.JYDZ = node.JYDZ; branch.ZGSWJG = node.ZGSWJG; branch.SFNSZT = node.SFNSZT == 1 ? true : false; branch.KYSJ = Convert.ToDateTime(node.KYSJ); if (string.IsNullOrEmpty(node.ZXSJ)) { branch.ZXSJ = null; } else { branch.ZXSJ = Convert.ToDateTime(node.ZXSJ); } branch.SJJGMC = node.SJJGMC; branch.SJJGSFNSZT = node.SJJGSFNSZT == 1 ? true : false; branch.CREATEID = node.CREATEID; branch.CREATETIME = Convert.ToDateTime(node.CREATETIME); //验证上级机构是否存在 if (node.SJJGMC.Length > 0 && Count(node.SJJGMC, string.Empty) == 0) { throw new ArgumentException("上级机构名称: " + branch.SJJGMC + ", 不存在,请先录入该机构"); } //检查纳税人名称是否不存在 if (this.Count(node.NSRMC, string.Empty) != 0) { throw new ArgumentException("纳税人名称: " + branch.NSRMC + ", 已存在"); } if (this.Count("", node.NSRSBH) != 0) { throw new ArgumentException("纳税人识别号: " + branch.NSRSBH + ", 已存在"); } int num = branch.Add(); return(num); }
/// <summary> /// 获取总数 /// </summary> /// <returns></returns> public int Count() { BranchRecord branch = new BranchRecord(); return(branch.Count()); }
/// <summary> /// 判断上级机构名称是否存在 /// </summary> /// <param name="SJJGMC"></param> /// <returns></returns> public int CountSJJGMC(string SJJGMC) { BranchRecord branch = new BranchRecord(); return(branch.CountNSRMC(SJJGMC)); }
/// <summary> /// 删除 /// </summary> /// <param name="id"></param> /// <returns></returns> public bool Delete(int id, int userId) { BranchRecord branch = new BranchRecord(); return(branch.DeleteAll(id, userId)); }
/// <summary> /// 遍历所有数据 /// </summary> /// <returns></returns> public DataTable GetExcelExportDataTable() { BranchRecord model = new BranchRecord(); return(model.GetExcelExportDataTable("")); }