电子表单自订单号范例(单档)

電子表單自訂單號範例.
作法:在表單送出前呼叫JS函式,再以AJAX方法產生自訂編號,在填上單號欄位.
步驟A.先更改[表單性質維護作業]中表單的自動編碼改成N(手動編碼)
步驟B.
修改程式路徑
D:\\\Web\\\src\FRM\FormID(表單代號)\FormID.aspx.cs //在按下送單前呼叫函式填上單號,會檢查資料表是否有己有最大單號再加上1號
protected override void Page_Prender(object sender, EventArgs e)
{
base.Page_Prender(sender, e);
#region註冊使用者自訂檢查 Javascript
string tParentScript = string.Empty;
if (base.FormStatus == EFFormStatus.CREATE)
{
tParentScript = base.BtnCreateToolSendForm.Attributes["onclick"].ToString(); //<- 這行先抓出送單按鈕原來所註冊的 JS tParentScript = "if (!CheckNo('" + base.FormStatus.ToString() + "')) {return false }" + tParentScript + "";//<- 加上我要的 JS 方法到剛剛抓出的 JS 判斷之前...
base.BtnCreateToolSendForm.Attributes.Add("onclick", tParentScript); //<- 重新註冊送單按鈕 onclick 事件
this.TxtCreateToolSheetNo.InputEnabled = false; //把單號欄位改成唯讀,不讓填單者填入
}
}
//自訂編號
#region GetSerialNumber 取得自訂編號
[AjaxPro.AjaxMethod]
public string GetSerialNumber(string year, string month)
{
string s = "";
SqlConnection conn = new SqlConnection("Data Source=localhost;User Id=sa;Password=dsc;Initial Catalog=EFNET");
conn.Open();
string strSQL = "SELECT MAX(efstc002) FROM efstc where efstc002 like 'MTE%'";
SqlCommand cmd = new SqlCommand(strSQL, conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
s += dr[0] ;
s = "0000000000";
}
}
s = "MET" + year.Substring(2, 2) + int.Parse(month).ToString("00") + (int.Parse(s.Substring(7, 3)) + 1).ToString("000");
conn.Close();
cmd.Dispose();
dr.Close();
return s;
}
#endregion
步驟C.
修改程式路徑
D:\\\Web\\\src\FRM\FormID(表單代號)\FormID.js
function CheckNo(tStatus)
{
var tErr = "";
if (tStatus == "CREATE")
{
//填表時檢查
var today = new Date();
var theYear = (today.getYear()).toString(10);
var momo = .dsc.easyflowDotNet.forms.STD002.GetSerialNumber(theYear,theMonth).value; document.getElementById("MasterPage_txtCreateToolSheetNo_txt").value = momo;
}
if (document.getElementById("MasterPage_txtCreateToolSheetNo_txt").value == "")
{
tErr +="單號產生錯誤,請連絡資訊人員";
}
if (tErr == "")
{
return true;
}
else
{
alert(tErr);
return false;
}
}。