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());
}
