/// <summary>
/// 删除教学班数据
/// </summary>
/// <param name="jxbbh">教学班编号</param>
public static void Delete(string jxbbh)
{
Database db = new Database(); //实例化一个Database类
string sql = "Delete from [jxbb] Where [jxbbh] = "
+ SqlStringConstructor.GetQuotedString(jxbbh);
db.ExecuteSQL(sql);
}
public static DataTable Query(Hashtable queryItems)
{
string where = SqlStringConstructor.GetConditionClause(queryItems);
string sql = "Select * From [bjb] " + where;
Database db = new Database();
return(db.GetDataTable(sql));
}
protected void BtnAdd_Click(object sender, System.EventArgs e)
{
System.Collections.Hashtable hashtable = new System.Collections.Hashtable();
hashtable.Add("NodeID", this.nodeID.ToString());
hashtable.Add("OrderNumber", this.txtOrder.Text.Trim());
string pStr;
if (this.RbAnd.Checked)
{
pStr = "1";
}
else
{
if (this.RbOr.Checked)
{
pStr = "0";
}
else
{
pStr = "";
}
}
hashtable.Add("AndOr", SqlStringConstructor.GetQuotedString(pStr));
hashtable.Add("ConditionField", SqlStringConstructor.GetQuotedString(this.ddltCondition.SelectedValue.ToString()));
hashtable.Add("FieldType", SqlStringConstructor.GetQuotedString(this.hdnFieldType.Value));
hashtable.Add("ConditionType", SqlStringConstructor.GetQuotedString(this.ddltConditionType.SelectedValue.ToString()));
hashtable.Add("ConditionValue", this.txtConditionValue.Text.Trim());
DataRow dataRow = FlowTemplateAction.QueryOrderNumberList(this.nodeID, System.Convert.ToInt32(this.txtOrder.Text.Trim()));
if (dataRow != null)
{
if (dataRow["NodeID"].ToString() != "" && dataRow["NodeID"] != null)
{
string where = "where NodeId = " + this.nodeID.ToString() + " and OrderNumber = " + this.txtOrder.Text.Trim();
if (FlowTemplateAction.UpdNodeCondition(hashtable, where))
{
this.JS.Text = "alert('更改成功！');window.returnValue=false;window.close();";
return;
}
}
else
{
if (FlowTemplateAction.AddNodeCondition(hashtable))
{
this.JS.Text = "alert('增加成功！');window.returnValue=false;window.close();";
return;
}
}
}
else
{
if (FlowTemplateAction.AddNodeCondition(hashtable))
{
this.JS.Text = "alert('增加成功！');window.returnValue=false;window.close();";
}
}
}
/// <summary>
/// 删除课程设计任务
/// </summary>
/// <param name="sxbh"></param>
public static void Delete(string jsbh, string kcsjmc, string jxbmc, string kbxn, string kbxq)
{
Database db = new Database(); //实例化一个Database类
string sql = "Delete from [js_kcsj_gxb] Where [jsbh] = "
+ SqlStringConstructor.GetQuotedString(jsbh) + " And [kcsjbh] = (select kcsjbh from [kcsjb] where kcsjmc = "
+ SqlStringConstructor.GetQuotedString(kcsjmc) + ") And [jxbbh] = (select jxbbh from [jxbb] where jxbmc = " + SqlStringConstructor.GetQuotedString(jxbmc)
+ ") And [kbxn] = " + SqlStringConstructor.GetQuotedString(kbxn) + " And [kbxq] = " + SqlStringConstructor.GetQuotedString(kbxq);
db.ExecuteSQL(sql);
}
private void addFlowChart_top1()
{
int rowNum = 1;
System.Collections.Hashtable hashtable = new System.Collections.Hashtable();
hashtable.Add("TemplateID", this.TemplateID.ToString());
hashtable.Add("RowNum", rowNum.ToString());
hashtable.Add("Column1", SqlStringConstructor.GetQuotedString("1;0;开始"));
FlowTemplateAction.QueryFlowChart_top1(this.TemplateID, rowNum);
}
/// <summary>
/// 删除实习任务
/// </summary>
/// <param name="sxbh"></param>
public static void Delete(string jsbh, string bysjlx, string kbxn, string kbxq)
{
Database db = new Database(); //实例化一个Database类
string sql = "Delete from [bysjb] Where [jsbh] ="
+ SqlStringConstructor.GetQuotedString(jsbh) + " And [bysjlx] = " + SqlStringConstructor.GetQuotedString(bysjlx)
+ " And [kbxn] = " + SqlStringConstructor.GetQuotedString(kbxn) + " And [kbxq] = "
+ SqlStringConstructor.GetQuotedString(kbxq);
db.ExecuteSQL(sql);
}
private void Query()
{
Database db = new Database();
DataTable dt = new DataTable();
string strXnd = selXnxz.SelectedItem.Text;
dt = db.GetDataTable("exec proYxGzlBb " + SqlStringConstructor.GetQuotedString(strXnd) + " , " + SqlStringConstructor.GetQuotedString(selYxmc.Value));
GV.DataSource = dt;
GV.DataBind();
}
/// <summary>
/// “保存”按钮单击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_ServerClick(object sender, EventArgs e)
{
if (btnAdd.Disabled == true)
{
if (Gzl.BusinessLogicLayer.YX.HasYX(txtYxbh.Value.Trim()))
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('院系编号已存在！');</script>");
txtYxbh.Value = "";
txtYxmc.Value = "";
}
else
{
//构造YX信息哈希表
Hashtable hash = new Hashtable();
hash.Add("yxbh", SqlStringConstructor.GetQuotedString(txtYxbh.Value.Trim()));
hash.Add("yxmc", SqlStringConstructor.GetQuotedString(txtYxmc.Value.Trim()));
hash.Add("yxbz", Convert.ToInt32(selYxbz.Value));
Gzl.BusinessLogicLayer.YX.Add(hash);
txtYxbh.Value = "";
txtYxmc.Value = "";
txtYxbh.Disabled = true;
txtYxmc.Disabled = true;
selYxbz.Disabled = true;
btnAdd.Disabled = false;
btnSave.Disabled = true;
btnCancel.Disabled = true;
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('添加成功');</script>");
Query();
}
}
if (btnChag.Disabled == true)
{
Hashtable ht = new Hashtable();
ht.Add("yxmc", SqlStringConstructor.GetQuotedString(txtYxmc.Value.Trim()));
ht.Add("yxbz", Convert.ToInt32(selYxbz.Value));
string where = "Where yxbh = " + SqlStringConstructor.GetQuotedString(txtYxbh.Value);
Gzl.BusinessLogicLayer.YX.Update(ht, where);
txtYxbh.Value = "";
txtYxmc.Value = "";
btnSave.Disabled = true;
btnCancel.Disabled = true;
btnChag.Disabled = false;
txtYxbh.Disabled = true;
txtYxmc.Disabled = true;
selYxbz.Disabled = true;
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改成功');</script>");
Query();
}
}
/// <summary>
/// 删除实习任务
/// </summary>
/// <param name="sxbh"></param>
public static void Delete(string jsbh, string bjmc, string sxlx, string kbxn, string kbxq)
{
Database db = new Database(); //实例化一个Database类
string sql = "Delete from [sxb] Where [jsbh] ="
+ SqlStringConstructor.GetQuotedString(jsbh) + " And [bjbh] = (select bjbh from [bjb] where bjmc = "
+ SqlStringConstructor.GetQuotedString(bjmc) + ") And [sxlx] = " + SqlStringConstructor.GetQuotedString(sxlx)
+ " And [kbxn] = " + SqlStringConstructor.GetQuotedString(kbxn) + " And [kbxq] = "
+ SqlStringConstructor.GetQuotedString(kbxq);
db.ExecuteSQL(sql);
}
/// <summary>
/// 根据参数Jxbbh，获取教学班详细信息
/// </summary>
/// <param name="jxbbh">教学班编号</param>
public static DataTable LoadDataGX(string jxbbh)
{
Database db = new Database(); //实例化一个Database类
string sql = "";
sql = "Select * from [bj_jxb_gxb],[bjb] where jxbbh = "
+ SqlStringConstructor.GetQuotedString(jxbbh)
+ " And [bj_jxb_gxb].bjbh=[bjb].bjbh ";
return(db.GetDataTable(sql));
}
public int Add(ProviderInfoModel model, string bs)
{
string str = "";
if (bs == "0")
{
str = FormsAuthentication.HashPasswordForStoringInConfigFile(this.SysPwd, "md5");
}
if (bs == "1")
{
str = FormsAuthentication.HashPasswordForStoringInConfigFile(model.PassWord, "md5");
}
int num = int.Parse(publicDbOpClass.QuaryMaxid("pm_provider_info", "ProviderId")) + 1;
StringBuilder builder = new StringBuilder();
builder.Append("insert into pm_provider_info(");
builder.Append("ProviderId,ClassId,ProviderName,ProviderICode,State,ServiceArea,Address,Contacter,Telphon,Mobile,WebStie,[E-mail],PriceRange,Comment,UserName,PassWord,UserCode,RecordDate,ProduceDimensions,TradeStatus,MarketDispositionf,BusinessStanding,CraftworkEquip,ProductQuality,ManufacturingCapacity,Equip,Manpower,OutstandingAchievement,ServiceEnsure,MarketingStrategy");
builder.Append(")");
builder.Append(" values (");
builder.Append(num.ToString() + ",");
builder.Append(model.ClassId.ToString() + ",");
builder.Append(SqlStringConstructor.GetQuotedString(model.ProviderName.Trim()) + ",");
builder.Append(SqlStringConstructor.GetQuotedString(model.ProviderICode.Trim()) + ",");
builder.Append("'" + model.State + "',");
builder.Append(SqlStringConstructor.GetQuotedString(model.ServiceArea.Trim()) + ",");
builder.Append(SqlStringConstructor.GetQuotedString(model.Address.Trim()) + ",");
builder.Append(SqlStringConstructor.GetQuotedString(model.Contacter.Trim()) + ",");
builder.Append(SqlStringConstructor.GetQuotedString(model.Telphon.Trim()) + ",");
builder.Append(SqlStringConstructor.GetQuotedString(model.Mobile.Trim()) + ",");
builder.Append(SqlStringConstructor.GetQuotedString(model.WebStie.Trim()) + ",");
builder.Append(SqlStringConstructor.GetQuotedString(model.Email.Trim()) + ",");
builder.Append(SqlStringConstructor.GetQuotedString(model.PriceRange.Trim()) + ",");
builder.Append(SqlStringConstructor.GetQuotedString(model.Comment.Trim()) + ",");
builder.Append(SqlStringConstructor.GetQuotedString(model.UserName.Trim()) + ",");
builder.Append("'" + str + "',");
builder.Append("'" + model.UserCode + "',");
builder.Append("'" + model.RecordDate + "',");
builder.Append("'" + model.ProduceDimensions + "',");
builder.Append("'" + model.TradeStatus + "',");
builder.Append("'" + model.MarketDispositionf + "',");
builder.Append("'" + model.BusinessStanding + "',");
builder.Append("'" + model.CraftworkEquip + "',");
builder.Append("'" + model.ProductQuality + "',");
builder.Append("'" + model.ManufacturingCapacity + "',");
builder.Append("'" + model.Equip + "',");
builder.Append("'" + model.Manpower + "',");
builder.Append("'" + model.OutstandingAchievement + "',");
builder.Append("'" + model.ServiceEnsure + "',");
builder.Append("'" + model.MarketingStrategy + "'");
builder.Append(")");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
/// <summary>
/// “保存”按钮单击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_ServerClick(object sender, EventArgs e)
{
if (btnAdd.Disabled == true)
{
if (Gzl.BusinessLogicLayer.User.HasUser(txtCzy.Value))
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('存在相同操作员名称！');</script>");
txtCzy.Value = "";
}
else
{
//构造user信息哈希表
Hashtable hash = new Hashtable();
hash.Add("czy", SqlStringConstructor.GetQuotedString(txtCzy.Value.Trim()));
hash.Add("yxbh", SqlStringConstructor.GetQuotedString(selSsyx.Value));
hash.Add("qx", SqlStringConstructor.GetQuotedString(selQx.Value));
//初始密码为用户登录名
string dlmm = Encrypt.EncryptString(txtCzy.Value.Trim(), txtCzy.Value.Trim()); //加密
hash.Add("dlmm", SqlStringConstructor.GetQuotedString(dlmm));
Gzl.BusinessLogicLayer.User.Add(hash);
selSsyx.Disabled = true;
txtCzy.Disabled = true;
selQx.Disabled = true;
txtCzy.Value = "";
btnAdd.Disabled = false;
btnSave.Disabled = true;
btnCancel.Disabled = true;
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('添加成功');</script>");
Query();
}
}
if (btnChag.Disabled == true)
{
Hashtable ht = new Hashtable();
ht.Add("yxbh", SqlStringConstructor.GetQuotedString(selSsyx.Value));
ht.Add("qx", SqlStringConstructor.GetQuotedString(selQx.Value));
string where = "Where czy = " + SqlStringConstructor.GetQuotedString(txtCzy.Value);
Gzl.BusinessLogicLayer.User.Update(ht, where);
txtCzy.Value = "";
selSsyx.Disabled = true;
txtCzy.Disabled = true;
selQx.Disabled = true;
btnSave.Disabled = true;
btnCancel.Disabled = true;
btnChag.Disabled = false;
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改成功');</script>");
Query();
}
}
protected void BtnAdd_Click(object sender, System.EventArgs e)
{
string sqlString = "select v_xm from pt_yhmc where c_sfyx='y' and v_yhdm = '" + this.UserCode + "'";
object value = publicDbOpClass.ExecuteScalar(sqlString);
string pStr = System.Convert.ToString(value);
System.Guid guid = new System.Guid(this.hdnRecordId.Value);
string value2 = this.hdnDept.Value;
System.Collections.Hashtable hashtable = new System.Collections.Hashtable();
hashtable.Add("I_BULLETINID", SqlStringConstructor.GetQuotedString(guid.ToString()));
hashtable.Add("I_RELEASEBOUND", this.RBLtBound.SelectedValue.ToString());
hashtable.Add("DeptRange", SqlStringConstructor.GetQuotedString(this.hdnDept.Value));
hashtable.Add("V_TITLE", SqlStringConstructor.GetQuotedString(this.TBoxTitle.Text));
hashtable.Add("DTM_EXPRIESDATE", SqlStringConstructor.GetQuotedString(System.Convert.ToDateTime(this.dbExpriseDate.Text).ToString()));
hashtable.Add("DTM_RELEASETIME", SqlStringConstructor.GetQuotedString(this.CurrentDate.ToString()));
hashtable.Add("V_RELUSERCODE", SqlStringConstructor.GetQuotedString(this.UserCode));
hashtable.Add("V_CONTENT", SqlStringConstructor.GetQuotedString(this.txtContent.Value));
hashtable.Add("URL", SqlStringConstructor.GetQuotedString(this.tbUrl.Text));
hashtable.Add("CorpCode", SqlStringConstructor.GetQuotedString(value2));
hashtable.Add("V_RELEASEUSER", SqlStringConstructor.GetQuotedString(pStr));
if (this.TBoxTitle.Text.Trim() == "")
{
this.JS.Text = "top.ui.alert('公告标题不能为空！');";
return;
}
if (this.BulletinID == System.Guid.Empty)
{
hashtable.Add("AuditState", "-1");
if (com.jwsoft.pm.entpm.action.BulletinManage.AddBulletinInfo(hashtable))
{
base.RegisterScript("top.ui.tabSuccess({ parentName: '_BulletinManage' });");
return;
}
this.JS.Text = "top.ui.alert('保存失败！');";
return;
}
else
{
string where = " where I_BULLETINID = '" + this.BulletinID.ToString() + "'";
if (com.jwsoft.pm.entpm.action.BulletinManage.UpdBulletinInfo(hashtable, where))
{
base.RegisterScript("top.ui.tabSuccess({ parentName: '_BulletinManage' });");
return;
}
this.JS.Text = "top.ui.alert('保存失败');";
return;
}
}
/// <summary>
/// 按某个属性，升序或者降序获取所有的图书信息
/// </summary>
/// <param name="sortedColumn">排序属性</param>
/// <param name="sortType">可取{desc,asc}，分别代表降序、升序</param>
/// <returns>查询结果集</returns>
public static DataTable QueryBooks(Hashtable queryItems, string sortedColumn, string sortType)
{
if (sortType.ToUpper() != "DESC" && sortType.ToUpper() != "ASC" && sortType != "")
{
return(null);
}
string where = SqlStringConstructor.GetConditionClause(queryItems);
string constrains = " Order By " + sortedColumn + " " + sortType;
string sql = "Select * From [Book] " + where + constrains;
Database db = new Database();
return(db.GetDataTable(sql));
}
protected void BtnAdd_Click(object sender, EventArgs e)
{
Guid guid = Guid.NewGuid();
DateTime dateTime = default(DateTime);
dateTime = DateTime.Now;
Hashtable hashtable = new Hashtable();
hashtable.Add("FileID", SqlStringConstructor.GetQuotedString(guid.ToString()));
hashtable.Add("Title", SqlStringConstructor.GetQuotedString(this.txtTitle.Text));
hashtable.Add("SendCorpName", SqlStringConstructor.GetQuotedString(this.txtSendCorpName.Text));
hashtable.Add("ReceiveType", SqlStringConstructor.GetQuotedString(this.txtReceiveType.SelectedValue));
hashtable.Add("ReceiveDate", SqlStringConstructor.GetQuotedString(this.txtReceiveDate.Text));
hashtable.Add("Remark", SqlStringConstructor.GetQuotedString(this.txtRemark.Text));
hashtable.Add("IsPigeonhole", SqlStringConstructor.GetQuotedString("0"));
hashtable.Add("UserCode", SqlStringConstructor.GetQuotedString(this.UserCode));
hashtable.Add("RecordDate", SqlStringConstructor.GetQuotedString(dateTime.ToString()));
hashtable.Add("CorpCode", SqlStringConstructor.GetQuotedString(this.CorpCode));
if (this.FileUpload1.HasFile)
{
HttpPostedFile postedFile = this.FileUpload1.PostedFile;
com.jwsoft.pm.entpm.action.FileUpload fileUpload = new com.jwsoft.pm.entpm.action.FileUpload();
string[] array = fileUpload.Upload(postedFile, 1);
hashtable.Add("OriginalName", SqlStringConstructor.GetQuotedString(array[0]));
hashtable.Add("FilePath", SqlStringConstructor.GetQuotedString(array[1]));
}
if (this.FileID == Guid.Empty)
{
if (DocumentAction.AddReceiveFileInfo(hashtable))
{
this.JS.Text = "alert('保存成功！');window.returnValue=true;window.close();";
return;
}
this.JS.Text = "alert('保存失败！');";
return;
}
else
{
string where = " where FileID = '" + this.FileID.ToString() + " '";
if (DocumentAction.UpdReceiveFileInfo(hashtable, where))
{
this.JS.Text = "alert('保存成功！');window.returnValue=true;window.close();";
return;
}
this.JS.Text = "alert('保存失败！');";
return;
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
Hashtable hashtable = new Hashtable();
string value = this.hdnName.Value;
string value2 = this.hdnNumber.Value;
hashtable.Add("MeetingInfoID", this.MeetingInfoID.ToString());
hashtable.Add("CallHour", this.ddltCallTime.SelectedValue.ToString());
hashtable.Add("CallMinute", this.ddltCallMinute.SelectedValue.ToString());
hashtable.Add("Topic", SqlStringConstructor.GetQuotedString(this.txtTopic.Text));
hashtable.Add("AttendManCodes", SqlStringConstructor.GetQuotedString(this.hdnAttendManName.Value));
hashtable.Add("AttendManNames", SqlStringConstructor.GetQuotedString(value.ToString()));
hashtable.Add("Number", value2.ToString());
if (this.ckbIsSms.Checked)
{
hashtable.Add("IsSms", SqlStringConstructor.GetQuotedString("1"));
}
else
{
hashtable.Add("IsSms", SqlStringConstructor.GetQuotedString("0"));
}
hashtable.Add("Content", SqlStringConstructor.GetQuotedString(this.txtContent.Text));
if (this.RecordID == 0)
{
if (ConferenceManage.AddSubsection(hashtable))
{
this.JS.Text = "alert('保存成功！');window.returnValue=true;window.close();";
return;
}
this.JS.Text = "alert('保存失败！');";
return;
}
else
{
string where = " where RecordID = " + this.RecordID.ToString();
if (ConferenceManage.UpdSubsection(hashtable, where))
{
this.JS.Text = "alert('保存成功！');window.returnValue=true;window.close();";
return;
}
this.JS.Text = "alert('保存失败！');";
return;
}
}
/// <summary>
/// “提交”按钮单击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ButtonOK_Click(object sender, System.EventArgs e)
{
Hashtable ht = new Hashtable();
ht.Add("LoginName", SqlStringConstructor.GetQuotedString(TextBoxLoginName.Text));
ht.Add("UserName", SqlStringConstructor.GetQuotedString(TextBoxUserName.Text));
ht.Add("Password", SqlStringConstructor.GetQuotedString(TextBoxPassword.Text));
ht.Add("Address", SqlStringConstructor.GetQuotedString(TextBoxAddress.Text));
ht.Add("Zip", SqlStringConstructor.GetQuotedString(TextBoxZip.Text));
User user = new User();
user.Add(ht);
user.LoadData(TextBoxLoginName.Text);
Session.Add("user_id", user.UserID);
Response.Redirect("BookList.aspx");
}
protected void BtnAdd_Click(object sender, EventArgs e)
{
string pStr = this.ddltIsValid.SelectedValue.ToString();
DataTable dataTable = DocumentAction.QueryCorpCode(this.UserCode);
string pStr2;
if (dataTable.Rows.Count == 0)
{
pStr2 = "%";
}
else
{
pStr2 = dataTable.Rows[0]["CorpCode"].ToString();
}
Hashtable hashtable = new Hashtable();
hashtable.Add("ClassTypeCode", SqlStringConstructor.GetQuotedString(this.ClassTypeCode));
hashtable.Add("CorpCode", SqlStringConstructor.GetQuotedString(pStr2));
hashtable.Add("ClassCode", SqlStringConstructor.GetQuotedString(this.txtClassCode.Text));
hashtable.Add("ClassName", SqlStringConstructor.GetQuotedString(this.txtClassName.Text));
hashtable.Add("IsValid", SqlStringConstructor.GetQuotedString(pStr));
if (this.ClassID == 0)
{
if (DocumentAction.AddDocClass(hashtable))
{
this.JS.Text = "alert('保存成功！');window.returnValue=true;window.close();";
return;
}
this.JS.Text = "alert('保存失败！');";
return;
}
else
{
string where = " where ClassID = '" + this.ClassID + " '";
if (DocumentAction.UpdDocClass(hashtable, where))
{
this.JS.Text = "alert('保存成功！');window.returnValue=true;window.close();";
return;
}
this.JS.Text = "alert('保存失败！');";
return;
}
}
protected void Page_Load(object sender, EventArgs e)
{
Server.Execute("judgeJs.aspx");//**********************************
string loginName = Session["login_name"].ToString();
userMessage01.InnerText = "你好！" + loginName;
string xnd = Session["xnd"].ToString();
labelXnd.Text = xnd + "学年度";
Database db = new Database();
DataRow dr = db.GetDataRow("exec proJsZgzlJs " + SqlStringConstructor.GetQuotedString(loginName) + " , " + SqlStringConstructor.GetQuotedString(xnd));
txtJsbh.Value = dr["jsbh"].ToString();
txtJsxm.Value = dr["jsxm"].ToString();
txtJsxb.Value = dr["jsxb"].ToString();
txtJszc.Value = dr["zcmc"].ToString();
txtJszw.Value = dr["zwlx"].ToString();
txtSsyx.Value = dr["yxmc"].ToString();
txtZgzl.Value = dr["zgzl"].ToString();
txtGzlqk.Value = dr["gzlqk"].ToString();
DataTable dtKc = db.GetDataTable("select * from viewKcrw where jsbh = " + SqlStringConstructor.GetQuotedString(loginName) + " And kbxn = " + SqlStringConstructor.GetQuotedString(xnd));
GVKC.DataSource = dtKc;
GVKC.DataBind();
DataTable dtKcsj = db.GetDataTable("select * from viewKcsjrw where jsbh = " + SqlStringConstructor.GetQuotedString(loginName) + " And kbxn = " + SqlStringConstructor.GetQuotedString(xnd));
GVKCSJ.DataSource = dtKcsj;
GVKCSJ.DataBind();
DataTable dtSx = db.GetDataTable("select * from viewSxrw where jsbh = " + SqlStringConstructor.GetQuotedString(loginName) + " And kbxn = " + SqlStringConstructor.GetQuotedString(xnd));
GVSX.DataSource = dtSx;
GVSX.DataBind();
DataTable dtBysj = db.GetDataTable("select * from viewBysjrw where jsbh = " + SqlStringConstructor.GetQuotedString(loginName) + " And kbxn = " + SqlStringConstructor.GetQuotedString(xnd));
GVBYSJ.DataSource = dtBysj;
GVBYSJ.DataBind();
}
/// <summary>
/// 查询教学班
/// </summary>
/// <param name="queryItems"></param>
/// <returns></returns>
public static DataTable Query(Hashtable queryItems)
{
string where = SqlStringConstructor.GetConditionClause(queryItems);
string sql = "Select * from [js_kcsj_gxb],[jsb],[kcsjb],[jxbb] " + where;
if (where == "")
{
sql += " Where";
}
else
{
sql += " And";
}
sql += " [js_kcsj_gxb].jsbh=[jsb].jsbh And [js_kcsj_gxb].kcsjbh=[kcsjb].kcsjbh And [js_kcsj_gxb].jxbbh=[jxbb].jxbbh";
Database db = new Database();
return(db.GetDataTable(sql));
}
protected void BtnSave_Click(object sender, EventArgs e)
{
Hashtable hashtable = new Hashtable();
hashtable.Add("MeetingRoomID", this.hdnMeetinRoomID.Value);
hashtable.Add("HumanNumber", this.txtHumanNumber.Text);
hashtable.Add("Title", SqlStringConstructor.GetQuotedString(this.txtTitle.Text));
hashtable.Add("UserCode", SqlStringConstructor.GetQuotedString(this.hdnUserCode.Value));
hashtable.Add("UserDate", SqlStringConstructor.GetQuotedString(this.dbUserDate.Text));
hashtable.Add("BeginHour", this.ddltBeginHour.SelectedValue.ToString());
hashtable.Add("BeginMinute", this.ddltBeginMinute.SelectedValue.ToString());
hashtable.Add("EndHour", this.ddltEndHour.SelectedValue.ToString());
hashtable.Add("EndMinute", this.ddltEndMinute.SelectedValue.ToString());
hashtable.Add("Content", SqlStringConstructor.GetQuotedString(this.txtContent.Text));
hashtable.Add("State", "0");
if (this.RecordId == 0)
{
int applyRecordId = 0;
object obj = ConferenceManage.AddApplyInfo(hashtable);
if (obj != null)
{
applyRecordId = Convert.ToInt32(obj);
}
if (this.UpdateApplyEquipment(applyRecordId))
{
this.JS.Text = "alert('保存成功！');window.returnValue='" + applyRecordId.ToString() + "';window.close();";
return;
}
this.JS.Text = "alert('保存失败！');";
return;
}
else
{
string where = " where RecordID = " + this.RecordId.ToString();
if (ConferenceManage.UpdApplyInfo(hashtable, where) && this.UpdateApplyEquipment(this.RecordId))
{
this.JS.Text = "alert('保存成功！');window.returnValue='" + this.RecordId.ToString() + "';window.close();";
return;
}
this.JS.Text = "alert('保存失败！');";
return;
}
}
public int Update(ProviderInfoModel model, string flag)
{
string str = FormsAuthentication.HashPasswordForStoringInConfigFile(this.SysPwd, "md5");
StringBuilder builder = new StringBuilder();
builder.Append("update pm_provider_info set ");
builder.Append("ProviderName=" + SqlStringConstructor.GetQuotedString(model.ProviderName.Trim()) + ",");
builder.Append("ProviderICode=" + SqlStringConstructor.GetQuotedString(model.ProviderICode.Trim()) + ",");
builder.Append("ClassId=" + model.ClassId.ToString() + ",");
builder.Append("ServiceArea=" + SqlStringConstructor.GetQuotedString(model.ServiceArea.Trim()) + ",");
builder.Append("Address=" + SqlStringConstructor.GetQuotedString(model.Address.Trim()) + ",");
builder.Append("Contacter=" + SqlStringConstructor.GetQuotedString(model.Contacter.Trim()) + ",");
builder.Append("Telphon=" + SqlStringConstructor.GetQuotedString(model.Telphon.Trim()) + ",");
builder.Append("Mobile=" + SqlStringConstructor.GetQuotedString(model.Mobile.Trim()) + ",");
builder.Append("WebStie=" + SqlStringConstructor.GetQuotedString(model.WebStie.Trim()) + ",");
builder.Append("[E-mail]=" + SqlStringConstructor.GetQuotedString(model.Email.Trim()) + ",");
builder.Append("PriceRange=" + SqlStringConstructor.GetQuotedString(model.PriceRange.Trim()) + ",");
builder.Append("ProduceDimensions='" + model.ProduceDimensions + "',");
builder.Append("TradeStatus='" + model.TradeStatus + "',");
builder.Append("MarketDispositionf='" + model.MarketDispositionf + "',");
builder.Append("BusinessStanding='" + model.BusinessStanding + "',");
builder.Append("CraftworkEquip='" + model.CraftworkEquip + "',");
builder.Append("ProductQuality='" + model.ProductQuality + "',");
builder.Append("ManufacturingCapacity='" + model.ManufacturingCapacity + "',");
builder.Append("Equip='" + model.Equip + "',");
builder.Append("Manpower='" + model.Manpower + "',");
builder.Append("OutstandingAchievement='" + model.OutstandingAchievement + "',");
builder.Append("ServiceEnsure='" + model.ServiceEnsure + "',");
builder.Append("MarketingStrategy='" + model.MarketingStrategy + "',");
builder.Append("Comment=" + SqlStringConstructor.GetQuotedString(model.Comment.Trim()) + ",");
if (flag == "y")
{
builder.Append("UserName="******",");
builder.Append("PassWord='******' ");
}
else
{
builder.Append("UserName="******" where ProviderId=" + model.ProviderId.ToString());
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
protected void BtnSave_Click(object sender, EventArgs e)
{
string pStr = "%";
DataTable dataTable = DocumentAction.QueryCorpCode(this.UserCode);
if (dataTable.Rows.Count > 0)
{
pStr = dataTable.Rows[0]["CorpCode"].ToString();
}
DateTime dateTime = default(DateTime);
dateTime = DateTime.Now;
Hashtable hashtable = new Hashtable();
hashtable.Add("MeetingInfoID", this.MeetingInfoID.ToString());
hashtable.Add("UserCode", SqlStringConstructor.GetQuotedString(this.UserCode));
hashtable.Add("RecordDate", SqlStringConstructor.GetQuotedString(dateTime.ToString("yyyy-MM-dd")));
hashtable.Add("CorpCode", SqlStringConstructor.GetQuotedString(pStr));
hashtable.Add("Topic", SqlStringConstructor.GetQuotedString(this.txtTopic.Text));
hashtable.Add("Content", SqlStringConstructor.GetQuotedString(this.txtContent.Text));
if (this.RecordID == 0)
{
if (ConferenceManage.AddConferenceTopic(hashtable))
{
this.JS.Text = "alert('保存成功！');window.returnValue=true;window.close();";
return;
}
this.JS.Text = "alert('保存失败！');";
return;
}
else
{
string where = " where RecordID = " + this.RecordID.ToString();
if (ConferenceManage.UpdConferenceTopic(hashtable, where))
{
this.JS.Text = "alert('保存成功！');window.returnValue=true;window.close();";
return;
}
this.JS.Text = "alert('保存失败！');";
return;
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
DateTime dateTime = default(DateTime);
dateTime = DateTime.Now;
DateTime dateTime2 = default(DateTime);
dateTime2 = Convert.ToDateTime(this.txtCallDate.Text);
Hashtable hashtable = new Hashtable();
hashtable.Add("UserCode", SqlStringConstructor.GetQuotedString(this.UserCode));
hashtable.Add("RecordDate", SqlStringConstructor.GetQuotedString(dateTime.ToString("yyyy-MM-dd")));
hashtable.Add("MeetingTitle", SqlStringConstructor.GetQuotedString(this.txtMeetingTitle.Text));
hashtable.Add("MeetingPlace", SqlStringConstructor.GetQuotedString(this.txtMeetingPlace.Text));
hashtable.Add("CallDate", SqlStringConstructor.GetQuotedString(dateTime2.ToString("yyyy-MM-dd")));
hashtable.Add("CallTime", this.ddltCallTime.SelectedValue.ToString());
hashtable.Add("CallMinute", this.ddltCallMinute.SelectedValue.ToString());
hashtable.Add("Content", SqlStringConstructor.GetQuotedString(this.txtContent.Text));
hashtable.Add("State", "0");
hashtable.Add("PigeonholeState", SqlStringConstructor.GetQuotedString("0"));
if (this.RecordID == 0)
{
if (ConferenceManage.AddMeetingInfo(hashtable))
{
this.JS.Text = "alert('保存成功！');window.returnValue=true;window.close();";
return;
}
this.JS.Text = "alert('保存失败！');";
return;
}
else
{
string where = " where RecordID = " + this.RecordID.ToString();
if (ConferenceManage.UpdMeetingInfo(hashtable, where))
{
this.JS.Text = "alert('保存成功！');window.returnValue=true;window.close();";
return;
}
this.JS.Text = "alert('保存失败！');";
return;
}
}
/// <summary>
/// 判断是否存在登录名为loginName的用户
/// </summary>
/// <param name="loginName">用户登录名</param>
/// <returns>如果存在，返回true；否则，返回false</returns>
public static bool HasUser(string loginName)
{
Database db = new Database();
string sql = "";
sql = "Select * from [User] where [LoginName] = "
+ SqlStringConstructor.GetQuotedString(loginName);
DataRow row = db.GetDataRow(sql);
if (row != null)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 判断是否存在班级编号为bjbh
/// </summary>
/// <param name="bjbh">班级编号</param>
/// <returns>如果存在，返回true；否则，返回false</returns>
public static bool HasBJ(string bjmc)
{
Database db = new Database();
string sql = "";
sql = "Select * from [bjb] where [bjmc] = "
+ SqlStringConstructor.GetQuotedString(bjmc);
DataRow row = db.GetDataRow(sql);
if (row != null)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 查询教师
/// </summary>
/// <param name="queryItems"></param>
/// <returns></returns>
public static DataTable QueryJS(Hashtable queryItems)
{
string where = SqlStringConstructor.GetConditionClause(queryItems);
string sql = "Select * from [jsb],[yxb],[zwb],[zcb] " + where;
if (where == "")
{
sql += " Where";
}
else
{
sql += " And";
}
sql += " [jsb].yxbh = [yxb].yxbh And [jsb].zcbh = [zcb].zcbh And [jsb].zwbh = [zwb].zwbh";
Database db = new Database();
return(db.GetDataTable(sql));
}
/// <summary>
/// 判断是否存在学年度
/// </summary>
/// <param name="xnd">学年度</param>
/// <returns>如果存在，返回true；否则，返回false</returns>
public static bool HasXND(string xnd)
{
Database db = new Database();
string sql = "";
sql = "Select * from [xndb] where [xnd] = "
+ SqlStringConstructor.GetQuotedString(xnd);
DataRow row = db.GetDataRow(sql);
if (row != null)
{
return(true);
}
else
{
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
Server.Execute("judgeJxms.aspx");
string jsbh = Page.Request.QueryString["jsbh"];
string xnd = Page.Request.QueryString["xnd"];
Database db = new Database();
DataRow dr = db.GetDataRow("exec proJsZgzlJs " + SqlStringConstructor.GetQuotedString(jsbh) + " , " + SqlStringConstructor.GetQuotedString(xnd));
txtJsbh.Value = dr["jsbh"].ToString();
txtJsxm.Value = dr["jsxm"].ToString();
txtJsxb.Value = dr["jsxb"].ToString();
txtJszc.Value = dr["zcmc"].ToString();
txtJszw.Value = dr["zwlx"].ToString();
txtSsyx.Value = dr["yxmc"].ToString();
txtZgzl.Value = dr["zgzl"].ToString();
txtGzlqk.Value = dr["gzlqk"].ToString();
DataTable dtKc = db.GetDataTable("select * from viewKcrw where jsbh = " + SqlStringConstructor.GetQuotedString(jsbh) + " And kbxn = " + SqlStringConstructor.GetQuotedString(xnd));
GVKC.DataSource = dtKc;
GVKC.DataBind();
DataTable dtKcsj = db.GetDataTable("select * from viewKcsjrw where jsbh = " + SqlStringConstructor.GetQuotedString(jsbh) + " And kbxn = " + SqlStringConstructor.GetQuotedString(xnd));
GVKCSJ.DataSource = dtKcsj;
GVKCSJ.DataBind();
DataTable dtSx = db.GetDataTable("select * from viewSxrw where jsbh = " + SqlStringConstructor.GetQuotedString(jsbh) + " And kbxn = " + SqlStringConstructor.GetQuotedString(xnd));
GVSX.DataSource = dtSx;
GVSX.DataBind();
DataTable dtBysj = db.GetDataTable("select * from viewBysjrw where jsbh = " + SqlStringConstructor.GetQuotedString(jsbh) + " And kbxn = " + SqlStringConstructor.GetQuotedString(xnd));
GVBYSJ.DataSource = dtBysj;
GVBYSJ.DataBind();
btnClose.Attributes.Add("onclick", "window.close();");
}
protected void BtnSave_Click(object sender, EventArgs e)
{
int num = 0;
if (this.txtHumanNumber.Text != "")
{
num = Convert.ToInt32(this.txtHumanNumber.Text);
}
Hashtable hashtable = new Hashtable();
hashtable.Add("RecordID", this.MeetingroomID.ToString());
hashtable.Add("MeetingRoom", SqlStringConstructor.GetQuotedString(this.txtMeetingRoom.Text));
hashtable.Add("CorpCode", SqlStringConstructor.GetQuotedString(this.CorpCode.ToString()));
hashtable.Add("Location", SqlStringConstructor.GetQuotedString(this.txtLocation.Text));
hashtable.Add("HumanNumber", num.ToString());
hashtable.Add("ManagerCode", SqlStringConstructor.GetQuotedString(this.hdnUserCode.Value));
hashtable.Add("RelationMode", SqlStringConstructor.GetQuotedString(this.txtRelationMode.Text));
hashtable.Add("Content", SqlStringConstructor.GetQuotedString(this.txtContent.Text));
hashtable.Add("IsValid", SqlStringConstructor.GetQuotedString("y"));
if (this.RecordId == 0)
{
if (ConferenceManage.AddBoardroom(hashtable) && this.Update() == 1)
{
this.JS.Text = "alert('保存成功！');window.returnValue=true;window.close();";
return;
}
this.JS.Text = "alert('保存失败！');";
return;
}
else
{
string where = " where RecordID = " + this.RecordId.ToString();
if (ConferenceManage.UpdBoardroom(hashtable, where) && this.Update() == 1)
{
this.JS.Text = "alert('保存成功！');window.returnValue=true;window.close();";
return;
}
this.JS.Text = "alert('保存失败！');";
return;
}
}
