注册表格,每月允许两次参赛 [英] A registration form which allows two entries per month
本文介绍了注册表格,每月允许两次参赛的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
以下是每月只允许两个条目的网络表单。数据正在插入但我不知道如何每月仅验证两个条目。
这是我到目前为止所做的...
受保护 void btnSubmit_Click( object sender,EventArgs e)
{
Hashtable empSession =(Hashtable)Session [ UserDetails];
employeeno = Convert.ToInt32(empSession [ EmpNo]);
int slno = Convert.ToInt32(get_max( 从WFHCO_RQST中选择最大值(ID)))+ 1 ;
string k;
k = slno.ToString();
string REQ_ID = REQ + k;
string EMPNO =( from i in context.CLM_EMPLOYEE_MSTs
其中 i.EMPNO.Equals(Convert.ToInt32(empSession [ EmpNo]。ToString()))
选择 i.EMPNO).SingleOrDefault ()的ToString();
string FDate = TextBox2.Text;
string TDate = TextBox3.Text;
conn.Open();
SqlCommand cmd = new SqlCommand( INSERT INTO WFHCO_RQST(PROJ_CODE,EMPNO,REQ_TYPE,STATUS,FROM_DATE,NAME,TO_DATE,NO_OF_DAYS,REASON,REQ_ID)VALUES(' + DropDownList2.SelectedValue.ToString()+ ',' + EMPNO + ',' + DropDownList1.SelectedValue.ToString()+ ','等待批准', ' + TextBox2.Text.Trim()+ ',' + TextBox3 .Text.Trim()+ ',' + TextBox4.Text + ',' + TextBox5.Text + ',' + REQ_ID + '),conn);
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
解决方案
两个选项。
1. get在你的表中这个月的条目数 - 为此你可以使用count()
2.管理一个标志 - 创建另一个有两列的表1.标志和2.月 - 当你插入你的表格你还需要更新你在这个表格中的标志,并在插入WFHCO_RQST表格之前检查这个标志值。
谢谢
AARIF SHAIKH
Below is the web form which should allow only two entries per month. Data is inserting But I have no idea how to validate only two entries per month.
This is what I have done so far..
protected void btnSubmit_Click(object sender, EventArgs e)
{
Hashtable empSession = (Hashtable)Session["UserDetails"];
employeeno = Convert.ToInt32(empSession["EmpNo"]);
int slno = Convert.ToInt32(get_max("select max(ID) from WFHCO_RQST")) + 1;
string k;
k = slno.ToString();
string REQ_ID = "REQ" + k;
string EMPNO = (from i in context.CLM_EMPLOYEE_MSTs
where i.EMPNO.Equals(Convert.ToInt32(empSession["EmpNo"].ToString()))
select i.EMPNO).SingleOrDefault().ToString();
string FDate = TextBox2.Text;
string TDate = TextBox3.Text;
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO WFHCO_RQST (PROJ_CODE,EMPNO,REQ_TYPE,STATUS,FROM_DATE,NAME,TO_DATE,NO_OF_DAYS,REASON,REQ_ID)VALUES('" + DropDownList2.SelectedValue.ToString() + "','" + EMPNO + "','" + DropDownList1.SelectedValue.ToString() + "','Awaiting Approval','" + TextBox2.Text.Trim() + "','" + TextBox3.Text.Trim() + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + REQ_ID + "')", conn);
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
解决方案
Two option for you.
1. get count of this month entry in your table - for this you can use count()
2. Manage a flag - create another table which have two columns 1. flag and 2. month - when you insert your table you also have to update your flag in this table and check this flag values before you insert in WFHCO_RQST table.
Thanks
AARIF SHAIKH
这篇关于注册表格,每月允许两次参赛的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文