protected void btnSubmit_Click(object sender, EventArgs e) { //保存 Workflow_ReportMainEntity _rm = new Workflow_ReportMainEntity(); _rm.ReportID = 0; _rm.ReportName = txtReportName.Text.Trim(); _rm.ReportTypeID = Convert.ToInt32(ddlReportType.SelectedValue); _rm.FormID = Convert.ToInt32(txtFormID.Value.Trim()); _rm.WorkflowID = txtWorkflowID.Value.Trim(); string sResult = DbHelper.GetInstance().AddWorkflow_ReportMain(_rm); if (sResult == " -1") { string strScript = "<script type='text/javascript' lanuage='javascript'> alert('" + ResourceManager.GetString("Operation_RECORD") + "'); </script>"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", strScript, false); } else { string strScript = "<script type='text/javascript' lanuage='javascript'> alert('" + ResourceManager.GetString("Button_GoComplete") + "'); </script>"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", strScript, false); } divWF.Visible = true; System.Web.UI.ScriptManager.RegisterStartupScript(btnSubmit, this.GetType(), "ButtonHideScript", strButtonHideScript, false); }
protected void btnSave_Click(object sender, EventArgs e) { Workflow_ReportMainEntity rm = new Workflow_ReportMainEntity(); rm.ReportID = Int32.Parse(txtReportID.Value); rm.ReportTypeID = Int32.Parse(ddlReportType.SelectedValue.Trim()); string strR = DbHelper.GetInstance().UpdateWorkflow_ReportMainReportType(rm); if (Int32.Parse(strR) > 0) { lblmsg.InnerText = ResourceManager.GetString("Button_GoComplete"); } else { lblmsg.InnerText = ResourceManager.GetString("Operation_RECORD"); } System.Web.UI.ScriptManager.RegisterStartupScript(btnSave, this.GetType(), "ButtonHideScript", strButtonHideScript, false); }
private Workflow_ReportMainEntity GetWorkflow_ReportMainFromIDataReader(DbDataReader dr) { Workflow_ReportMainEntity dt = new Workflow_ReportMainEntity(); if (dr.FieldCount > 0) { if (dr["ReportID"].ToString() != "" || dr["ReportID"] != null) dt.ReportID = Int32.Parse(dr["ReportID"].ToString()); if (dr["ReportTypeID"].ToString() != "" || dr["ReportTypeID"] != null) dt.ReportTypeID = Int32.Parse(dr["ReportTypeID"].ToString()); dt.ReportName = dr["ReportName"].ToString(); if (dr["FormID"].ToString() != "" || dr["FormID"] != null) dt.FormID = Int32.Parse(dr["FormID"].ToString()); dt.WorkflowID = dr["WorkflowID"].ToString(); dr.Close(); return dt; } dr.Close(); return null; }
/// <summary> /// 修改报表类型信息 /// </summary> /// <param name="_Workflow_ReportMainEntity"></param> /// <returns>返回string "-1"表示该已经存在,否则成功 </returns> public string UpdateWorkflow_ReportMainReportType(Workflow_ReportMainEntity _Workflow_ReportMainEntity) { DbParameter[] pramsUpdate = { MakeInParam("@ReportID",(DbType)SqlDbType.Int,4,_Workflow_ReportMainEntity.ReportID ), MakeInParam("@ReportTypeID",(DbType)SqlDbType.Int,4,_Workflow_ReportMainEntity.ReportTypeID ) }; StringBuilder sb = new StringBuilder(); sb.Append("Update [dbo].[Workflow_ReportMain]"); sb.Append(" set "); sb.Append(" [ReportTypeID]=@ReportTypeID"); sb.Append(" where [ReportID]=@ReportID"); return ExecuteNonQuery(CommandType.Text, sb.ToString(), pramsUpdate).ToString(); }
/// <summary> /// 新增信息 /// </summary> /// <param name="_Workflow_ReportMainEntity"></param> /// <returns>返回string "-1"表示该已经存在,否则成功 </returns> public string AddWorkflow_ReportMain(Workflow_ReportMainEntity _Workflow_ReportMainEntity) { //判断该记录是否已经存在 DbParameter[] prams = { MakeInParam("@ReportTypeID",(DbType)SqlDbType.Int,4,_Workflow_ReportMainEntity.ReportTypeID ), MakeInParam("@ReportName",(DbType)SqlDbType.VarChar,200,_Workflow_ReportMainEntity.ReportName ) }; string sql = " select * from Workflow_ReportMain where ReportTypeID=@ReportTypeID and ReportName=@ReportName"; if (ExecuteDataset(CommandType.Text, sql, prams).Tables[0].Rows.Count > 0) { return "-1";//该记录已经存在 } else { DbParameter[] pramsInsert = { MakeInParam("@ReportTypeID",(DbType)SqlDbType.Int,4,_Workflow_ReportMainEntity.ReportTypeID ), MakeInParam("@ReportName",(DbType)SqlDbType.VarChar,200,_Workflow_ReportMainEntity.ReportName ), MakeInParam("@FormID",(DbType)SqlDbType.Int,4,_Workflow_ReportMainEntity.FormID ), MakeInParam("@WorkflowID",(DbType)SqlDbType.VarChar,2000,_Workflow_ReportMainEntity.WorkflowID ) }; StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO [dbo].[Workflow_ReportMain]"); sb.Append("("); sb.Append("[ReportTypeID]"); sb.Append(",[ReportName]"); sb.Append(",[FormID]"); sb.Append(",[WorkflowID]"); sb.Append(") "); sb.Append(" VALUES ("); sb.Append("@ReportTypeID,"); sb.Append("@ReportName,"); sb.Append("@FormID,"); sb.Append("@WorkflowID);"); sb.Append("select @@identity;"); return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString(); } }