protected void post_Click(object sender, EventArgs e) { ResumeInfoDataContext db = new ResumeInfoDataContext(); string sql = "insert Career (cdept,cmail,ctransfer,cname,cpot,ccontent,cquality,ctype,cvalid,ctime) Values (@id,'@mail',@transfer,'@name','@pot','@content','@quality',@type,@valid,'@time')"; sql = sql.Replace("@id", getDeptId(department.List.SelectedItem.Text)); sql = sql.Replace("@mail", email.Text); if (transfer.SelectedItem.Text.Equals("是")) { sql = sql.Replace("@transfer", "1"); } else { sql = sql.Replace("@transfer", "0"); } sql = sql.Replace("@name", jobname.Text); sql = sql.Replace("@pot", location.Text); sql = sql.Replace("@content", responsbility.Text.Replace("\r\n", "<br>")); sql = sql.Replace("@quality", quality.Text.Replace("\r\n", "<br>")); sql = sql.Replace("@type", Request["type"]); sql = sql.Replace("@valid", "1"); sql = sql.Replace("@time", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); db.ExecuteCommand(sql); Response.Redirect(Request.Url.ToString()); }
protected void submit_click(object sender, EventArgs e) { ResumeInfoDataContext db = new ResumeInfoDataContext(); string sql; if (Request["type"].Equals("1") || Request["type"].Equals("2")) { sql = "Update Career set cdept=@dept,cmail='@mail',ctransfer=@transfer,cname='@name',cpot='@pot',ccontent='@content',cquality='@quality',ctime='@time' where cid = @id"; sql = sql.Replace("@dept", getDeptId(department2.SelectedItem.Text)); sql = sql.Replace("@mail", mail2.Text); if (transfer2.SelectedItem.Text.Equals("是")) { sql = sql.Replace("@transfer", "1"); } else { sql = sql.Replace("@transfer", "0"); } sql = sql.Replace("@name", name2.Text); sql = sql.Replace("@pot", pot2.Text); sql = sql.Replace("@content", responsbility2.Text.Replace("\r\n", "<br>")); sql = sql.Replace("@quality", quality2.Text.Replace("\r\n", "<br>")); sql = sql.Replace("@time", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); sql = sql.Replace("@id", Request["id"]); db.ExecuteCommand(sql); Response.Redirect("~/Pages/JobMgt.aspx?type=" + Request["type"]); } }
protected void submit_click(object sender, EventArgs e) { ResumeInfoDataContext db = new ResumeInfoDataContext(); string sql; if (Request["type"].Equals("3") || Request["type"].Equals("4")) { if (Request["type"].Equals("3")) { sql = "Update Career set cname='@name',cpot='@pot',ceducation='@education',cnumber='@number',ctime='@time' where cid = @id"; } else { sql = "Update Career set cname='@name',cpot='@pot',ceducation='@education',cnumber='@number',ctime='@time',cdisplay=@display where cid = @id"; if (dropdownlist.SelectedItem.Text.Equals("是")) { sql = sql.Replace("@display", "1"); } else { sql = sql.Replace("@display", "0"); } } sql = sql.Replace("@name", name2.Text); sql = sql.Replace("@pot", pot2.Text); sql = sql.Replace("@education", education2.Text); sql = sql.Replace("@number", number2.Text); sql = sql.Replace("@time", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); sql = sql.Replace("@id", Request["id"]); db.ExecuteCommand(sql); Response.Redirect("~/Pages/JobMgt.aspx?type=" + Request["type"]); } }
private void CreateItem(ResumeInfoDataContext db) { string sql = "Insert @table (Label, DisOrder, IsShow) Values ('@Label', @DisOrder, '@IsShow')"; sql = sql.Replace("@table", ViewState["type"].ToString()); sql = sql.Replace("@Label", Label.Text); sql = sql.Replace("@DisOrder", "0" + DisOrder.Text); sql = sql.Replace("@IsShow", IsShow.SelectedValue); db.ExecuteCommand(sql); }
protected void cancelJob(object sender, EventArgs e) { LinkButton lb = (LinkButton)sender; ResumeInfoDataContext db = new ResumeInfoDataContext(); string sql = "Update Career set cvalid=@valid where cid = @id"; sql = sql.Replace("@valid", "0"); sql = sql.Replace("@id", lb.CommandArgument); db.ExecuteCommand(sql); Response.Redirect(Request.Url.ToString()); }
private void ModifyItem(ResumeInfoDataContext db, string id) { string sql = "Update @table Set Label = '@Label', DisOrder = @DisOrder, IsShow = '@IsShow' Where PKID = @PKID"; sql = sql.Replace("@table", ViewState["type"].ToString()); sql = sql.Replace("@Label", Label.Text); sql = sql.Replace("@DisOrder", "0" + DisOrder.Text); sql = sql.Replace("@IsShow", IsShow.SelectedValue); sql = sql.Replace("@PKID", id); db.ExecuteCommand(sql); }
protected void rePostJob(object sender, EventArgs e) { LinkButton lb = (LinkButton)sender; ResumeInfoDataContext db = new ResumeInfoDataContext(); string sql = "Update Career set cvalid=@valid, ctime='@time' where cid = @id"; sql = sql.Replace("@valid", "1"); sql = sql.Replace("@id", lb.CommandArgument); sql = sql.Replace("@time", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); db.ExecuteCommand(sql); Response.Redirect(Request.Url.ToString()); }
private bool SetzfItem() { string sql = "Update BaseInfo Set zfflag = 'True' Where UserID In (@UserID)"; string userid = ""; foreach (int id in ObjGrid.SelectedRows) { userid += id.ToString() + ","; } if (userid.Length > 0) { userid = userid.Substring(0, userid.Length - 1); } sql = sql.Replace("@UserID", userid); ResumeInfoDataContext db = new ResumeInfoDataContext(); db.ExecuteCommand(sql); return(true); }
protected void onClickSubmit(object sender, EventArgs e) { ResumeInfoDataContext db = new ResumeInfoDataContext(); for (int i = 0; i < this.GridView1.Rows.Count; i++) { string sql = "insert Career (ctype,cname,cpot,ceducation,cnumber,cdisplay,cvalid,ctime) Values (@type,'@name','@pot','@education',@num,@display,@valid,'@time')"; if (!((TextBox)(this.GridView1.Rows[i].Cells[0].FindControl("TextBox1"))).Text.Trim().Equals("")) { sql = sql.Replace("@type", Request["type"]); sql = sql.Replace("@name", ((TextBox)(this.GridView1.Rows[i].Cells[0].FindControl("TextBox1"))).Text.Trim()); sql = sql.Replace("@pot", ((TextBox)(this.GridView1.Rows[i].Cells[1].FindControl("TextBox2"))).Text.Trim()); sql = sql.Replace("@education", ((TextBox)(this.GridView1.Rows[i].Cells[2].FindControl("TextBox3"))).Text.Trim()); sql = sql.Replace("@num", ((TextBox)(this.GridView1.Rows[i].Cells[3].FindControl("TextBox4"))).Text.Trim()); if (Request["type"].Equals("4")) { if (dropdwonlist.SelectedItem.Text.Equals("是")) { sql = sql.Replace("@display", "1"); } else { sql = sql.Replace("@dispay", "0"); } } else { sql = sql.Replace("@display", "1"); } sql = sql.Replace("@valid", "1"); sql = sql.Replace("@time", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); } else { break; } db.ExecuteCommand(sql); Response.Redirect(Request.Url.ToString()); } }
protected void editAttentionClick(object sender, EventArgs e) { string page = Request["Page"]; string sql = "Update Attention Set acontent = '@acontent' where aid = @aid"; string content; if (page == "1") { content = interiorAttention.Text; } else { content = outerAttention.Text; } content = content.Replace("\r\n", "<br>"); sql = sql.Replace("@acontent", content); sql = sql.Replace("@aid", page); WebHelper.AlertMsg(sql, ClientScript); ResumeInfoDataContext db = new ResumeInfoDataContext(); db.ExecuteCommand(sql); }