private void Delete() { if (BTNSAVE.Enabled || txtID.Text == "") { return; } if (luestate.EditValue.ToString() == "1") { //已批準狀態,不可以刪除! MessageBox.Show(clsCommon.GetTitle("t_ check_is_can_delete"), myMsg.msgTitle, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } DialogResult dialogResult = MessageBox.Show(myMsg.msgIsDelete, myMsg.msgTitle, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult == DialogResult.Yes) { int ls_result; string sql_d = string.Format(@"UPDATE dbo.bs_productline Set state = '2' WHERE id = '{0}'", txtID.Text); ls_result = clsApp.ExecuteSqlUpdate(sql_d); if (ls_result > 0) { MessageBox.Show(myMsg.msgSave_ok, myMsg.msgTitle, MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show(myMsg.msgSave_error, myMsg.msgTitle, MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
//刪除用戶 private void contextMenuStrip_user_del_user_Click(object sender, EventArgs e) { if (MessageBox.Show("真的要刪除此条记录?", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { string sql_del = string.Format(@"DELETE FROM sys_user WHERE user_id='{0}'", cur_node_user_id); if (clsApp.ExecuteSqlUpdate(sql_del) > 0) { cur_node_selected.Remove(); //移除當前用戶節點 MessageBox.Show("刪除当前记录成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("刪除当前记录失败", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Stop); } } }
private void btnCancel_Click(object sender, EventArgs e) { if (txtpkey.Text == "") { return; } if (cur_node_typeid == "G") { MessageBox.Show("组节点不可注销!", "提示信息"); return; } string sql_u = string.Format(@"UPDATE sys_menu_window SET status='2' Where pkey={0}", int.Parse(txtpkey.Text)); if (MessageBox.Show("注销后菜单将不会出现在系統菜单界面,是否要注销此菜单?", "提示信息", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { int result = clsApp.ExecuteSqlUpdate(sql_u); if (result > 0) { node_cur_selected.Remove(); MessageBox.Show("当前菜单项注销成功!", "提示信息"); } else { MessageBox.Show("当前菜单项注销失败!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void Delete() //刪除當前行 { if (String.IsNullOrEmpty(txtid.Text)) { return; } if (clsArtwork.Is_Used_in_mm_master(txtid.Text, "datum")) { MessageBox.Show("Please note this material type code is used in goods master", "System info"); return; } DialogResult dlg_result = MessageBox.Show(myMsg.msgIsDelete, myMsg.msgTitle, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dlg_result == DialogResult.Yes) { string sql_u = string.Format(@"UPDATE dbo.bs_mat_type SET state='2' WHERE id='{0}'", txtid.Text); int li_result = clsApp.ExecuteSqlUpdate(sql_u); if (li_result > 0) { MessageBox.Show(myMsg.msgSave_ok, myMsg.msgTitle, MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show(myMsg.msgSave_error, myMsg.msgTitle, MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
private void Inport_excel(string _filename, string _strsql) { String connStr = String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}; Extended Properties=Excel 8.0;", _filename); using (OleDbDataAdapter da = new OleDbDataAdapter(_strsql, connStr)) { DataSet ds = new DataSet(); da.Fill(ds); string strUser_id = DBUtility._user_id; DataTable dtExcel = ds.Tables[0]; SqlConnection sqlconn = new SqlConnection(DBUtility.ConnectionString); sqlconn.Open(); string strSql_u; progressBar1.Enabled = true; progressBar1.Visible = true; progressBar1.Value = 0; progressBar1.Step = 1; progressBar1.Maximum = dtExcel.Rows.Count; int intFlag = 0; for (int i = 0; i < dtExcel.Rows.Count; i++) { progressBar1.Value += progressBar1.Step; if (progressBar1.Value == progressBar1.Maximum) { progressBar1.Enabled = false; progressBar1.Visible = false; } strSql_u = string.Format( @"EXECUTE usp_update_cust_info '{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}'", dtExcel.Rows[i]["客户名称"].ToString().Trim(), dtExcel.Rows[i]["客户送货地址"].ToString().Trim(), dtExcel.Rows[i]["联系人"].ToString().Trim(), dtExcel.Rows[i]["联系电话"].ToString().Trim(), dtExcel.Rows[i]["传真"].ToString().Trim(), dtExcel.Rows[i]["电邮"].ToString().Trim(), dtExcel.Rows[i]["省份或城市"].ToString().Trim(), strUser_id); intFlag = clsApp.ExecuteSqlUpdate(strSql_u); if (intFlag < 0) { MessageBox.Show(string.Format("更新客户名称:【{0}】出错!", dtExcel.Rows[i]["客户名称"].ToString().Trim())); break; } } progressBar1.Enabled = false; progressBar1.Visible = false; sqlconn.Close(); sqlconn.Dispose(); } }
private void btnOk_Click(object sender, EventArgs e) { if (txtNewpwd.Text == txtPwdconfirm.Text) { if (txtNewpwd.Text == "") { MessageBox.Show("密码不可以为空!"); txtNewpwd.Focus(); return; } string strEncrypt = clsPublic.GeoEncrypt(txtNewpwd.Text); string sql_u = string.Format(@"Update dbo.sys_user SET password='******' WHERE user_id='{1}'", strEncrypt, txtUser_id.Text); if (clsApp.ExecuteSqlUpdate(sql_u) > 0) { MessageBox.Show("密码修改成功!"); } } else { MessageBox.Show("新密码输入不一致!"); txtNewpwd.Focus(); } }
private void Save() //保存 { txtremark.Focus(); if (!Save_Before_Valid()) { return; } if (dgvDetails.RowCount == 0) { MessageBox.Show("表格明细资料不可为空 !", "提示信息"); return; } if (!Check_Details_Valid()) //检查明细资料的有效性 { return; } save_flag = false; myBDS1.EndEdit(); myBDS2.EndEdit(); dgvDetails.CloseEditor(); #region 保存新增或編輯 if (mState == "NEW" || mState == "EDIT") { string strSql; if (mState == "NEW") { strSql = String.Format("Select '1' FROM dbo.delivery_mostly WHERE id='{0}'", txtID.Text); if (clsApp.ExecuteSqlReturnObject(strSql) != "") { //MessageBox.Show(string.Format("此公司数据[{0}]已存在!", txtID.EditValue)); //return; //如已存在編號則重取最大單據編號 //GetID_No(); txtID.Text = clsApp.ExecuteSqlReturnObject(@"Select dbo.fn_get_max_no('T') AS max_no"); } clsApp.ExecuteSqlUpdate(@"EXECUTE usp_set_max_no 'T'"); //更新最大单据号加1 } //if (txtcustomer_address.Text != "") //{ // strSql = string.Format(@"EXECUTE usp_update_address_history '{0}','{1}','{2}','{3}'", txtcompany_id.EditValue, txtcustomer_address.Text, txtserial_no.Text, txtserial_name.Text); // clsApp.ExecuteSqlUpdate(strSql); //更新客户地址区域对照表 //} const string sql_i = @"INSERT INTO dbo.delivery_mostly(id,delivery_date,customer_name,customer_address,contact,customer_tel, customer_fax,company_id,serial_no,serial_name,amt_sum,remark,province,state,create_by,create_date) VALUES (@id,@delivery_date,@customer_name,@customer_address,@contact,@customer_tel,@customer_fax, @company_id,@serial_no,@serial_name,@amt_sum,@remark,@province,@state,@user_id,getdate())"; const string sql_u = @"Update dbo.delivery_mostly SET delivery_date=@delivery_date,customer_name=@customer_name,customer_address=@customer_address, contact=@contact,customer_tel=@customer_tel,customer_fax=@customer_fax,company_id=@company_id,serial_no=@serial_no, serial_name=@serial_name,amt_sum=@amt_sum,remark=@remark,province=@province,state=@state,update_by=@user_id,update_date=getdate() WHERE id=@id"; SqlConnection myCon = new SqlConnection(DBUtility.ConnectionString); //改爲CF01 myCon.Open(); SqlTransaction myTrans = myCon.BeginTransaction(); using (SqlCommand myCommand = new SqlCommand() { Connection = myCon, Transaction = myTrans }) { try { if (mState == "NEW") { myCommand.CommandText = sql_i; } else { myCommand.CommandText = sql_u; } myCommand.Parameters.Clear(); myCommand.Parameters.AddWithValue("@id", txtID.Text); myCommand.Parameters.AddWithValue("@delivery_date", clsPub.Return_String_Date(dtDelivery_date.Text)); myCommand.Parameters.AddWithValue("@customer_name", txtcustomer_name.Text); myCommand.Parameters.AddWithValue("@customer_address", txtcustomer_address.Text); myCommand.Parameters.AddWithValue("@contact", txtcontact.Text); myCommand.Parameters.AddWithValue("@customer_tel", txtcustomer_tel.Text); myCommand.Parameters.AddWithValue("@customer_fax", txtcustomer_fax.Text); myCommand.Parameters.AddWithValue("@company_id", txtcompany_id.EditValue.ToString()); myCommand.Parameters.AddWithValue("@serial_no", txtserial_no.EditValue.ToString()); myCommand.Parameters.AddWithValue("@serial_name", txtserial_name.Text); myCommand.Parameters.AddWithValue("@amt_sum", clsPub.Return_Float_Value(txtamt_sum.Text)); myCommand.Parameters.AddWithValue("@remark", txtremark.Text); myCommand.Parameters.AddWithValue("@province", lkeProvince.EditValue); myCommand.Parameters.AddWithValue("@state", "0"); myCommand.Parameters.AddWithValue("@user_id", DBUtility._user_id); myCommand.ExecuteNonQuery(); //處理【項目刪除】刪除明細資料 bool is_large; string sql_item_d; for (int i = 0; i < dtTempDel.Rows.Count; i++) { //刪除明細 sql_item_d = @"DELETE FROM dbo.delivery_details WHERE id=@id and sequence_id=@sequence_id"; myCommand.CommandText = sql_item_d; myCommand.Parameters.Clear(); myCommand.Parameters.AddWithValue("@id", txtID.Text); myCommand.Parameters.AddWithValue("@sequence_id", dtTempDel.Rows[i]["sequence_id"].ToString()); myCommand.ExecuteNonQuery(); } //保存明細 int curRow; string rowStatus; if (dgvDetails.RowCount > 0) { const string sql_item_i = @"INSERT INTO dbo.delivery_details (id,sequence_id,is_large,goods_id,sec_qty,amt_total,amt_other,rmk) values(@id,@sequence_id,@is_large,@goods_id,@sec_qty,@amt_total,@amt_other,@rmk)"; const string sql_item_u = @"Update dbo.delivery_details SET is_large=@is_large,goods_id=@goods_id,sec_qty=@sec_qty,amt_total=@amt_total,amt_other=@amt_other,rmk=@rmk Where id=@id AND sequence_id=@sequence_id"; for (int i = 0; i < dgvDetails.RowCount; i++) { curRow = dgvDetails.GetRowHandle(i); //dgvDetails.AddNewRow();//新增必須初始貨當前單元格焦點 //否則rowStatus取不到狀態值 rowStatus = dgvDetails.GetDataRow(curRow).RowState.ToString(); if (rowStatus == "Added" || rowStatus == "Modified") { myCommand.Parameters.Clear(); if (rowStatus == "Added") { myCommand.CommandText = sql_item_i; } else { myCommand.CommandText = sql_item_u; } myCommand.Parameters.AddWithValue("@id", txtID.Text); myCommand.Parameters.AddWithValue("@sequence_id", dgvDetails.GetRowCellValue(curRow, "sequence_id").ToString()); if (dgvDetails.GetRowCellValue(curRow, "is_large").ToString() == "True") { is_large = true; } else { is_large = false; } myCommand.Parameters.AddWithValue("@is_large", is_large); myCommand.Parameters.AddWithValue("@goods_id", dgvDetails.GetRowCellValue(curRow, "goods_id").ToString()); myCommand.Parameters.AddWithValue("@sec_qty", clsPub.Return_Float_Value(dgvDetails.GetRowCellValue(curRow, "sec_qty").ToString())); myCommand.Parameters.AddWithValue("@amt_total", clsPub.Return_Float_Value(dgvDetails.GetRowCellValue(curRow, "amt_total").ToString())); myCommand.Parameters.AddWithValue("@amt_other", clsPub.Return_Float_Value(dgvDetails.GetRowCellValue(curRow, "amt_other").ToString())); myCommand.Parameters.AddWithValue("@rmk", dgvDetails.GetRowCellValue(curRow, "rmk").ToString()); myCommand.ExecuteNonQuery(); } } } myTrans.Commit(); //數據提交 save_flag = true; } catch (Exception E) { myTrans.Rollback(); //數據回滾 save_flag = false; throw new Exception(E.Message); } finally { myCon.Close(); } } } #endregion SetButtonSatus(true); SetObjValue.SetEditBackColor(tabPage1.Controls, false); Set_Grid_Status(false); txtID.Properties.ReadOnly = true; mState = ""; dtTempDel.Clear(); if (save_flag) { Find_doc(txtID.Text); MessageBox.Show("当前数据保存成功!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("当前数据保存失败!", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Stop); } }
private void Save() { if (edit_mode == false) { MessageBox.Show("不是編輯狀態!"); return; } if (!checkValid()) { return; } string clr_grp = ""; string strSql = ""; int result = 0; clr_grp = txtClr_Grp.Text; if (select_tab == 0) { string cdesc = txtCdesc.Text; if (edit_flag == "1")//新增 { strSql = string.Format(@"INSERT INTO mm_color_group (clr_grp,cdesc,crusr,crtim) VALUES ('{0}','{1}','{2}',GETDATE())", clr_grp, cdesc, userid); } else { strSql = string.Format(@"UPDATE mm_color_group SET cdesc='{0}',crusr='******',crtim=GETDATE() WHERE clr_grp='{2}'" , cdesc, userid, clr_grp); } } else if (select_tab == 1) { string clr_id = txtClr_Id.Text; if (edit_flag == "1") //新增 { strSql = string.Format(@"INSERT INTO mm_color_group_details (clr_grp,clr_id,crusr,crtim) VALUES ('{0}','{1}','{2}',GETDATE())", clr_grp, clr_id, userid); } else { strSql = string.Format(@"UPDATE mm_color_group_details SET crusr='******',crtim=GETDATE() WHERE clr_grp='{1}' And clr_id='{2}'" , userid, clr_grp, clr_id); } } result = clsApp.ExecuteSqlUpdate(strSql); if (result > 0) { MessageBox.Show(myMsg.msgSave_ok, myMsg.msgTitle); } else { edit_flag = "0"; append_mode = false; edit_mode = false; loadData(); setTextBoxEnabled(); addNew(); } }