private bool CheckTransferPostSortIsOccupied(string strTransNo, string strTransferSort, out Int32 i32Occupied)
{
#region
bool bResult = false;
try
{
TRNModel.VDS_TRN12_BCO BCO = new TRNModel.VDS_TRN12_BCO(ConnectionDB);
i32Occupied = 0;
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(strTransNo);
ParameterList.Add(strTransferSort);
bResult = BCO.CheckTransferSortIsOccupied(ParameterList, out i32Occupied);
return bResult;
}
catch (Exception ex)
{
throw ex;
}
#endregion
}
private DataTable GetDataByTransNo(string strTransNo)
{
#region
try
{
TRNModel.VDS_TRN12_BCO BCO = new TRNModel.VDS_TRN12_BCO(ConnectionDB);
ArrayList ParameterList = new ArrayList();
ParameterList.Add(strTransNo);
return BCO.QueryTrnasNoByCode(ParameterList);
}
catch (Exception ex)
{
throw ex;
}
#endregion
}
}//btn_Save_Click
protected void btn_Delete_Click(object sender, EventArgs e)
{
#region
try
{
#region
ErrorMsgLabel.Text = "";
if (txt_TRANS_NO.Text != "")
{
#region
TRNModel.VDS_TRN12_BCO BCO = new TRNModel.VDS_TRN12_BCO(ConnectionDB);
ArrayList ParameterList = new ArrayList();
ParameterList.Clear();
ParameterList.Add(txt_TRANS_NO.Text.Trim());
DataTable dtCheck = BCO.CheckUseTRANS_STEP_NO(ParameterList);
if (dtCheck.Rows.Count != 0)
{
ErrorMsgLabel.Text = "已被使用，不得刪除";
return;
}
dtCheck = BCO.CheckUseTRANS_NO(ParameterList);
if (dtCheck.Rows.Count != 0)
{
ErrorMsgLabel.Text = "已被使用，不得刪除";
return;
}
BCO.DEL_TRN_TRNSPO_INIT(GetQueryParams(), null);
ErrorMsgLabel.Text = "刪除成功";
string strJS = string.Format("alert('刪除成功');location.replace('TRN121.aspx?Code=TRN12&PageTimeStamp={0}');", PageTimeStamp.Value);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "DELETE_OK", strJS, true);
#endregion
}
else
{
ErrorMsgLabel.Text = "請輸入運費代號";
}
#endregion
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}//btn_Delete_Click
protected void btn_Save_Click(object sender, EventArgs e)
{
#region
try
{
#region
if (txt_TRANS_NO.Text != "")
{
Int32 i32Occupied = 0;
if (!CheckTransferPostSortIsOccupied(txt_TRANS_NO.Text.Trim(), SLP_TRANSFER_POST_SORT.Text.Trim(), out i32Occupied))
{
ErrorMsgLabel.Text = string.Format("轉運站排序順序：{0}，已被其他運費代號使用!", SLP_TRANSFER_POST_SORT.Text.Trim());
return;
}
if (string.Compare(SLP_START_DATE.Text.Trim(), SLP_END_DATE.Text.Trim(), true) > 0)
{
ErrorMsgLabel.Text = "[適用開始日/適用結束日]迄值不得小於起值";
return;
}
if (string.Compare(SLP_AC_START_DATE.Text.Trim(), SLP_AC_END_DATE.Text.Trim(), true) > 0)
{
ErrorMsgLabel.Text = "[結算開始日/結算結束日]迄值不得小於起值";
return;
}
if (CurrentPageMode == PageCurrentMode.Insert)
{
#region
TRNModel.VDS_TRN12_BCO BCO = new TRNModel.VDS_TRN12_BCO(ConnectionDB);
string strID = "", strErrMsg = "";
bool bResult = false;
bResult = BCO.ADD_TRN_TRNSPO_INIT(GetQueryParams(), null, out strID, out strErrMsg);
if (bResult && strErrMsg == "")
{
ArrayList aryTmp = new ArrayList();
aryTmp.Clear();
aryTmp.Add(strID);
aryParamsPKey = aryTmp;
s_ID = strID;
QueryData();
CurrentPageMode = PageCurrentMode.Readonly;
SetControlsByCurrentPageMode();
ErrorMsgLabel.Text = "新增成功";
}
else
{
ErrorMsgLabel.Text = strErrMsg;
}
#endregion
}
else if (CurrentPageMode == PageCurrentMode.Edit)
{
#region
TRNModel.VDS_TRN12_BCO BCO = new TRNModel.VDS_TRN12_BCO(ConnectionDB);
string strID = "", strErrMsg = "";
bool bResult = false;
bResult = BCO.UPDATE_TRN_TRNSPO_INIT(GetQueryParams(), null, out strErrMsg);
if (bResult && strErrMsg == "")
{
CurrentPageMode = PageCurrentMode.Readonly;
SetControlsByCurrentPageMode();
ErrorMsgLabel.Text = "更新成功";
}
else
{
ErrorMsgLabel.Text = strErrMsg;
}
#endregion
}
}
else
{
ErrorMsgLabel.Text = "請輸入代碼";
}
#endregion
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
UpdatePanel1.Update();
}
#endregion
}//btn_Save_Click
/// <summary>
/// 繫結資料到控制項
/// </summary>
/// <param name="vdb"></param>
private void QueryData()
{
#region
try
{
ResetControlValues();
TRNModel.VDS_TRN12_BCO BCO = new TRNModel.VDS_TRN12_BCO(ConnectionDB);
DataTable dt = null;
ArrayList ParameterList = new ArrayList();
ParameterList.Add(s_ID);
dt = BCO.QUERY_TRN_TRNSPO_INIT_BY_ID(ParameterList);
if (dt != null && dt.Rows.Count > 0)
{
txt_TRANS_NO.Text = dt.Rows[0]["TRANS_NO"].ToString().Trim();
txt_TRANS_MEMO.Text = dt.Rows[0]["TRANS_MEMO"].ToString().Trim();
SLP_START_DATE.Text = dt.Rows[0]["START_DATE"].ToString().Trim();
SLP_END_DATE.Text = dt.Rows[0]["END_DATE"].ToString().Trim();
SLP_TAX_NO.Text = dt.Rows[0]["TAX_NO"].ToString().Trim();
ddl_AC_TYPE.SelectedValue = dt.Rows[0]["AC_TYPE"].ToString().Trim();
SLP_AC_START_DATE.Text = dt.Rows[0]["AC_START_DATE"].ToString().Trim();
SLP_AC_END_DATE.Text = dt.Rows[0]["AC_END_DATE"].ToString().Trim();
ddl_TRANS_TYPE.SelectedValue = dt.Rows[0]["TRANS_TYPE"].ToString().Trim();
SLP_TRANS_VENDOR.Text = dt.Rows[0]["TRANS_VENDOR"].ToString().Trim();
ddl_TRANS_KIND.SelectedValue = dt.Rows[0]["TRANS_KIND"].ToString().Trim();
if (ddl_TRANS_KIND.SelectedValue == "2")
{
SLP_AREA.DropDownListControl.SelectedIndex = -1;
SLP_AREA.DropDownListControl.Attributes.Add("disabled", "true");
}
else
{
SLP_AREA.Text = dt.Rows[0]["AREA"].ToString().Trim();
SLP_AREA.DropDownListControl.Attributes.Add("disabled", "false");
}
chk_IS_TRANSFER_POST.Checked = dt.Rows[0]["IS_TRANSFER_POST"].ToString().Trim() == "0" ? false : true;
SLP_TRANSFER_POST_SORT.Text = dt.Rows[0]["TRANSFER_POST_SORT"].ToString().Trim();
SLP_TRANS_MONEY.Text = dt.Rows[0]["TRANS_MONEY"].ToString().Trim();
}
else
{
ErrorMsgLabel.Text = "查無資料或原始資料已被刪除";
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
/// <summary>
/// 繫結資料到控制項
/// </summary>
/// <param name="vdb"></param>
private void QueryData()
{
#region
string SessionIDName = string.Format("{0}_{1}", PAGE_DT_01, PageTimeStamp.Value);
TRNModel.VDS_TRN12_BCO BCO = new TRNModel.VDS_TRN12_BCO(ConnectionDB);
DataTable dt = null;
dt = BCO.QUERY_TRN_TRNSPO_INIT(GetQueryParams());
Session[SessionIDName] = dt;
Int32 iRowCount = 0;
aryParamsPKey.Clear();
GridView1.DataSource = dt;
GridView1.PageSize = (TextBoxPagesize.Text == "") ? 10 : (int.Parse(TextBoxPagesize.Text) <= 0) ? 10 : int.Parse(TextBoxPagesize.Text);
GridView1.PageIndex = 0;
GridView1.DataBind();
if (dt != null && dt.Rows.Count > 0)
{
iRowCount = dt.Rows.Count;
foreach (DataRow dr in dt.Rows)
{
#region
aryParamsPKey.Add(dr["ID"].ToString());
#endregion
}
}
else
{
ErrorMsgLabel.Text = "查無資料";
}
Session[string.Format("{0}_{1}", strPreFixed, PageTimeStamp.Value)] = aryParamsPKey;
LabelQueryRecordCount.Text = string.Format(" {0} Rows ", iRowCount);
#endregion
}
public SLP_TRN_TransNo()
{
co_main = new TRNModel.VDS_TRN12_BCO(ConntionDB);
}
