我具有此分配功能,管理员可以在其中分配警察ID到选定的memberreportID。首先,管理员将选择案件,选择地点并选择此案件所需的警官人数。例如,如果管理员选择2个警官,则它将显示2个下拉列表,所有下拉列表都绑定在一起,以列出可用的PoliceID。
protected void ddllocation_SelectedIndexChanged(object sender, EventArgs e)
{
using (var connAdd = new SqlConnection("Data Source = localhost; Initial Catalog = MajorProject; Integrated Security= SSPI"))
{
connAdd.Open();
var sql = "Select policeid from PoliceAccount where status ='available' and handle ='offcase' and postedto='" + ddllocation.SelectedValue + "'";
using (var cmdAdd = new SqlDataAdapter(sql, connAdd))
{
DataSet ds2 = new DataSet();
cmdAdd.Fill(ds2);
ddlpid1.Items.Clear();
ddlpid1.DataSource = ds2;
ddlpid1.DataTextField = "policeid";
ddlpid1.DataValueField = "policeid";
ddlpid1.DataBind();
ddlpid1.Items.Insert(0, new ListItem("Police ID", ""));
ddlpid1.SelectedIndex = 0;
ddlpid2.Items.Clear();
ddlpid2.DataSource = ds2;
ddlpid2.DataTextField = "policeid";
ddlpid2.DataValueField = "policeid";
ddlpid2.DataBind();
ddlpid2.Items.Insert(0, new ListItem("Police ID", ""));
ddlpid2.SelectedIndex = 0;
}
}
第一个SQL命令是我如何将它们插入数据库中所选memberreportID的assignto列中。我将我分配的两个PoliceID插入同一列assignto。
protected void btnAssign_Click1(object sender, EventArgs e)
{
using (var connAdd = new SqlConnection("Data Source = localhost; Initial Catalog = MajorProject; Integrated Security= SSPI"))
{
String assign = ddlpid1.SelectedValue + ", " + ddlpid2.SelectedValue + ";
connAdd.Open();
var sql = "Update MemberReport Set assignto ='" + assign + "' where memberreportID='" + lbmemberreportid.Text + "'";
using (var cmdAdd = new SqlCommand(sql, connAdd))
{
cmdAdd.ExecuteNonQuery();
}
sql = "Update PoliceAccount Set handle ='" + assign + "' where policeid ='" + ddlpid1.SelectedValue + "' OR '" + ddlpid2.SelectedValue + "'";
using (var cmdAdd = new SqlCommand(sql, connAdd))
{
cmdAdd.ExecuteNonQuery();
}
connAdd.Close();
}
}
但是,我还试图通过包含第二个sql命令将这个PoliceID输入到名为Policeaccount的表中。该警察帐户有一个名为的列handle
,用于显示他目前正在处理的memberreportID。我试图让每个PoliceID的帐户通过使用OR函数将选定的memberreportID接收到其handle列中。我很确定有一个SQL语法的OR函数。但是当我尝试插入时出现此错误
An expression of non-boolean type specified in a context where a condition is expected, near ''.
它应该如下
sql = "Update PoliceAccount Set handle ='" + assign + "' where policeid ='" + ddlpid1.SelectedValue + "' OR policeid = '" + ddlpid2.SelectedValue + "'";
语法是
UPDATE tblName Set col1 ='value'
WHERE col2 ='value2'
OR col2 ='value3'
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句