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