public FileTemplateModel GetFileTemplateByProcCode(string ProcCode) { FileTemplateModel fileTemplate = null; using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString())) { try { try { connection.Open(); int code = new HandMadeDAL(connection).GetFileTemplateCodeByProcCode(ProcCode); fileTemplate = this.GetFileTemplate(code); } catch (Exception exception) { throw exception; } return(fileTemplate); } finally { connection.Close(); } } return(fileTemplate); }
/// <summary> /// 删除,破坏四层架构需要更改。 /// </summary> protected void DeleteButton_Click(object sender, EventArgs e) { int code = Convert.ToInt32(Page.Request.QueryString["code"]); SqlConnection sqlConn = new SqlConnection(); sqlConn.ConnectionString = FunctionRule.GetConnectionString(); HandMadeDAL hmd = new HandMadeDAL(sqlConn); hmd.UpVersionState(code); Response.Write("<script>window.close();</script>"); Response.Redirect("FileTemplateVersionList.aspx?code=" + code.ToString()); }
protected void FormView1_ItemUpdating(object sender, FormViewUpdateEventArgs e) { DropDownList ddlStatus = (DropDownList)(FormView1.Row.FindControl("IsAvailabilityDropDownList")); DropDownList ddlSave = (DropDownList)(FormView1.Row.FindControl("IsPigeonholeDropDownList")); DropDownList ddlWorkFlow = (DropDownList)(FormView1.Row.FindControl("DropDownList1")); if (ddlStatus.SelectedItem.Text == "有效") { int code = Int32.Parse(Page.Request.QueryString["Tempcode"]); SqlConnection sqlConn = new SqlConnection(); sqlConn.ConnectionString = FunctionRule.GetConnectionString(); HandMadeDAL hmd = new HandMadeDAL(sqlConn); hmd.UpVersionState(code); } e.NewValues["WorkFlowProcedureName"] = ddlWorkFlow.SelectedItem.Text; e.NewValues["IsPigeonhole"] = ddlSave.SelectedItem.Text; e.NewValues["IsAvailability"] = ddlStatus.SelectedItem.Text; }
public DataSet GetVisesMoneyByCostGroup(string ViseCodes, SqlTransaction Transaction) { HandMadeDAL edal = new HandMadeDAL(Transaction); return(edal.GetVisesMoneySqlStringByCostGroup(ViseCodes)); }
public decimal GetSumCheckMoneyByContract(string ContractCode, SqlConnection Connection) { HandMadeDAL edal = new HandMadeDAL(Connection); return(edal.GetSumCheckMoneyByContract(ContractCode)); }
public DataSet GetStartupProcedureDS(SqlConnection Connection) { HandMadeDAL edal = new HandMadeDAL(Connection); return(edal.GetProcedureDS()); }