/// <summary> /// 增加一条数据 /// </summary> public decimal Add(Maticsoft.Model.SMT_VERMODEL_INFO model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SMT_VERMODEL_INFO("); strSql.Append("VERM_NAME,VERM_CONTENT,VERM_ADDTIME,VERM_MODIFYTIME,VERM_ADDUSERID)"); strSql.Append(" values ("); strSql.Append("@VERM_NAME,@VERM_CONTENT,@VERM_ADDTIME,@VERM_MODIFYTIME,@VERM_ADDUSERID)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@VERM_NAME", SqlDbType.NVarChar, 100), new SqlParameter("@VERM_CONTENT", SqlDbType.VarBinary, -1), new SqlParameter("@VERM_ADDTIME", SqlDbType.DateTime), new SqlParameter("@VERM_MODIFYTIME", SqlDbType.DateTime), new SqlParameter("@VERM_ADDUSERID", SqlDbType.Decimal, 9) }; parameters[0].Value = model.VERM_NAME; parameters[1].Value = model.VERM_CONTENT; parameters[2].Value = model.VERM_ADDTIME; parameters[3].Value = model.VERM_MODIFYTIME; parameters[4].Value = model.VERM_ADDUSERID; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToDecimal(obj)); } }
private void biDeleteModel_Click(object sender, EventArgs e) { var model = GetSelectModel(); if (model == null) { WinInfoHelper.ShowInfoWindow(this, "请选择删除的模板!"); } else { if (MessageBox.Show("确定删除“" + model.VERM_NAME + "”模板?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK) { CtrlWaiting waiting = new CtrlWaiting(() => { try { Maticsoft.BLL.SMT_VERMODEL_INFO bll = new Maticsoft.BLL.SMT_VERMODEL_INFO(); bll.Delete(model.ID); _lastSelectModel = null; InternalInitTree(); } catch (Exception ex) { log.Error("删除模板异常:" + ex.Message); WinInfoHelper.ShowInfoWindow(this, "删除模板异常:" + ex.Message); } }); waiting.Show(this); } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.SMT_VERMODEL_INFO DataRowToModel(DataRow row) { Maticsoft.Model.SMT_VERMODEL_INFO model = new Maticsoft.Model.SMT_VERMODEL_INFO(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = decimal.Parse(row["ID"].ToString()); } if (row["VERM_NAME"] != null) { model.VERM_NAME = row["VERM_NAME"].ToString(); } if (row["VERM_CONTENT"] != null && row["VERM_CONTENT"].ToString() != "") { model.VERM_CONTENT = (byte[])row["VERM_CONTENT"]; } if (row["VERM_ADDTIME"] != null && row["VERM_ADDTIME"].ToString() != "") { model.VERM_ADDTIME = DateTime.Parse(row["VERM_ADDTIME"].ToString()); } if (row["VERM_MODIFYTIME"] != null && row["VERM_MODIFYTIME"].ToString() != "") { model.VERM_MODIFYTIME = DateTime.Parse(row["VERM_MODIFYTIME"].ToString()); } if (row["VERM_ADDUSERID"] != null && row["VERM_ADDUSERID"].ToString() != "") { model.VERM_ADDUSERID = decimal.Parse(row["VERM_ADDUSERID"].ToString()); } } return(model); }
private void modelTree_AfterNodeSelect(object sender, AdvTreeNodeEventArgs e) { if (e.Node.Tag is Maticsoft.Model.SMT_VERMODEL_INFO) { Maticsoft.Model.SMT_VERMODEL_INFO model = e.Node.Tag as Maticsoft.Model.SMT_VERMODEL_INFO; if (model != null) { _lastSelectModel = model; ShowModelReportPreview(_lastSelectModel); } } else if (e.Node.Tag is FileInfo)//示例模板 { try { var dt = StaffDataHelper.GetTestReportDataTable(); FileInfo fi = (FileInfo)e.Node.Tag; _report.Clear(); _report.Load(fi.FullName); _report.RegisterData(dt, dt.TableName); _report.AutoFillDataSet = true; _report.Prepare(); _report.ShowPrepared(); } catch (Exception ex) { log.Error("预览示例模板异常:", ex); WinInfoHelper.ShowInfoWindow(this, "预览示例模板异常:" + ex.Message); } } }
private Maticsoft.Model.SMT_VERMODEL_INFO GetSelectModel() { if (modelTree.SelectedNode == null || modelTree.SelectedNode.Tag == null) { return(null); } Maticsoft.Model.SMT_VERMODEL_INFO model = modelTree.SelectedNode.Tag as Maticsoft.Model.SMT_VERMODEL_INFO; return(model); }
private void ShowModelReportPreview(Maticsoft.Model.SMT_VERMODEL_INFO model) { try { _report.Clear(); byte[] content = model.VERM_CONTENT; MemoryStream ms = new MemoryStream(content); _report.Load(ms); ms.Dispose(); var dt = StaffDataHelper.GetTestReportDataTable(); _report.RegisterData(dt, dt.TableName); _report.AutoFillDataSet = true; _report.Prepare(); _report.ShowPrepared(); } catch (Exception ex) { WinInfoHelper.ShowInfoWindow(this, "预览模板异常:" + ex.Message); log.Error("预览模板异常:", ex); } }
private void ShowModels(List <Maticsoft.Model.SMT_VERMODEL_INFO> infos) { modelTree.Nodes[1].Nodes.Clear(); foreach (var item in infos) { Node model = new Node(item.VERM_NAME); model.Tag = item; modelTree.Nodes[1].Nodes.Add(model); if (_lastSelectModel != null && _lastSelectModel.ID == item.ID) { _lastSelectModel = item; modelTree.SelectedNode = model; } } if (_lastSelectModel == null) { _report.Clear(); _report.Prepare(); _report.ShowPrepared(); } modelTree.ExpandAll(); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.SMT_VERMODEL_INFO model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SMT_VERMODEL_INFO set "); strSql.Append("VERM_CONTENT=@VERM_CONTENT,"); strSql.Append("VERM_ADDTIME=@VERM_ADDTIME,"); strSql.Append("VERM_MODIFYTIME=@VERM_MODIFYTIME,"); strSql.Append("VERM_ADDUSERID=@VERM_ADDUSERID"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@VERM_CONTENT", SqlDbType.VarBinary, -1), new SqlParameter("@VERM_ADDTIME", SqlDbType.DateTime), new SqlParameter("@VERM_MODIFYTIME", SqlDbType.DateTime), new SqlParameter("@VERM_ADDUSERID", SqlDbType.Decimal, 9), new SqlParameter("@ID", SqlDbType.Decimal, 9), new SqlParameter("@VERM_NAME", SqlDbType.NVarChar, 100) }; parameters[0].Value = model.VERM_CONTENT; parameters[1].Value = model.VERM_ADDTIME; parameters[2].Value = model.VERM_MODIFYTIME; parameters[3].Value = model.VERM_ADDUSERID; parameters[4].Value = model.ID; parameters[5].Value = model.VERM_NAME; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.SMT_VERMODEL_INFO GetModel(decimal ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,VERM_NAME,VERM_CONTENT,VERM_ADDTIME,VERM_MODIFYTIME,VERM_ADDUSERID from SMT_VERMODEL_INFO "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Decimal) }; parameters[0].Value = ID; Maticsoft.Model.SMT_VERMODEL_INFO model = new Maticsoft.Model.SMT_VERMODEL_INFO(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }