public static bool FH_Refresh_Tree(string rootfolderID) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@subprojectid", rootfolderID) }; try { string sp_name = "querytree4FH"; int result = SQLHelper2.UpdateByProc(sp_name, param); if (result > 0) { return(true); } else { return(false); } } catch (SqlException ex) { throw new Exception("执行获取方法FH_Refresh_Tree的时候出现sql异常:" + ex.Message); } catch (Exception ex) { throw ex; } }
private void saveOnline() { try { DataTable changeDt = dt.GetChanges(); foreach (DataRow dr in changeDt.Rows) { string strSave = @"UPDATE [dbo].[flow] SET [flo_online]='" + dr["flo_online"].ToString() + @"' ,[flo_finish]='" + dr["flo_finish"].ToString() + @"' WHERE flo_num = '" + dr["flo_num"].ToString() + "'"; SQLHelper2.Update(strSave); } } catch { MessageBox.Show("保存失败!"); } finally { MessageBox.Show("保存成功!"); reLoading(); dataGridView1.DataSource = dt; label1.Visible = false; } }
public string TestLink() { string result = SQLHelper2.LinkSqlDatabase(); return(ConvertHelper.resultJson(1, result)); //return mssqlserver; }
/// <summary> /// 表2读取sql数据 /// </summary> private void searchDgv2() { try { string sql2 = @" SELECT [pds_id] 产品编号 ,[glo_id] 类别代号 ,[pds_name] 产品名称 ,[pds_ename] 产品分类 ,[pds_spec] 规格型号 ,[cus_pds_id] 客户品号 ,[mak_id] 机组代号 ,[uni_id] 单位 ,[stk_id] 库位编号 ,[pur_mak] 购制代号 FROM [dbo].[PDS] WHERE pds_id LIKE '%" + toolSearchTxt.Text.Trim() + "%'or pds_name LIKE '%" + toolSearchTxt.Text.Trim() + "%'or pds_ename LIKE '%" + toolSearchTxt.Text.Trim() + "%'or pds_spec LIKE '%" + toolSearchTxt.Text.Trim() + "%'or cus_pds_id LIKE '%" + toolSearchTxt.Text.Trim() + "%'"; dataGridView1.DataSource = SQLHelper2.GetDataSet(sql2).Tables[0]; label1.Visible = false; } catch { MessageBox.Show("数据库连接失败!"); } }
/// <summary> /// 表1读取sql数据 /// </summary> private void searchDgv1() { try { string sql1 = @"SELECT [bom_id] 产品编号 ,[Expr1] 产品名称 ,[Expr2] 产品规格型号 ,[sortid] 序号 ,[pds_id] 材料编号 ,[pds_name] 材料名称 ,[pds_spec] 材料规格型号 ,[pur_mak] 购制 ,[qty] 标准用量 ,[base] 子件基量 ,[lost] 子件损耗 FROM [dbo].[GCB_BEWBOM] WHERE bom_id LIKE '%" + toolSearchTxt.Text.Trim() + "%'or Expr1 LIKE '%" + toolSearchTxt.Text.Trim() + "%'or pds_name LIKE '%" + toolSearchTxt.Text.Trim() + "%'or pds_spec LIKE '%" + toolSearchTxt.Text.Trim() + "%'or Expr2 LIKE '%" + toolSearchTxt.Text.Trim() + "%'or pds_id LIKE '%" + toolSearchTxt.Text.Trim() + "%'"; dataGridView1.DataSource = SQLHelper2.GetDataSet(sql1).Tables[0]; label1.Visible = false; } catch { MessageBox.Show("数据库连接失败!"); } }
private void loading() { string strSql = @"SELECT * FROM [dbo].[GCB_JIHUA] WHERE flo_num='" + flo_num + "'"; gunaDataGridView1.AutoGenerateColumns = false; // label1.Visible = false; gunaDataGridView1.DataSource = SQLHelper2.GetDataSet(strSql).Tables[0]; #region 根据订单数量分析,使用颜色标注状态 for (int z = 0; z < gunaDataGridView1.RowCount; z++) { if (this.gunaDataGridView1.Rows[z].Cells["Column13"].Value.ToString() == "1") { if (this.gunaDataGridView1.Rows[z].Cells["Column14"].Value.ToString() == "1") //全部材料都满足 { this.gunaDataGridView1.Rows[z].Cells["Column7"].Style.BackColor = Color.White; } if (this.gunaDataGridView1.Rows[z].Cells["Column14"].Value.ToString() == "0") //满足本单 不满足计划 { this.gunaDataGridView1.Rows[z].Cells["Column7"].Style.BackColor = Color.LightSalmon; } } if (this.gunaDataGridView1.Rows[z].Cells["Column13"].Value.ToString() == "0") { this.gunaDataGridView1.Rows[z].Cells["Column7"].Style.BackColor = Color.Red; } } #endregion }
/// <summary> /// 表3读取sql数据 /// </summary> private void searchDgv3() { try { string sql3 = @"SELECT [pds_id] 产品编号 ,[glo_id] 产品类别 ,[pds_name] 产品名称 ,[pds_spec] 规格型号 ,[cus_pds_id] 客户名称 ,[mak_name] 供应商名称 ,[stk_name] 库位名称 ,[stkqty] 库位数量 ,[uni_id] 单位 FROM [dbo].[GCB_STK] WHERE pds_id LIKE '%" + toolSearchTxt.Text.Trim() + "%'or glo_id LIKE '%" + toolSearchTxt.Text.Trim() + "%'or pds_name LIKE '%" + toolSearchTxt.Text.Trim() + "%'or pds_spec LIKE '%" + toolSearchTxt.Text.Trim() + "%'or mak_name LIKE '%" + toolSearchTxt.Text.Trim() + "%'or cus_pds_id LIKE '%" + toolSearchTxt.Text.Trim() + "%'"; dataGridView1.DataSource = SQLHelper2.GetDataSet(sql3).Tables[0]; label1.Visible = false; } catch { MessageBox.Show("数据库连接失败!"); } }
private void LoadTable() { string strSql = @"SELECT * from PDnotes WHERE PDnum LIKE '%" + toolStripTextBox1.Text.Trim() + "%' or PDcoding LIKE '%" + toolStripTextBox1.Text.Trim() + "%' order by PDtime"; dt = SQLHelper2.GetDataSet(strSql).Tables[0]; dataGridView1.DataSource = dt; }
private void reLoading() { //string strSqlRead = "SELECT [flo_line] FROM flow WHERE flo_num ='"++"' "; for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["flo_line"] = SQLHelper2.GetSingleResult("SELECT [flo_line] FROM flow WHERE flo_num ='" + dt.Rows[i]["flo_num"].ToString() + "'"); //拉线 dt.Rows[i]["flo_back"] = SQLHelper2.GetSingleResult("SELECT [flo_back] FROM flow WHERE flo_num ='" + dt.Rows[i]["flo_num"].ToString() + "'"); //返回料 dt.Rows[i]["flo_finish"] = SQLHelper2.GetSingleResult("SELECT [flo_finish] FROM flow WHERE flo_num ='" + dt.Rows[i]["flo_num"].ToString() + "'"); //订单完成 dt.Rows[i]["flo_online"] = SQLHelper2.GetSingleResult("SELECT [flo_online] FROM flow WHERE flo_num ='" + dt.Rows[i]["flo_num"].ToString() + "'"); //上线时间 } }
private void toolStripButton5_Click(object sender, EventArgs e) { int ind = dataGridView1.CurrentRow.Index; if (MessageBox.Show("请确认是否删除?", "删除提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { string strChange = @"DELETE FROM [dbo].[PDnotes] WHERE PDtime = '" + dataGridView1[1, ind].Value.ToString() + "'"; SQLHelper2.Update(strChange); MessageBox.Show("删除完成"); LoadTable(); } }
/// <summary> /// 新增 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { string loginPath = Path.Combine(System.Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "user.ini"); INIHelper.CheckPath(loginPath); string loginName = INIHelper.Read("LoginName", "1", "001", loginPath); if (true) { string strChd = "F"; if (checkBox1.Checked == true) { strChd = "T"; } else { strChd = "F"; } string strSqlPD = @"INSERT INTO [dbo].[PDnotes] ([PDtime] ,[PDnum] ,[PDcoding] ,[PDname] ,[PDlever] ,[PDclassify] ,[PDdescribe] ,[PDresult] ,[PDover] ,[PDresultDes]) VALUES ('" + DateTime.Now.ToString("yyyyMMddHHmmss") + @"' ,'" + textBox1.Text.Trim() + @"' ,'" + textBox2.Text.Trim() + @"' ,'" + textBox3.Text.Trim() + @"' ,'" + comboBox1.Text.Trim() + @"' ,'" + comboBox2.Text.Trim() + @"' ,'" + textBox4.Text.Trim() + @"' ,'" + textBox5.Text.Trim() + @"' ,'" + strChd.Trim() + @"' ,'" + textBox6.Text.Trim() + @"')"; SQLHelper2.Update(strSqlPD); MessageBox.Show("新增完成"); LoadTable(); } else { MessageBox.Show("无权限"); } }
private void frmOrderPlanAddHB_Load(object sender, EventArgs e) { string sqlHB = @"SELECT [bom_id] ,[pds_id] ,[pds_name] ,[pds_spec] ,[dfsl] ,[zfsl] ,[dgslq] ,[zgslq] ,[stkqty] ,[flo_num] ,[numss] ,[bdbig] ,[adbig] FROM [YouliData].[dbo].[GCB_FLOW_BOM_NUM1] WHERE bom_id = (SELECT TOP 1 [pds_id] FROM [YouliData].[dbo].[GCB_FLOW_BOM_NUM] WHERE flo_num = '" + floNum + "' AND pur_mak='1') AND flo_num='" + floNum + "'"; DataTable dt = SQLHelper2.GetDataSet(sqlHB).Tables[0]; gunaDataGridView1.AutoGenerateColumns = false; gunaDataGridView1.DataSource = dt; //表格颜色处理 for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["bdbig"].ToString() == "1") { if (dt.Rows[i]["adbig"].ToString() == "1") { this.gunaDataGridView1.Rows[i].Cells["Column6"].Style.BackColor = Color.White; } if (dt.Rows[i]["adbig"].ToString() == "0") { this.gunaDataGridView1.Rows[i].Cells["Column6"].Style.BackColor = Color.LightSalmon; } } else { this.gunaDataGridView1.Rows[i].Cells["Column6"].Style.BackColor = Color.Red; this.gunaDataGridView1.Rows[i].Cells["Column6"].Style.ForeColor = Color.White; } } }
/// <summary> /// 表4读取sql数据 /// </summary> private void searchDgv4() { try { string sql3 = @"SELECT [pds_id] 产品编号 ,[pds_name] 产品名称 ,[pds_spec] 规格型号 ,[hhstock] 库存数量 FROM [dbo].[GCB_HH_STOCK] WHERE pds_id LIKE '%" + toolSearchTxt.Text.Trim() + "%'or pds_name LIKE '%" + toolSearchTxt.Text.Trim() + "%'or pds_spec LIKE '%" + toolSearchTxt.Text.Trim() + "%'"; dataGridView1.DataSource = SQLHelper2.GetDataSet(sql3).Tables[0]; label1.Visible = false; } catch { MessageBox.Show("数据库连接失败!"); } }
public string GetList() { string sql = "select * from XXCLOUDALL.dbo.T_SHFYOrderInfo"; //string sql = "select * from T_BlacklistInf"; DataTable dt; try { dt = SQLHelper2.ExecuteDataTable(sql, System.Data.CommandType.Text, null); return("{\"code\":1,\"data\":" + ConvertHelper.DataTableToJson(dt) + "}"); } catch (Exception e) { //在webapi中要想抛出异常必须这样抛出,否则只抛出一个默认500的异常 var resp = new HttpResponseMessage(HttpStatusCode.InternalServerError) { Content = new StringContent(e.ToString()), ReasonPhrase = "error" }; throw new HttpResponseException(resp); } }
/// <summary> /// 删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button3_Click(object sender, EventArgs e) { if (MessageBox.Show("请确认是否删除?", "删除提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { string strChange = @"DELETE FROM [dbo].[PDnotes] WHERE PDtime = '" + textBox7.Text.Trim() + "'"; SQLHelper2.Update(strChange); MessageBox.Show("删除完成"); LoadTable(); } // string loginPath = Path.Combine(System.Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "user.ini"); //INIHelper.CheckPath(loginPath); //string loginName = INIHelper.Read("LoginName", "1", "001", loginPath); //if (true) //{ //} //else //{ // MessageBox.Show("无权限"); //} }
private void toolStripButton3_Click(object sender, EventArgs e) { DataTable dtQC; search(); //string strQCnote = @"SELECT QCcoding FROM [YouliData].[dbo].[QCnotes]"; //dtQC = SQLHelper2.GetDataSet(strQCnote).Tables[0]; //for (int i = 0; i < dt.Rows.Count; i++) //{ // for (int j = 0; j < dtQC.Rows.Count; j++) // { // if(dt.Rows[i]["flo_coding"].ToString() == dtQC.Rows[j]["QCcoding"].ToString()) // { // this.dataGridView1.Rows[i].Cells["Column4"].Style.BackColor = Color.Red; // this.dataGridView1.Rows[i].Cells["Column4"].Style.ForeColor = Color.White; // } // } //} #region //根据QC问题进行标红 string strQCnote = @"SELECT QCcoding FROM [YouliData].[dbo].[QCnotes] "; dtQC = SQLHelper2.GetDataSet(strQCnote).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { for (int j = 0; j < dtQC.Rows.Count; j++) { if (dt.Rows[i]["flo_coding"].ToString() == dtQC.Rows[j]["QCcoding"].ToString()) { this.dataGridView1.Rows[i].Cells["Column4"].Style.BackColor = Color.Red; this.dataGridView1.Rows[i].Cells["Column4"].Style.ForeColor = Color.White; } } } #endregion }
private void loading() { string strSql = @"SELECT [flo_online] ,[flo_line] ,[flo_num] ,[flo_client] ,[flo_coding] ,[flo_model] ,[flo_proname] ,[flo_range] ,[flo_plastic] ,[flo_quantity] ,[flo_finish] ,[yishangxians] ,[flo_oliquan] ,[flo_back] ,[Names] ,[Expr1] FROM GCB_LAST_JIHUA "; dt = SQLHelper2.GetDataSet(strSql).Tables[0]; label1.Visible = false; dataGridView1.DataSource = dt; }
public string AddOrderInfo(SHFY v) { string wramStr = ""; if (string.IsNullOrEmpty(v.VisitorName)) { wramStr = "访客姓名不能为空"; return(ConvertHelper.resultJson(0, wramStr)); } if (string.IsNullOrEmpty(v.VisitorSex)) { wramStr = "访客性别不能为空"; return(ConvertHelper.resultJson(0, wramStr)); } if (string.IsNullOrEmpty(v.VisitorPhone)) { wramStr = "访客电话不能为空"; return(ConvertHelper.resultJson(0, wramStr)); } if (string.IsNullOrEmpty(v.StaffNo)) { wramStr = "员工编号不能为空"; return(ConvertHelper.resultJson(0, wramStr)); } string sql = ""; SqlParameter[] pms = null; DateTime dt = DateTime.Now; int RandKey = 1000; bool is_ec_ok = false; while (!is_ec_ok) { Random ran = new Random(); RandKey = ran.Next(1000, 9999); int OrderCodeIsUse = 0; string sqlIsExistEC = "select count(*) from XXCLOUDALL.dbo.T_SHFYOrderInfo where OrderCode=@OrderCode and OrderCodeIsUse=@OrderCodeIsUse"; SqlParameter[] pms4EC = new SqlParameter[] { new SqlParameter("@OrderCode", SqlDbType.VarChar) { Value = RandKey.ToString() }, new SqlParameter("@OrderCodeIsUse", SqlDbType.VarChar) { Value = OrderCodeIsUse.ToString() } }; object obj = SQLHelper2.ExecuteScalar(sqlIsExistEC, System.Data.CommandType.Text, pms4EC); if (Convert.ToInt32(obj) == 0) { //说明此EnterCode可以使用 is_ec_ok = true; } } sql = "insert into XXCLOUDALL.dbo.T_SHFYOrderInfo(OrderNo, OrderCode, VisitorName, VisitorSex, VisitorPhone, VisitorIdNo, VisitorReason, VisitorNumber, CarNo, VisitorStartDT, VisitorEndDT, StaffNo, CreateTime)" + "values(@OrderNo, @OrderCode, @VisitorName, @VisitorSex, @VisitorPhone, @VisitorIdNo, @VisitorReason, @VisitorNumber, @CarNo, @VisitorStartDT, @VisitorEndDT, @StaffNo, @CreateTime)"; pms = new SqlParameter[] { new SqlParameter("@OrderNo", SqlDbType.VarChar) { Value = DataHelper.IsNullReturnLine(v.OrderNo) }, new SqlParameter("@OrderCode", SqlDbType.VarChar) { Value = DataHelper.IsNullReturnLine(RandKey.ToString()) }, new SqlParameter("@VisitorName", SqlDbType.NVarChar) { Value = DataHelper.IsNullReturnLine(v.VisitorName) }, new SqlParameter("@VisitorSex", SqlDbType.NVarChar) { Value = DataHelper.IsNullReturnLine(v.VisitorSex) }, new SqlParameter("@VisitorPhone", SqlDbType.VarChar) { Value = DataHelper.IsNullReturnLine(v.VisitorPhone) }, new SqlParameter("@VisitorIdNo", SqlDbType.VarChar) { Value = DataHelper.IsNullReturnLine(v.VisitorIdNo) }, new SqlParameter("@VisitorReason", SqlDbType.NVarChar) { Value = DataHelper.IsNullReturnLine(v.VisitorReason) }, new SqlParameter("@VisitorNumber", SqlDbType.NVarChar) { Value = DataHelper.IsNullReturnLine(v.VisitorNumber) }, new SqlParameter("@CarNo", SqlDbType.NVarChar) { Value = DataHelper.IsNullReturnLine(v.CarNo) }, new SqlParameter("@VisitorStartDT", SqlDbType.NVarChar) { Value = DataHelper.IsNullReturnLine(v.VisitorStartDT) }, new SqlParameter("@VisitorEndDT", SqlDbType.NVarChar) { Value = DataHelper.IsNullReturnLine(v.VisitorEndDT) }, new SqlParameter("@StaffNo", SqlDbType.NVarChar) { Value = DataHelper.IsNullReturnLine(v.StaffNo) }, new SqlParameter("@CreateTime", SqlDbType.VarChar) { Value = dt.ToString("yyyy-MM-dd hh:mm:ss") } }; try { int result = SQLHelper2.ExecuteNonQuery(sql, System.Data.CommandType.Text, pms); if (result == 1) { int code = 1; return("{\"code\":\"" + code + "\",\"ordercode\":\"" + RandKey.ToString() + "\"}"); //return "{\"code\":1,\"ordercode\":" + RandKey.ToString() + "}"; } else { return(ConvertHelper.resultJson(0, "操作数据库失败,请联系技术人员")); } } catch (Exception e) { //在webapi中要想抛出异常必须这样抛出,否则只抛出一个默认500的异常 var resp = new HttpResponseMessage(HttpStatusCode.InternalServerError) { Content = new StringContent(e.ToString()), ReasonPhrase = "error" }; throw new HttpResponseException(resp); } }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void toolStripButton2_Click(object sender, EventArgs e) { //string loginPath = Path.Combine(System.Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "user.ini"); //INIHelper.CheckPath(loginPath); //string loginName = INIHelper.Read("LoginName", "1", "001", loginPath); //if (true) //{ // dataGridView1.CommitEdit((DataGridViewDataErrorContexts)123); // dataGridView1.BindingContext[dataGridView1.DataSource].EndCurrentEdit(); // DataTable dtChange = dt.GetChanges(); // foreach (DataRow dr in dtChange.Rows) // { // string strChange = ""; // if (dr.RowState == System.Data.DataRowState.Added) // { // strChange = @"INSERT INTO [dbo].[PDnotes] // ([PDId] // ,[PDtime] // ,[PDnum] // ,[PDcoding] // ,[PDname] // ,[PDlever] // ,[PDclassify] // ,[PDdescribe] // ,[PDresult] // ,[PDover] // ,[PDresultDes]) // VALUES // ('"+dataGridView1.Rows.Count.ToString()+@"' // ,'" + DateTime.Now.ToString("yyyy/MM/dd ") + @"' // ,'" + dr["PDnum"].ToString() + @"' // ,'" + dr["PDcoding"].ToString() + @"' // ,'" + dr["PDname"].ToString() + @"' // ,'" + dr["PDlever"].ToString() + @"' // ,'" + dr["PDclassify"].ToString() + @"' // ,'" + dr["PDdescribe"].ToString() + @"' // ,'" + dr["PDresult"].ToString() + @"' // ,'" + "F" + @"' // ,'" + dr["PDresultDes"].ToString() + @"')"; // } // else if (dr.RowState == System.Data.DataRowState.Deleted) // { // strChange = @"DELETE FROM [dbo].[PDnotes] // WHERE PDtime = '" + dr["PDtime", DataRowVersion.Original].ToString() + @"' // AND PDnum ='" + dr["PDnum", DataRowVersion.Original].ToString() + "'"; // } // else if (dr.RowState == System.Data.DataRowState.Modified) // { // strChange = @"UPDATE [dbo].[PDnotes] // SET [PDnum] = '" + dr["PDnum"].ToString() + @"' // ,[PDcoding] = '" + dr["PDcoding"].ToString() + @"' // ,[PDname] = '" + dr["PDname"].ToString() + @"' // ,[PDlever] = '" + dr["PDlever"].ToString() + @"' // ,[PDclassify] = '" + dr["PDclassify"].ToString() + @"' // ,[PDdescribe] = '" + dr["PDdescribe"].ToString() + @"' // ,[PDresult] = '" + dr["PDresult"].ToString() + @"' // ,[PDover] = '" + dr["PDover"].ToString() + @"' // ,[PDresultDes] = '" + dr["PDresultDes"].ToString() + @"' // WHERE PDId= '" + dr["PDId"].ToString() + "'"; // } // int Rows = SQLHelper2.Update(strChange); // //if (Rows.ToString() != null) // //{ // // MessageBox.Show("提交成功"); // //} // //else // //{ // // MessageBox.Show("提交失败"); // //} // //MessageBox.Show(SQLHelper2.Update(strChange).ToString()); // } // MessageBox.Show("提交成功"); // LoadTable(); //} //else //{ // MessageBox.Show("无权限!"); //} string strChange; if (true) { string strChd; if (checkBox1.Checked == true) { strChd = "T"; } else { strChd = "F"; } string strSearch = @"SELECT COUNT(PDtime) FROM [YouliData].[dbo].[PDnotes] WHERE PDtime ='" + textBox7.Text.Trim() + "'"; if (SQLHelper2.GetSingleResult(strSearch).ToString() != "0") //修改 { strChange = @"UPDATE [dbo].[PDnotes] SET [PDnum] = '" + textBox1.Text.Trim() + @"' ,[PDcoding] = '" + textBox2.Text.Trim() + @"' ,[PDname] = '" + textBox3.Text.Trim() + @"' ,[PDlever] = '" + comboBox1.Text.Trim() + @"' ,[PDclassify] = '" + comboBox2.Text.Trim() + @"' ,[PDdescribe] = '" + textBox4.Text.Trim() + @"' ,[PDresult] = '" + textBox5.Text.Trim() + @"' ,[PDover] = '" + strChd.Trim() + @"' ,[PDresultDes] = '" + textBox6.Text.Trim() + @"' WHERE PDtime= '" + textBox7.Text.Trim() + "'"; } else //新增 { strChange = @"INSERT INTO [dbo].[PDnotes] ([PDtime] ,[PDnum] ,[PDcoding] ,[PDname] ,[PDlever] ,[PDclassify] ,[PDdescribe] ,[PDresult] ,[PDover] ,[PDresultDes]) VALUES ('" + textBox7.Text.Trim() + @"' ,'" + textBox1.Text.Trim() + @"' ,'" + textBox2.Text.Trim() + @"' ,'" + textBox3.Text.Trim() + @"' ,'" + comboBox1.Text.Trim() + @"' ,'" + comboBox2.Text.Trim() + @"' ,'" + textBox4.Text.Trim() + @"' ,'" + textBox5.Text.Trim() + @"' ,'" + strChd.Trim() + @"' ,'" + textBox6.Text.Trim() + @"')"; } try { SQLHelper2.Update(strChange); MessageBox.Show("修改完成"); this.panel1.Size = new System.Drawing.Size(1182, 10); LoadTable(); } catch { MessageBox.Show("修改失败"); } } else { } }
public string CheckOrderCode(SHFY v) { SqlParameter[] pms = null; string sql = ""; int OrderCodeIsUse0 = 0; string sqlIsExistEC = "select count(*) from XXCLOUDALL.dbo.T_SHFYOrderInfo where OrderCode=@OrderCode and OrderCodeIsUse=@OrderCodeIsUse0"; SqlParameter[] pms4EC = new SqlParameter[] { new SqlParameter("@OrderCode", SqlDbType.NVarChar) { Value = v.OrderCode }, new SqlParameter("@OrderCodeIsUse0", SqlDbType.VarChar) { Value = (OrderCodeIsUse0.ToString()) } }; object obj = SQLHelper2.ExecuteScalar(sqlIsExistEC, System.Data.CommandType.Text, pms4EC); if (Convert.ToInt32(obj) == 1) { int OrderCodeIsUse = 1; pms = new SqlParameter[] { new SqlParameter("@OrderCode", SqlDbType.VarChar) { Value = (v.OrderCode) }, new SqlParameter("@OrderCodeIsUse", SqlDbType.VarChar) { Value = (OrderCodeIsUse.ToString()) } }; sql = "update XXCLOUDALL.dbo.T_SHFYOrderInfo set OrderCodeIsUse=@OrderCodeIsUse where OrderCode=@OrderCode"; try { int result = SQLHelper2.ExecuteNonQuery(sql, System.Data.CommandType.Text, pms); if (result == 1) { return(ConvertHelper.resultJson(1, "此预约码有效,允许进入")); } else { return(ConvertHelper.resultJson(0, "操作数据库失败,请联系技术人员")); } } catch (Exception e) { //在webapi中要想抛出异常必须这样抛出,否则只抛出一个默认500的异常 var resp = new HttpResponseMessage(HttpStatusCode.InternalServerError) { Content = new StringContent(e.ToString()), ReasonPhrase = "error" }; throw new HttpResponseException(resp); } } else { return(ConvertHelper.resultJson(0, "此预约码无效,需人工审核")); } }
/// <summary> /// 添加职业 /// </summary> /// <param name="job"></param> public void AddJob(Job job) { string sql = @" DECLARE @pid INT,@cid INT IF(EXISTS(SELECT * FROM dbo.JobCategory WHERE Name=@SubjectName AND ParentId=0)) BEGIN SET @pid=(SELECT TOP 1 CategoryId FROM dbo.JobCategory WHERE Name=@SubjectName AND ParentId=0) END ELSE BEGIN IF(ISNULL(@pid,0)=0) BEGIN SET @pid=0 END ELSE BEGIN INSERT INTO [JobCategory]( [Name], [ParentId], [SortOrder] ) VALUES ( @SubjectName, 0, 0 ) SET @pid=@@IDENTITY END END IF(EXISTS(SELECT * FROM dbo.JobCategory WHERE Name=@CategoryName AND ParentId!=0)) BEGIN SET @cid=(SELECT TOP 1 CategoryId FROM dbo.JobCategory WHERE Name=@CategoryName AND ParentId!=0) END ELSE BEGIN IF(ISNULL(@pid,0)=0) BEGIN SET @cid=0 END ELSE BEGIN INSERT INTO [JobCategory]( [Name], [ParentId], [SortOrder] ) VALUES ( @CategoryName, @pid, 0 ) SET @cid=@@IDENTITY END END IF(NOT EXISTS(SELECT * FROM dbo.Job WHERE Name=@Name)) BEGIN INSERT INTO dbo.Job ( Name , TopCategoryId , SecondCategoryId , Introduction , HotJob ) VALUES ( @Name , -- Name - nvarchar(100) @pid, -- TopCategoryId - int @cid, -- SecondCategoryId - int @Introduction , -- Introduction - ntext 0 -- HotJob - bit ) END "; object[,] par = { { "@SubjectName", job.SubjectName }, { "@CategoryName", job.CategoryName }, { "@Name", job.Name }, { "@Introduction", job.Introduction } }; SQLHelper2.ExecuteSql(sql, par); }
/// <summary> /// 添加专业 /// </summary> /// <param name="majorCategory"></param> /// <returns></returns> public int AddMajor(Major major) { string sql = @" DECLARE @pid INT,@cid INT IF(EXISTS(SELECT * FROM dbo.MajorCategory WHERE Name=@SubjectName AND ParentId=0)) BEGIN SET @pid=(SELECT TOP 1 CategoryId FROM dbo.MajorCategory WHERE Name=@SubjectName AND ParentId=0) END ELSE BEGIN IF(ISNULL(@pid,0)=0) BEGIN SET @pid=0 END ELSE BEGIN INSERT INTO [MajorCategory]( [Name], [ParentId], [SortOrder] ) VALUES ( @SubjectName, 0, 0 ) SET @pid=@@IDENTITY END END IF(EXISTS(SELECT * FROM dbo.MajorCategory WHERE Name=@CategoryName AND ParentId!=0)) BEGIN SET @cid=(SELECT TOP 1 CategoryId FROM dbo.MajorCategory WHERE Name=@CategoryName AND ParentId!=0) END ELSE BEGIN IF(ISNULL(@pid,0)=0) BEGIN SET @cid=0 END ELSE BEGIN INSERT INTO [MajorCategory]( [Name], [ParentId], [SortOrder] ) VALUES ( @CategoryName, @pid, 0 ) SET @cid=@@IDENTITY END END IF(NOT EXISTS(SELECT * FROM dbo.Major WHERE Name=@Name)) BEGIN INSERT INTO dbo.Major ( Name , MajorType , SubjectId , CategoryId , MajorCode , Introduction , HotMajor ) VALUES ( @Name , -- Name - nvarchar(100) @MajorType , -- MajorType - tinyint @pid , -- SubjectId - int @cid , -- CategoryId - int @MajorCode , -- MajorCode - nvarchar(20) @Introduction , -- Introduction - ntext 0 -- HotMajor - bit ) END "; object[,] par = { { "@SubjectName", major.SubjectName }, { "@CategoryName", major.CategoryName }, { "@Name", major.Name }, { "@MajorType", major.MajorType }, { "@MajorCode", major.MajorCode }, { "@Introduction", major.Introduction } }; object value = SQLHelper2.GetSingle(sql, par); return(Convert.ToInt32(value)); }