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);
}
