protected void btnSave_Click(object sender, EventArgs e)
{
if (this.hidStatus.Value == "1")
{
this.SaveApplication();
// 1 已提交，计算初审费
// Continue save the pre-pay amount
consult_application_orderMdl orderMdl = new consult_application_orderMdl();
orderMdl.amount_payable = int.Parse(this.txtPreTypePay.Text);
orderMdl.consult_application_guid = this.hidGUID.Value;
orderMdl.order_type = 1;
Consult_ApplicationDAL.Add_consult_application_order(orderMdl);
Consult_ApplicationDAL.UpdateApplicationStatus(orderMdl.consult_application_guid, 2); // Pass
Page.Response.Redirect("MyWorklist.aspx");
}
else if (this.hidStatus.Value == "4")
{
this.SaveApplication();
// 4 初审中，计算会诊费
// Continue save the second amount
consult_application_orderMdl orderMdl = new consult_application_orderMdl();
orderMdl.amount_payable = int.Parse(this.txtConsultPay.Text);
orderMdl.consult_application_guid = this.hidGUID.Value;
orderMdl.order_type = 2;
Consult_ApplicationDAL.Add_consult_application_order(orderMdl);
Consult_ApplicationDAL.Add_preliminary_conclusions(orderMdl.consult_application_guid, this.txtPreliminary_conclusions.Text); // Pass
Consult_ApplicationDAL.UpdateApplicationStatus(orderMdl.consult_application_guid, 5); // Pass
Page.Response.Redirect("MyWorklist.aspx");
}
}
public static bool Add_consult_application_order(consult_application_orderMdl model)
{
StringBuilder strSql = new StringBuilder();
// First, delete the same type payment info??
strSql.Append("delete consult_application_order where consult_application_guid=@consult_application_guid and order_type=@order_type;");
// New
strSql.Append("insert into consult_application_order(");
strSql.Append("consult_application_guid,order_type,created_dt,modified_dt,amount_payable)");
strSql.Append(" values (");
strSql.Append("@consult_application_guid,@order_type,getdate(),getdate(),@amount_payable)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@consult_application_guid", SqlDbType.VarChar, 36),
new SqlParameter("@order_type", SqlDbType.Int, 4),
new SqlParameter("@amount_payable", SqlDbType.Float, 8)
};
parameters[0].Value = model.consult_application_guid;
parameters[1].Value = model.order_type;
parameters[2].Value = model.amount_payable;
int nCount = SqlHelper.ExecuteNonQuery(strSql.ToString(), parameters);
return(true);
}
