/// <summary> /// 新增员工和地域之间的关联记录 /// </summary> /// <param name="cat"></param> /// <param name="user_id"></param> /// <returns></returns> public ERROR_CODE Insert(sys_resource_territory cat, long user_id) { cat.id = (int)_dal.GetNextIdCom(); //不得插入重复数据 var kk = new sys_resource_territory_dal().FindSignleBySql <sys_resource_territory>($"select * from sys_resource_territory where territory_id={cat.territory_id} and resource_id={cat.resource_id} and delete_time=0"); if (kk != null) { return(ERROR_CODE.EXIST); } new sys_resource_territory_dal().Insert(cat); return(ERROR_CODE.SUCCESS); }
protected void Save_Click(object sender, EventArgs e) { StringBuilder name = new StringBuilder(); sys_resource_territory cat = new sys_resource_territory(); foreach (ListItem item in this.AccountList.Items) { if (item.Selected) { cat.territory_id = (int)id; cat.resource_id = Convert.ToInt64(item.Value); name.Append("{'id':'" + Convert.ToInt64(item.Value) + "','name':'" + (item.Text) + "'},"); STBLL.Insert(cat, GetLoginUserId()); } } string k = name.ToString().TrimEnd(','); Response.Write("<script>window.opener.document.getElementById(\"txtId\").value=\"" + k + "\";window.opener.kkk();window.close();</script>"); }