protected void submit_Click(object sender, EventArgs e) { Auth auth = new Auth(); SQLDB db = new SQLDB(); string netname_user = ""; string user = User.Identity.Name.ToUpper(); if (user.Contains("\\")) netname_user = user.Substring(user.IndexOf('\\') + 1, user.Length - user.IndexOf('\\') - 1); if (db.isAccessAllowed(netname_user)) { string netname = Netname.Text.ToUpper(); string login = Login.Text.ToUpper(); string password = Password.Text; if (netname.Length < 3) { MessageBox.Show("Сотрудник не найден!"); return; } Employee employee = auth.Authentication(netname, login, password); if (employee != null) Response.Redirect("Default.aspx?netname=" + employee.Netname); else MessageBox.Show("Сотрудник не найден!"); } else { MessageBox.Show("У вас недостаточно прав доступа для входа!"); } }
//查詢標準型態資料 protected void lnkbtn_calStandard_Click(object sender, EventArgs e) { string vd = ddlst_Device.SelectedValue; SQLDB _operator = new SQLDB("VD_STANDARD", "KPT"); DataSet vdStandard = _operator.Select("Vdid = '" + vd + "' AND Vsrdir = '" + ddlst_Vsrdir.SelectedValue + "'", "Vdid , TypeName,Week,Hours", "VD_STANDARD"); RunChart(vdStandard); }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { SQLDB db = new SQLDB(); string deviceKind = gv.Rows[e.RowIndex].Cells[1].Text; TextBox checkcycle; checkcycle = (TextBox)gv.Rows[e.RowIndex].Cells[2].Controls[0]; if (!IsNumeric(checkcycle.Text)) { ShowMsg2(UpdatePanel1, "請輸入數字"); return; } //檢查更新是否成功 string updatestring = "Update CD_CheckCycle set cycle= '" + checkcycle.Text + "' where Devicekind = '" + deviceKind + "'"; if (db.ExecuteStatement(updatestring)) { ShowMsg2(UpdatePanel1, "更新成功"); } else { ShowMsg2(UpdatePanel1, "更新失敗"); } gv.EditIndex = -1; InitData(); SearchData(); }
protected override void InitData() { //BindDropDownListData(ddl_department, (DataSet)Application["App_Systm_Department"], "DepartmentName", "DepartmentID"); SQLDB db = new SQLDB(); DataSet ds = db.Select("", "", "role"); this.gv.DataSource = ds; this.gv.DataBind(); }
public bool DelMaterial(string materialid) { bool suc = false; SQLDB _operator = new SQLDB(); string deletestring = "DELETE ICS_Material where NO= '" + materialid + "'"; suc = _operator.ExecuteStatement(deletestring); return suc; }
protected void Page_Load(object sender, EventArgs e) { string html = ""; int month = 0; int year = 0; int person_id = 0; SQLDB sql = new SQLDB(); Date dt = new Date(); MonthDB mdb = new MonthDB(); if (Request.QueryString["month"] != null) month = Convert.ToInt32(Request.QueryString["month"]); if (Request.QueryString["year"] != null) year = Convert.ToInt32(Request.QueryString["year"]); if (Request.QueryString["id"] != null) person_id = Convert.ToInt32(Request.QueryString["id"]); Employee emp = sql.getEmployee(person_id); lbEmployeeName.Text = emp.FIO; lbPeriodName.Text = mdb.getMonthName(month).ToUpper() + " " + year.ToString(); string start_period = dt.getDataToSAP(1, month, year); List<CheckedHours> hours = sql.getCheckedSchedule(start_period, person_id); if (hours.Count > 0) { html = @"<table cellpadding='0' cellspacing='0' class='main_table' width='270px'> <tr style='background: url(App_Resources/header.bmp) repeat-x;' > <td class='header_table' width='70px' style='border-left: solid 1px #999999; border-top: solid 1px #999999;' >Дата</td> <td class='header_table' width='100px' style='border-top: solid 1px #999999;'>IT</td> <td class='header_table' width='100px' style='border-top: solid 1px #999999;'>SAP</td> </tr>"; foreach (CheckedHours ch in hours) { html += "<tr><td width='70px' style='border-left: solid 1px #999999;'>" + ch.DayDate + "</td><td width='100px'>" + ch.IT_Hours.ToString() + "</td><td width='100px'>" + ch.SAP_Hours.ToString() + "</td><tr>"; } html += "</table>"; } else { string msg = ""; if (dt.isOpen(month, year)) msg = "Введенный график совпадает с графиком SAP"; else msg = "Нет данных"; html = "<div class='check_personal' style='width: 270px; height:50px; color: DarkRed;'>" + msg + "</div>"; } lbTable.Text = html; }
public bool DelProject(string projectno) { bool suc = false; SQLDB _operator = new SQLDB("ICS_Project"); suc = _operator.Delete("ProjectNO='" + projectno + "'"); //if (suc) //{ // Application["App_Mis_Company"] = CommonLib.GetCompany(); //} return suc; }
protected override void InitData() { SQLDB _operator = new SQLDB("VD_Info", "KPT"); string query = "select vdid from VD_Info group by vdid"; DataSet ds = _operator.SelectQuery(query); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { ListItem vditem = new ListItem(); vditem.Value = ds.Tables[0].Rows[i]["vdid"].ToString(); vditem.Text = ds.Tables[0].Rows[i]["vdid"].ToString(); ddlst_Device.Items.Add(vditem); } }
protected void SearchData() { SQLDB db = new SQLDB(); StringBuilder selectquery = new StringBuilder("select * " + " from View_DeviceConfig v left join ( " + " select Device_ID,MAX(ChecKDate) ChecKDate " + " FROM CD_DeviceCheckDate " + " where checkdate < GETDATE() " + " group by Device_ID " + " ) t on v.Device_ID = t.device_ID "); string conditionName = ddlst_SearchType.SelectedValue; StringBuilder condition = new StringBuilder(); //若查詢日期則把模糊查詢like改為= if (conditionName == "ContractStartDate" || conditionName == "ContractEndDate" || conditionName == "CheckDate") { if (txt_StartDate.Text.Length > 0 && txt_EndDate.Text.Length > 0) { condition.Append(conditionName + "> '" + txt_StartDate.Text + "' AND " + conditionName + "< '" + txt_EndDate.Text + "'"); } else { if (txt_StartDate.Text.Length > 0) { condition.Append(conditionName + "> '" + txt_StartDate.Text + "'"); } if (txt_EndDate.Text.Length > 0) { condition.Append(conditionName + "< '" + txt_EndDate.Text + "'"); } } } else { condition.Append(txt_Query_Reason.Text.Trim().Length > 0 ? " " + conditionName + " like '%" + txt_Query_Reason.Text.Trim() + "%' " : ""); } if (condition.Length > 0) { selectquery.Append(" WHERE " + condition); } DataSet ds = db.SelectQuery(selectquery.ToString()); Session["DS_MIS"] = ds; gv.DataSource = ds; gv.DataBind(); if (ds.Tables[0].Rows.Count == 0) { ShowMsg2(UpdatePanel1, "查詢無資料"); } }
// процедура обработки ajax вызова - формирование списка сотрудников public string GetCallbackResult() { string argum = eventArgument; string date = argum.Substring(0, 10); string text = argum.Substring(10); DateTime dt = DateTime.Parse(date); SQLDB sql = new SQLDB(); sql.insertNotes(employee_id, text, Convert.ToInt32(user.TabNum), role_id, dt); string url = "Bookmark.aspx?eid=" + employee_id.ToString() + "&rid=" + role_id.ToString(); return url; }
private bool LoadData() { bool suc = false; SQLDB db = new SQLDB("CD_MaterialOfDevice"); DataSet ds = new DataSet(); ds = db.Select("Device_ID = '"+hidden_DeviceID.Value+"'","","CD_MaterialOfDevice"); if (ds.Tables[0].Rows.Count > 0) { suc = true; gv_Material.DataSource = ds; gv_Material.DataBind(); Session["MIS_Material"] = ds; } return suc; }
protected void SearchData() { SQLDB _operator = new SQLDB("DeviceKind"); string conditionName = ddlst_SearchType.SelectedValue; string condition = (txt_Query_Reason.Text.Trim().Length > 0 ? " " + conditionName + " like '%" + txt_Query_Reason.Text.Trim() + "%' " : ""); //condition += query_company; DataSet ds = _operator.Select(condition); Session["DS_MIS"] = ds; gv.DataSource = ds; gv.DataBind(); if (ds.Tables[0].Rows.Count == 0) { ShowMsg2(UpdatePanel1, "查詢無資料"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["User"] == null) Response.Redirect("Default.aspx"); this.user = (Person)Session["User"]; SQLDB sql = new SQLDB(); if (Request.QueryString["eid"] != null) employee_id = Convert.ToInt32(Request.QueryString["eid"].ToString()); if (Request.QueryString["rid"] != null) role_id = Convert.ToInt32(Request.QueryString["rid"]); string employee_fio = sql.getFIO(employee_id); lbTitle.Text = employee_fio + " " + employee_id; string html = "<table class='notes-table'>"; List<Note> notes = sql.getNotes(employee_id); int k = 0; foreach (Note note in notes) { k++; string role = ""; switch (note.RoleID) { case 1: role = "Табельщик"; break; case 2: role = "HR"; break; case 3: role = "Бухгалтер"; break; default: role = "нет"; break; } html += "<tr><td class='notes-field-num'>" + k.ToString() + "</td><td class='notes-field-fio'><div style='width: 200px; overflow: hidden;'>" + sql.getFIO(Convert.ToInt32(user.TabNum)) + "</div></td><td class='notes-field-date-record'>" + note.DateNote.ToString() + "</td></tr><tr><td class='notes-field-num'> </td><td class='notes-field-fio'>Роль: " + role + "</td><td class='notes-field-date-record'>Срок: " + note.DateExpire.ToString("dd.MM.yyyy") + "</td></tr><tr><td class='notes-field-text' colspan='3'><div>" + note.Text + "</div></td></tr>"; } html += "</table>"; lbNotes.Text = html; string cbReference = Page.ClientScript.GetCallbackEventReference(this, "arg", "ClientBookmarkCallback", "context"); string func_name = "BookmarkCallback"; string cbScript = "function " + func_name + "(arg, context)" + "{" + cbReference + ";" + "}"; Page.ClientScript.RegisterClientScriptBlock(this.GetType(), func_name, cbScript, true); }
protected void File_Upload(object sender, AjaxControlToolkit.AjaxFileUploadEventArgs e) { string filename = e.FileName; string strDestPath = Server.MapPath("../Temp/"); //將資料存到網站 AjaxFileUpload1.SaveAs(@strDestPath + filename); //將資料存到DB SQLDB _operator = new SQLDB(); DataSet ds = _operator.Select("1=0", "", "StudyFileUpload"); DataRow dr = ds.Tables[0].NewRow(); dr["FileName"] = filename; dr["UpdateTime"] = DateTime.Now; ds.Tables[0].Rows.Add(dr); DataSet DSChange = ds.GetChanges(); _operator.Insert(DSChange); }
protected void SearchData() { gv.DataSource = null; gv.DataBind(); SQLDB db = new SQLDB(); StringBuilder query = new StringBuilder(" select * from "); query.Append(" (SELECT DeviceID,COUNT(*) as counts "); query.Append(" FROM WarrantyNotify "); string conditionName = ddlst_SearchType.SelectedValue; if (txt_startDateTime.Text.Length > 0 || txt_endDateTime.Text.Length > 0) { query.Append(" WHERE "); if (txt_startDateTime.Text.Length > 0 && txt_endDateTime.Text.Length > 0) { query.Append(" NotifyDate >= '" + txt_startDateTime.Text + "' and NotifyDate <= '" + txt_endDateTime.Text + "' "); } else if (txt_startDateTime.Text.Length > 0) { query.Append(" NotifyDate >= '" + txt_startDateTime.Text + "' "); } else if (txt_endDateTime.Text.Length > 0) { query.Append(" NotifyDate <= '" + txt_endDateTime.Text + "' "); } } query.Append(" GROUP BY deviceid) w left join View_DeviceConfig d on w.deviceid = d.Device_ID "); if (txt_Query_Reason.Text.Trim().Length > 0) { query.Append(" where "+conditionName + " like '%" + txt_Query_Reason.Text.Trim() + "%' "); } query.Append("order by counts desc"); DataSet ds = db.SelectQuery(query.ToString()); //Session["DS_MIS"] = ds; gv.DataSource = ds; gv.DataBind(); if (ds.Tables[0].Rows.Count == 0) { ShowMsg2(UpdatePanel1, "查詢無資料"); } }
private void FillCashAcc() { try { string strCMD = "SELECT AM_ACCOUNT_ID,AM_ACCOUNT_NAME FROM FA_ACCOUNT_MASTER WHERE AM_ACCOUNT_TYPE_ID='CASH' AND AM_COMPANY_CODE='" + CommonData.CompanyCode + "'"; objDB = new SQLDB(); DataTable dt = objDB.ExecuteDataSet(strCMD).Tables[0]; if (dt.Rows.Count > 0) { cmbCashAccount.DataSource = dt; cmbCashAccount.ValueMember = "AM_ACCOUNT_ID"; cmbCashAccount.DisplayMember = "AM_ACCOUNT_NAME"; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void GenerateVoucherId() { try { string strCMD = "SELECT ISNULL(MAX(VCO_VOUCHER_ID),0)+1 VoucherId FROM FA_VOUCHER_OTHERS WHERE vco_company_code='" + CommonData.CompanyCode + "' AND VCO_BRANCH_CODE='" + CommonData.BranchCode + "' AND VCO_FIN_YEAR='" + CommonData.FinancialYear + "'"; objDB = new SQLDB(); DataTable DT = objDB.ExecuteDataSet(strCMD).Tables[0]; if (DT != null && DT.Rows.Count > 0) { txtVoucherId.Text = DT.Rows[0][0].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private int SaveItemDetails() { objSQLdb = new SQLDB(); int iRec = 0; string strCmd = ""; try { string[] strBranCode = cbBranches.SelectedValue.ToString().Split('@'); if (gvItemDetails.Rows.Count > 0) { for (int i = 0; i < gvItemDetails.Rows.Count; i++) { strCmd += "INSERT INTO SERVICES_PRODUCT_PROMOTION_ITEMS(SPPI_COMPANY_CODE " + ", SPPI_STATE_CODE " + ", SPPI_BRANCH_CODE " + ", SPPI_DOC_MONTH " + ", SPPI_TRN_TYPE " + ", SPPI_TRN_NUMBER " + ", SPPI_ITEM_ID " + ", SPPI_QTY " + ", SPPI_REMARKS " + ")VALUES('" + cbCompany.SelectedValue.ToString() + "','" + strBranCode[1] + "','" + strBranCode[0] + "','" + Convert.ToDateTime(dtpTrnDate.Value).ToString("MMMyyyy").ToUpper() + "','PROD PROMOTION','" + txtTrnNo.Text.ToString() + "','" + gvItemDetails.Rows[i].Cells["ItemId"].Value.ToString() + "'," + Convert.ToInt32(gvItemDetails.Rows[i].Cells["Qty"].Value) + ",'" + gvItemDetails.Rows[i].Cells["ItemRemarks"].Value.ToString() + "' )"; } } if (strCmd.Length > 10) { iRec = objSQLdb.ExecuteSaveData(strCmd); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } return(iRec); }
public DataSet IndentProductCategoryList_GET() { objSQLdb = new SQLDB(); DataSet ds = new DataSet(); try { ds = objSQLdb.ExecuteDataSet("IndentProductCategoryList_GET", CommandType.StoredProcedure); } catch (Exception ex) { throw new Exception(ex.ToString()); } finally { objSQLdb = null; } return(ds); }
private void FillVillagesList(string CompCode, string BranCode, string DocMonth, string State, string District, string Mandal) { objSQLdb = new SQLDB(); DataTable dt = new DataTable(); string strCmd = ""; clbVillage.Items.Clear(); try { State = State.TrimEnd(','); District = District.TrimEnd(','); Mandal = Mandal.TrimEnd(','); if (CompCode.Length > 1 && BranCode.Length > 1 && DocMonth.Length > 1 && State.Length > 1 && District.Length > 1) { strCmd = "SELECT DISTINCT CM_VILLAGE Village " + " FROM SALES_INV_HEAD " + " INNER JOIN CUSTOMER_MAS ON CM_FARMER_ID=SIH_FARMER_ID " + " WHERE SIH_COMPANY_CODE IN (" + CompCode + ") AND SIH_BRANCH_CODE IN(" + BranCode + ") " + " AND SIH_DOCUMENT_MONTH IN(" + DocMonth + ") AND CM_STATE IN (" + State + ") " + " and CM_DISTRICT in(" + District + ") and CM_MANDAL in (" + Mandal + ") ORDER BY CM_VILLAGE ASC"; dt = objSQLdb.ExecuteDataSet(strCmd).Tables[0]; } if (dt.Rows.Count > 0) { foreach (DataRow item in dt.Rows) { NewCheckboxListItem oclBox = new NewCheckboxListItem(); oclBox.Tag = item["Village"].ToString(); oclBox.Text = item["Village"].ToString(); clbVillage.Items.Add(oclBox); oclBox = null; } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void GetMajorCostCenterDetails(string MajorId, string MajorName, string MajorSname) { objSqlDB = new SQLDB(); DataTable dtMajorCCDel = new DataTable(); gvCostCenterDetails.Rows.Clear(); if (txtMajorCCId.Text != "" || txtMajorCostCenterName.Text != "" || txtMajorCostCenterSName.Text != "") { try { dtMajorCCDel = GetCostCenterDetails(MajorId, MajorName, MajorSname).Tables[0]; if (dtMajorCCDel.Rows.Count > 0) { btnDelete.Enabled = false; flagUpdate = true; txtMajorCCId.Text = dtMajorCCDel.Rows[0]["MajorCostCenterId"].ToString(); txtMajorCostCenterName.Text = dtMajorCCDel.Rows[0]["MajorCostCenterName"].ToString(); txtMajorCostCenterSName.Text = dtMajorCCDel.Rows[0]["MajorcostCenterShortName"].ToString(); if (dtMajorCCDel.Rows[0]["CostMajorid"].ToString() != "") { FillCostCenterDetails(dtMajorCCDel); } } else { //txtMajorCCId.Text = ""; //txtMajorCostCenterName.Text = ""; //txtMajorCostCenterSName.Text = ""; //gvCostCenterDetails.Rows.Clear(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { objSqlDB = null; } } }
public DataTable dtCompanyDocumentMonth(string strCompCode) { objData = new SQLDB(); DataTable dt = new DataTable(); try { dt = objData.ExecuteDataSet("SELECT fin_year+'@'+cast(start_date as varchar)+'@'+ cast(end_date as varchar) AS FinYear, document_month AS DocMonth FROM document_month where company_code='" + strCompCode + "' And Status='R' ORDER BY start_date desc", CommandType.Text).Tables[0]; } catch (Exception ex) { throw new Exception(ex.ToString()); } finally { objData = null; } return(dt); }
public SuccessModel <List <CategoryModel> > GetCategoryListForCustomerList() { try { return(new SuccessModel <List <CategoryModel> >() { Data = SQLDB.ExecuteSprocAccessor <CategoryModel>("GetCategoryListForCustomer").ToList(), ErrorMessage = null }); } catch (Exception ex) { return(new SuccessModel <List <CategoryModel> >() { ErrorMessage = ex.Message, Data = null }); } }
private int SaveData() { int iRes = 0; string strCMD = ""; string strCntrlAc = ""; if (cmbCntrlAcc.SelectedIndex == 0) { strCntrlAc = ""; } else { strCntrlAc = cmbCntrlAcc.SelectedValue.ToString(); } try { if (flagUpdate == false) { strCMD = " INSERT INTO FA_ACCOUNT_MASTER(AM_COMPANY_CODE,AM_ACCOUNT_ID,AM_ACCOUNT_NAME,AM_SHORT_NAME," + //AM_ACCOUNT_GROUP_ID," + "AM_ALIE_ID,AM_ACCOUNT_TYPE_ID,AM_DEFAULT_DEBIT_CREDIT_ID,AM_BUDGET_REQUIRED,AM_BUDGET_LOCK,AM_PL_BS," + //AM_SCHEDULE_ID,AM_SCHEDULE_GROUP_ID,AM_DUMMY_ACCOUNT," + "AM_CREATED_BY,AM_CREATED_DATE,AM_LDGR_PRN_FLAG,AM_COSTCENTRE_FLAG) VALUES('" + CommonData.CompanyCode + "','" + txtAccountSearch.Text + "','" + txtName.Text + "','" + txtShrtName.Text + //"','' "','" + AccountFlag + "','" + strCntrlAc + "','" + DefFlag + "','N','N','" + PLBSFlag + // "','','','' "','" + CommonData.LogUserId + "',GETDATE(),'" + cmbLedFormat.SelectedValue.ToString() + "','" + cmbCostCentFlag.SelectedValue.ToString() + "')"; } else { strCMD = " UPDATE FA_ACCOUNT_MASTER SET AM_COMPANY_CODE='" + CommonData.CompanyCode + "',AM_ACCOUNT_NAME='" + txtName.Text + "',AM_SHORT_NAME='" + txtShrtName.Text + "'," + //AM_ACCOUNT_GROUP_ID=''," + "AM_ALIE_ID='" + AccountFlag + "',AM_DEFAULT_DEBIT_CREDIT_ID='" + DefFlag + "',AM_BUDGET_REQUIRED='N',AM_BUDGET_LOCK='N',AM_PL_BS='" + PLBSFlag + //"',AM_SCHEDULE_ID='',AM_SCHEDULE_GROUP_ID='',AM_DUMMY_ACCOUNT=''," + "',AM_LAST_MODIFIED_BY='" + CommonData.LogUserId + "',AM_LAST_MODIFIED_DATE=GETDATE(),AM_LDGR_PRN_FLAG='" + cmbLedFormat.SelectedValue.ToString() + "',AM_COSTCENTRE_FLAG='" + cmbCostCentFlag.SelectedValue.ToString() + "' WHERE AM_ACCOUNT_ID='" + txtAccountSearch.Text + "' AND AM_COMPANY_CODE='" + CommonData.CompanyCode + "' "; } objDB = new SQLDB(); iRes = objDB.ExecuteSaveData(strCMD); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } return(iRes); }
protected void SearchData() { gv.DataSource = null; gv.DataBind(); SQLDB db = new SQLDB(); StringBuilder query = new StringBuilder(" SELECT WarrantyCompany,CONVERT(float, AVG(datediff(MINUTE,NotifyDate,RepairDate)))/1440 as avgtime FROM WarrantyNotify "); query.Append(" where NotifyDate is not null and RepairDate is not null and datediff(MINUTE,NotifyDate,RepairDate)> 0 "); string conditionName = ddlst_SearchType.SelectedValue; StringBuilder condition = new StringBuilder(); bool isquery = false; if (txt_Query_Reason.Text.Trim().Length > 0) { condition.Append( conditionName + " like '%" + txt_Query_Reason.Text.Trim() + "%' and"); isquery = true; } if (txt_startDateTime.Text.Length > 0) { condition.Append(" NotifyDate >= '" + txt_startDateTime.Text + "' and"); isquery = true; } if (txt_endDateTime.Text.Length > 0) { condition.Append(" NotifyDate <= '" + txt_endDateTime.Text + "' and"); isquery = true; } if (isquery) { query.Append(" and "+ condition.ToString().Substring(0, condition.ToString().Length - 3)); } query.Append(" GROUP BY WarrantyCompany order by avgtime desc"); DataSet ds = db.SelectQuery(query.ToString()); //Session["DS_MIS"] = ds; gv.DataSource = ds; gv.DataBind(); if (ds.Tables[0].Rows.Count == 0) { ShowMsg2(UpdatePanel1, "查詢無資料"); } }
public Task <int> CreateDB(SQLDB sql) { return(sql.ExecuteNonQuery( "CREATE TABLE IF NOT EXISTS \"Example2\" (" + "\"ID\" UUID NOT NULL, " + "\"ID2\" UUID NOT NULL, " + "\"ID3\" UUID NOT NULL, " + "\"ID4\" UUID NOT NULL, " + "\"Data1\" BOOLEAN NOT NULL, " + "\"Data2\" BOOLEAN, " + "\"Data3\" BYTEA NOT NULL, " + "\"Data4\" BYTEA, " + "\"Data5\" CHAR(1) NOT NULL, " + "\"Data6\" CHAR(1), " + "\"Data7\" SMALLINT NOT NULL, " + "\"Data8\" SMALLINT, " + "\"Data9\" INTEGER NOT NULL, " + "\"Data10\" INTEGER, " + "\"Data11\" BIGINT NOT NULL, " + "\"Data12\" BIGINT, " + "\"Data13\" BIGINT NOT NULL, " + "\"Data14\" BIGINT, " + "\"Data15\" FLOAT4 NOT NULL, " + "\"Data16\" FLOAT4, " + "\"Data17\" FLOAT8 NOT NULL, " + "\"Data18\" FLOAT8, " + "\"Data19\" NUMERIC NOT NULL, " + "\"Data20\" NUMERIC, " + "\"Data21\" TEXT NOT NULL, " + "\"Data22\" TEXT, " + "\"Data23\" BYTEA NOT NULL, " + "\"Data24\" BYTEA, " + "\"Data25\" UUID NOT NULL, " + "\"Data26\" UUID, " + "\"Data27\" TIMESTAMP NOT NULL, " + "\"Data28\" TIMESTAMP, " + "\"Data29\" BIGINT NOT NULL, " + "\"Data30\" BIGINT, " + "PRIMARY KEY(\"ID\", \"ID2\", \"ID3\", \"ID4\"), " + "UNIQUE(\"Data25\"), " + "CHECK(\"Data27\" > '1990-05-20') " + ");")); }
public DataSet GetDlStates_Proc() { DataSet ds = new DataSet(); objSQLdb = new SQLDB(); try { ds = objSQLdb.ExecuteDataSet("GetDlStates_Proc", CommandType.StoredProcedure); } catch (Exception ex) { throw new Exception(ex.ToString()); } finally { objSQLdb = null; } return(ds); }
private void FillCompanyDdl() { objDB = new SQLDB(); try { DataTable dtCpy = objDB.ExecuteDataSet("SELECT CM_Company_Code, CM_Company_Name FROM Company_Mas WHERE ACTIVE = 'T'" + " ORDER BY CM_Company_Name", CommandType.Text).Tables[0]; //objSecurity.GetCompanyDataSet().Tables[0]; UtilityLibrary.PopulateControl(cbCompany, dtCpy.DefaultView, 1, 0, "--PLEASE SELECT--", 0); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { objDB = null; } }
private void AddAccountDetails_Load(object sender, EventArgs e) { objDB = new SQLDB(); txtSiNo.Text = (((ReceiptVoucher)objRecieptVoucher).gvBillDetails.Rows.Count + 1).ToString(); DataTable dtAccMas; //if (((ReceiptVoucher)objRecieptVoucher).cbEmpType.SelectedIndex == 1) //{ // //lblMajorCost.Visible = false; // //cmbMajorCost.Visible = false; // dtAccMas = objDB.ExecuteDataSet(" SELECT AM_ACCOUNT_ID,AM_ACCOUNT_NAME AccName FROM FA_ACCOUNT_MASTER WHERE AM_COMPANY_CODE='" + CommonData.CompanyCode // + "' and AM_ACCOUNT_ID <> '" + ((ReceiptVoucher)objRecieptVoucher).cmbCashAccount.SelectedValue // + "' AND AM_COSTCENTRE_FLAG IS NULL and AM_ACCOUNT_GROUP_ID IS NULL ").Tables[0]; //} //else //{ // //lblMajorCost.Visible = true; // //cmbMajorCost.Visible = true; dtAccMas = objDB.ExecuteDataSet(" SELECT AM_ACCOUNT_ID,AM_ACCOUNT_NAME AccName FROM FA_ACCOUNT_MASTER WHERE AM_COMPANY_CODE='" + CommonData.CompanyCode + "' AND AM_COSTCENTRE_FLAG='Y' and AM_ACCOUNT_GROUP_ID IS NULL ").Tables[0]; //} UtilityLibrary.AutoCompleteComboBox(cmbAccounts, dtAccMas, "AM_ACCOUNT_ID", "AccName"); if (dtAccMas.Rows.Count > 0) { DataRow dr = dtAccMas.NewRow(); cmbAccounts.DataSource = dtAccMas; cmbAccounts.DisplayMember = "AccName"; cmbAccounts.ValueMember = "AM_ACCOUNT_ID"; } if (drs != null) { txtSiNo.Text = drs[0]["SL_NO"].ToString(); cmbAccounts.SelectedValue = drs[0]["ACC_ID"].ToString(); //cmbMajorCost.SelectedValue = drs[0]["MAJCOST_ID"].ToString(); //cbPaymentMode.SelectedItem = drs[0]["PAYMENT_MODE"].ToString(); //txtChqDDNo.Text = drs[0]["CHQ_DD_NO"].ToString(); txtReceivedAmt.Text = drs[0]["AMOUNT"].ToString(); //txtRemarks.Text = drs[0]["REMARKS"].ToString(); } }
public DataSet GetDocuments() { DataSet ds = new DataSet(); objData = new SQLDB(); try { ds = objData.ExecuteDataSet("GetDocumentsHeads", CommandType.StoredProcedure); } catch (Exception ex) { throw new Exception(ex.ToString()); } finally { objData = null; } return(ds); }
private void EcodeSearch() { objData = new InvoiceDB(); DataSet dsEmp = new DataSet(); objSQLDB = new SQLDB(); try { Cursor.Current = Cursors.WaitCursor; cbEcode.DataSource = null; cbEcode.Items.Clear(); dsEmp = objSQLDB.ExecuteDataSet("select * from (SELECT ECODE, cast(ECODE as varchar)+'-'+MEMBER_NAME ENAME, company_code Company " + "FROM EORA_MASTER) Ecodes WHERE upper(ENAME) like upper('%" + txtEcodeSearch.Text.ToString() + "%') Order by ENAME"); //dsEmp = objData.InvLevelAllEcodeSearch_Get(CommonData.CompanyCode, CommonData.BranchCode, CommonData.DocMonth, txtEcodeSearch.Text.ToString()); DataTable dtEmp = dsEmp.Tables[0]; if (dtEmp.Rows.Count > 0) { cbEcode.DataSource = dtEmp; cbEcode.DisplayMember = "ENAME"; cbEcode.ValueMember = "ECODE"; FillProductsDataToGrid(); } else { strECode = ""; gvProductDetails.Rows.Clear(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (cbEcode.SelectedIndex > -1) { cbEcode.SelectedIndex = 0; strECode = ((System.Data.DataRowView)(cbEcode.SelectedItem)).Row.ItemArray[0].ToString(); } objData = null; Cursor.Current = Cursors.Default; } }
private bool CheckEmployeeIsOnDuty() { objSQLData = new SQLDB(); DataTable dt = new DataTable(); bool flag = true; try { string strCmd = "SELECT HEOT_EORA_CODE,HEOT_OD_FROM_DATE,HEOT_OD_TO_DATE FROM HR_EMPLOYEE_OD_TRN WHERE HEOT_EORA_CODE=" + txtEcodeSearch.Text + " "; dt = objSQLData.ExecuteDataSet(strCmd).Tables[0]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { DateTime fromDate = Convert.ToDateTime(dt.Rows[i]["HEOT_OD_FROM_DATE"].ToString()); DateTime toDate = Convert.ToDateTime(dt.Rows[i]["HEOT_OD_TO_DATE"].ToString()); if ((dtpPunchMissDate.Value <= fromDate && dtpPunchMissDate.Value >= toDate) || (dtpPunchMissDate.Value >= fromDate && dtpPunchMissDate.Value <= toDate)) { flag = false; MessageBox.Show("Employee is OnDuty on these days ", "Punch Missing", MessageBoxButtons.OK, MessageBoxIcon.Error); return(flag); } //else if ((dtFromDate.Value >= (fromDate) && dtpToDate.Value <= (toDate)) || (dtFromDate.Value >= (fromDate) && dtpToDate.Value <= (fromDate))) //{ // flag = false; // MessageBox.Show("Employee is on OnDuty these days"); // return flag; //} } } } catch (Exception ex) { ex.ToString(); } finally { objSQLData = null; dt = null; } return(flag); }
private void gvEmpPFDetails_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == gvEmpPFDetails.Columns["Edit"].Index) { txtPfNo.Text = gvEmpPFDetails.Rows[e.RowIndex].Cells["EmpPFNo"].Value.ToString(); txtPFBasic.Text = gvEmpPFDetails.Rows[e.RowIndex].Cells["EmpPFBasic"].Value.ToString(); dtpEffDate.Value = Convert.ToDateTime(gvEmpPFDetails.Rows[e.RowIndex].Cells["EffDate"].Value); txtPfNo.Focus(); flagUpdate = true; } if (e.ColumnIndex == gvEmpPFDetails.Columns["Delete"].Index) { objSQLdb = new SQLDB(); int iResult = 0; DialogResult dlgResult = MessageBox.Show("Do you want Delete this Record?", "Confirm?", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dlgResult == DialogResult.Yes) { try { string strDelete = "DELETE FROM PR_PF_DATA WHERE PPD_TRN_ID=" + Convert.ToInt32(TrnNo) + " "; iResult = objSQLdb.ExecuteSaveData(strDelete); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } if (iResult > 0) { flagUpdate = false; GetEmpPfDetails(Convert.ToInt32(txtEcodeSearch.Text)); MessageBox.Show("Data Deleted Successfully", "SSERP", MessageBoxButtons.OK, MessageBoxIcon.Information); //btnCancel_Click(null, null); } else { MessageBox.Show("Data Not Deleted", "SSERP", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private int SaveIndentDetlData() { int intSave = 0; string strSQL = string.Empty; StringBuilder sbSQL = new StringBuilder(); objSQLDB = new SQLDB(); try { strSQL = "DELETE from SP_INDENT_DETL" + " WHERE spid_company_code='" + CommonData.CompanyCode + "' AND spid_branch_code='" + CommonData.BranchCode + "' AND spid_indent_number=" + txtIndentNo.Text + " AND spid_fin_year='" + CommonData.FinancialYear + "'"; intSave = objSQLDB.ExecuteSaveData(strSQL); for (int i = 0; i < gvIndentDetails.Rows.Count; i++) { if (gvIndentDetails.Rows[i].Cells["Qty"].Value.ToString() != "" && gvIndentDetails.Rows[i].Cells["Qty"].Value.ToString() != "0") { sbSQL.Append("INSERT INTO SP_INDENT_DETL(spid_company_code, spid_state_code, spid_branch_code, spid_indent_number,spid_fin_year, spid_sl_no, SPID_GROUP, SPID_GLECODE, SPID_STOCK_POINT, SPID_PRODUCT_ID, SPID_REQ_QTY)" + " VALUES ('" + CommonData.CompanyCode + "', '" + CommonData.StateCode + "', '" + CommonData.BranchCode + "', " + txtIndentNo.Text + ", '" + CommonData.FinancialYear + "'," + gvIndentDetails.Rows[i].Cells["SLNO"].Value + ", '" + gvIndentDetails.Rows[i].Cells["Group"].Value.ToString().Trim() + "', '" + gvIndentDetails.Rows[i].Cells["GLCode"].Value + "', '" + gvIndentDetails.Rows[i].Cells["BranchCode"].Value + "', '" + gvIndentDetails.Rows[i].Cells["ProductId"].Value + "', " + gvIndentDetails.Rows[i].Cells["Qty"].Value + "); "); } } intSave = 0; if (sbSQL.ToString().Length > 10) { intSave = objSQLDB.ExecuteSaveData(sbSQL.ToString()); } } catch (Exception ex) { throw new Exception(ex.ToString()); } finally { objSQLDB = null; } return(intSave); }
protected void SearchData() { //string query_company = GetCompanyScope(); StringBuilder query = new StringBuilder("select * from ICS_Material m left join ICS_Material_Type mt on m.MaterialTypeID = mt.MaterialTypeID left join ICS_Stock_QuantityNow sq on m.NO = sq.MaterialID"); SQLDB _operator = new SQLDB(); if (txt_Query_Reason.Text.Trim().Length > 0) { query.Append(" WHERE " + ddlst_SearchType.SelectedValue + " like '%" + txt_Query_Reason.Text.Trim() + "%'"); } DataSet ds = _operator.SelectQuery(query.ToString()); Session["DS_MIS"] = ds; gv.DataSource = ds; gv.DataBind(); if (ds.Tables[0].Rows.Count == 0) { ShowMsg2(UpdatePanel1, "查詢無資料"); } }
private bool CheckEmployeeIsonLeave() { objData = new SQLDB(); DataTable dt = new DataTable(); bool flag = true; try { string strCmd = "SELECT HELT_EORA_CODE,HELT_LEAVE_FROM_DATE,HELT_LEAVE_TO_DATE FROM HR_EMPLOYEE_LEAVE_TRN WHERE HELT_EORA_CODE=" + txtEcodeSearch.Text + ""; dt = objData.ExecuteDataSet(strCmd).Tables[0]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { DateTime fromDate = Convert.ToDateTime(dt.Rows[i]["HELT_LEAVE_FROM_DATE"].ToString()); DateTime toDate = Convert.ToDateTime(dt.Rows[i]["HELT_LEAVE_TO_DATE"].ToString()); if ((dtFromDate.Value <= fromDate && dtpToDate.Value >= toDate) || (dtFromDate.Value >= (toDate) && dtpToDate.Value <= (toDate))) { flag = false; MessageBox.Show("Employee applied for Leave on these Dates", "On DutySlip Form", MessageBoxButtons.OK, MessageBoxIcon.Error); return(flag); } else if ((dtFromDate.Value >= (fromDate) && dtpToDate.Value <= (toDate)) || (dtFromDate.Value >= (fromDate) && dtpToDate.Value <= (fromDate))) { flag = false; MessageBox.Show("Employee applied for Leave on these Dates", "On DutySlip Form", MessageBoxButtons.OK, MessageBoxIcon.Error); return(flag); } } } } catch (Exception ex) { ex.ToString(); } finally { objData = null; dt = null; } return(flag); }
private void btnSave_Click(object sender, EventArgs e) { if (CheckData()) { Int32 imaxApplNo = GetNewApplNo(); Int32 iAcode = GetNewACode(); string sqlText = ""; int iRec = 0; objDB = new SQLDB(); try { sqlText = "INSERT INTO HR_APPL_MASTER_HEAD(HAMH_COMPANY_CODE,HAMH_BRANCH_CODE,HAMH_APPL_NUMBER,HAMH_APPL_DATE,HAMH_RECRUITMENT_SOURCE_CODE,HAMH_RECRUITMENT_SOURCE_DELT_CODE,HAMH_RECRUITMENT_SOURCE_ECODE," + "HAMH_NAME,HAMH_FORH,HAMH_FORH_NAME,HAMH_DOJ,HAMH_DOB,HAMH_NATIVE_PLACE,HAMH_SEX,HAMH_NAIONALITY,HAMH_RELIGION,HAMH_MATRITAL_STATUS,HAMH_EORA_TYPE,HAMH_EORA_CODE,HAMH_CREATED_BY,HAMH_CREATED_DATE," + "HAMH_WORKING_STATUS) VALUES('" + cmbCompany.SelectedValue.ToString() + "','" + cmbBranch.SelectedValue.ToString() + "','" + imaxApplNo + "','" + Convert.ToDateTime(CommonData.CurrentDate).ToString("dd/MMM/yyyy") + "'" + ",'" + cmbSourceCode.SelectedValue.ToString() + "','" + cmbRequtSourDetails.SelectedValue.ToString() + "','" + txtEcodeSearch.Text.ToString() + "','" + txtFullName.Text.ToString() + "'" + ",'" + cmbF_Flg_optional.SelectedItem.ToString() + "','" + txtfName.Text.ToString() + "','" + Convert.ToDateTime(dtpDOJ.Value).ToString("dd/MMM/yyyy") + "','" + Convert.ToDateTime(dtpDOB.Value).ToString("dd/MMM/yyyy") + "'" + ",'" + txtNativePlace_optional.Text + "','" + cmbSex_optional.SelectedItem.ToString() + "','" + cmbNationality.SelectedItem.ToString() + "','" + cmbReligion.SelectedItem.ToString() + "','" + cmbMatrital_optional.SelectedItem.ToString() + "'" + ",'A','" + iAcode + "','" + CommonData.LogUserId + "','" + Convert.ToDateTime(CommonData.CurrentDate).ToString("dd/MMM/yyyy") + "','L'); "; sqlText += "INSERT INTO EORA_MASTER(BRANCH_CODE,DEPT_ID,ECODE,MEMBER_NAME,EORA,HRIS_EMP_NAME,DESG_ID,DESIG,EMP_DOJ,EMP_DOB,FATHER_NAME,elevel_id,company_code,edu_qualification) VALUES('" + cmbBranch.SelectedValue.ToString() + "'" + ",'1200000','" + iAcode + "','" + txtFullName.Text.ToString() + "','A','" + txtFullName.Text.ToString() + "','987','ST','" + Convert.ToDateTime(dtpDOJ.Value).ToString("dd/MMM/yyyy") + "','" + Convert.ToDateTime(dtpDOB.Value).ToString("dd/MMM/yyyy") + "'" + ",'" + txtfName.Text.ToString() + "','95','" + cmbCompany.SelectedValue.ToString() + "','" + cmbTypeEdu.SelectedItem.ToString() + "'); "; iRec = objDB.ExecuteSaveData(sqlText); if (iRec > 0) { MessageBox.Show("Acode Generated For " + txtFullName.Text + "\n ACODE : " + iAcode + "", "SSCRM", MessageBoxButtons.OK, MessageBoxIcon.Information); btnClear_Click(null, null); } else { MessageBox.Show("Data not Saved", "SSCRM", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { objDB = null; } } }
private void gvAdoptionDetails_CellContentClick(object sender, DataGridViewCellEventArgs e) { int ires = 0; if (e.RowIndex >= 0) { if (e.ColumnIndex == gvAdoptionDetails.Columns["Delete"].Index) { if ((gvAdoptionDetails.Rows[e.RowIndex].Cells["ADPStatus"].Value.ToString() == "Adopted")) { DialogResult dlgResult = MessageBox.Show("Do you want delete this record?", "Confirm?", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dlgResult == DialogResult.Yes) { dgvr = gvAdoptionDetails.Rows[e.RowIndex]; objsqldb = new SQLDB(); string strcmd = ""; try { strcmd = "Delete from SALES_SR_ADOPTIONS Where SSA_EORA_CODE='" + cbEmployees.Text.ToString().Split('-')[0] + "' and SSA_DOC_MONTH='" + Convert.ToDateTime(dtpDocMonth.Text.ToString()).ToString("MMMyyyy") + "' and SSA_BRANCH_CODE='" + txtBranch.Tag.ToString() + "' and SSA_SR_EORA_CODE='" + gvAdoptionDetails.Rows[e.RowIndex].Cells["SREcode"].Value.ToString() + "' "; ires = objsqldb.ExecuteSaveData(strcmd); } catch (Exception ex) { MessageBox.Show(ex.Message); } if (ires > 0) { MessageBox.Show("Data Deleted Successfully", "SRAdoption", MessageBoxButtons.OK, MessageBoxIcon.Information); FillSRAdoptionDetails(); } else { MessageBox.Show("Data not Deleted", "SRAdoption", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } } } }
private void FillBranchData() { objSQLdb = new SQLDB(); DataTable dt = new DataTable(); cbBranches.DataSource = null; try { if (cbCompany.SelectedIndex > 0) { string strCommand = "SELECT DISTINCT BRANCH_NAME,BRANCH_CODE+'@'+STATE_CODE as branchCode " + " FROM USER_BRANCH " + " INNER JOIN BRANCH_MAS ON BRANCH_CODE = UB_BRANCH_CODE " + " WHERE COMPANY_CODE ='" + cbCompany.SelectedValue.ToString() + "' AND UB_USER_ID ='" + CommonData.LogUserId + "' AND BRANCH_TYPE='BR' ORDER BY BRANCH_NAME ASC"; dt = objSQLdb.ExecuteDataSet(strCommand).Tables[0]; } if (dt.Rows.Count > 0) { DataRow dr = dt.NewRow(); dr[0] = "--Select--"; dr[1] = "--Select--"; dt.Rows.InsertAt(dr, 0); cbBranches.DataSource = dt; cbBranches.DisplayMember = "BRANCH_NAME"; cbBranches.ValueMember = "branchCode"; } string BranCode = CommonData.BranchCode + '@' + CommonData.StateCode; cbBranches.SelectedValue = BranCode; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { objSQLdb = null; dt = null; } }
private void gvEmployeeList_CellClick(object sender, DataGridViewCellEventArgs e) { int ires = 0; if (e.RowIndex >= 0) { if (e.ColumnIndex == gvEmployeeList.Columns["Del"].Index) { DialogResult dlgResult = MessageBox.Show("Do you want to Delete this Record ", "Confirm?", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dlgResult == DialogResult.Yes) { dgvr = gvEmployeeList.Rows[e.RowIndex]; objDB = new SQLDB(); string strcmd = ""; try { strcmd = " Delete from HR_EMP_OD_BRANCH_LIST where HOBL_OD_BRANCH_CODE='" + gvEmployeeList.Rows[e.RowIndex].Cells["BRNCODE"].Value + "' AND HOBL_EORA_CODE='" + txtEcode.Text.ToString() + "' "; strcmd += " EXEC Amsbd_BioTransfer_InsDel_OD " + txtEcode.Text.ToString() + ",'" + gvEmployeeList.Rows[e.RowIndex].Cells["DvSLNO"].Value + "','DELETE'"; objDB = new SQLDB(); ires = objDB.ExecuteSaveData(strcmd); } catch (Exception ex) { MessageBox.Show(ex.Message); } if (ires > 0) { MessageBox.Show("Data Deleted Successfully"); FillEmpODGridDetails(); } else { MessageBox.Show("Data not Deleted"); } } } } }
private void FillBranchData() { objSQLdb = new SQLDB(); DataTable dt = new DataTable(); cbBranch.DataSource = null; try { if (cbCompany.SelectedIndex > -1 && cbBranchType.SelectedIndex > -1) { string strCommand = "SELECT BRANCH_NAME,BRANCH_CODE FROM BRANCH_MAS " + " WHERE COMPANY_CODE='" + cbCompany.SelectedValue.ToString() + "'and BRANCH_TYPE='" + cbBranchType.SelectedValue.ToString() + "' Order by BRANCH_NAME "; dt = objSQLdb.ExecuteDataSet(strCommand).Tables[0]; } if (dt.Rows.Count > 0) { DataRow dr = dt.NewRow(); dr[0] = "--Select--"; dr[1] = "--Select--"; dt.Rows.InsertAt(dr, 0); cbBranch.DataSource = dt; cbBranch.DisplayMember = "BRANCH_NAME"; cbBranch.ValueMember = "BRANCH_CODE"; } cbBranch.SelectedValue = CommonData.BranchCode; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { objSQLdb = null; dt = null; } }
private void btnSave_Click(object sender, EventArgs e) { string[] strArrTask = null; StringBuilder sbSQL = new StringBuilder(); string strSQL = string.Empty; try { if (CheckData()) { objDA = new SQLDB(); strSQL = "DELETE FROM USER_TASKS WHERE UT_USER_ID='" + ((SSAdmin.NewCheckboxListItem)(clbUsers.SelectedItem)).Tag.ToString() + "'"; int del = objDA.ExecuteSaveData(strSQL); TreeNodeCollection nodes = this.treeView1.Nodes; foreach (TreeNode n in nodes) { GetNodeRecursive(n, sbSQL); } strSQL = sbSQL.ToString().Substring(0, sbSQL.ToString().Length - 1); int Rec = objDA.ExecuteSaveData(strSQL); if (Rec > 0) { MessageBox.Show("User Tasks Saved"); treeView1.Nodes.Clear(); } } else { MessageBox.Show("Select atleast one task!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { objDA = null; } }
private void FillDenominationDefDetl() { string strSQL = "SELECT * FROM FA_DENM_PMTR WHERE DP_COMPANY_CODE='" + CommonData.CompanyCode + "' order by DP_SORT_NO "; SQLDB objDB = new SQLDB(); DataTable dt = objDB.ExecuteDataSet(strSQL).Tables[0]; if (dt.Rows.Count > 0) { gvBillDetails.Rows.Clear(); for (int i = 0; i < dt.Rows.Count; i++) { gvBillDetails.Rows.Add(); gvBillDetails.Rows[i].Cells["SlNo"].Value = dt.Rows[i]["DP_SORT_NO"]; gvBillDetails.Rows[i].Cells["Denomination"].Value = dt.Rows[i]["DP_DENOMIN"]; gvBillDetails.Rows[i].Cells["Count"].Value = "0"; gvBillDetails.Rows[i].Cells["AmtReceived"].Value = "0"; } } }
private void btnDelete_Click(object sender, EventArgs e) { objSqlDB = new SQLDB(); DataTable dt = new DataTable(); int iRes = 0; string strCommand = ""; if (txtMajorCCId.Text != "" && flagUpdate == true) { DialogResult dlgResult = MessageBox.Show("Do you want delete this record?", "Confirm?", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dlgResult == DialogResult.Yes) { try { strCommand += "DELETE FROM FA_COST_CENTRE WHERE CC_COMPANY_CODE='" + CommonData.CompanyCode + "' AND CC_MAJOR_COST_CENTRE_ID='" + txtMajorCCId.Text.ToString() + "' "; strCommand += "DELETE FROM FA_MAJOR_COST_CENTRE WHERE MCC_MAJOR_COST_CENTRE_ID='" + txtMajorCCId.Text.ToString() + "' AND MCC_COMPANY_CODE='" + CommonData.CompanyCode + "' "; if (strCommand.Length > 10) { iRes = objSqlDB.ExecuteSaveData(strCommand); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { objSqlDB = null; } if (iRes > 0) { MessageBox.Show("Data Deleted Successfully", "SSERP", MessageBoxButtons.OK, MessageBoxIcon.Information); btnClear_Click(null, null); gvCostCenterDetails.Rows.Clear(); flagUpdate = false; } } } }
private void txtEcodeSearch_KeyUp(object sender, KeyEventArgs e) { if (txtEcodeSearch.Text != "") { objSQLDB = new SQLDB(); DataSet ds = objSQLDB.ExecuteDataSet("SELECT * FROM EORA_MASTER WHERE ECODE=" + txtEcodeSearch.Text); objSQLDB = null; if (ds.Tables[0].Rows.Count > 0) { txtEName.Text = ds.Tables[0].Rows[0]["MEMBER_NAME"].ToString(); txtDesig.Text = ds.Tables[0].Rows[0]["DESIG"].ToString(); } else { txtEName.Text = ""; txtDesig.Text = ""; } } }
private bool LoadData() { txt_MaterialName.Enabled = false; SQLDB _operator = new SQLDB("ICS_Material"); bool suc = false; string query = "select * from ICS_Material m left join ICS_Material_Type mt on m.MaterialTypeID = mt.MaterialTypeID where NO = '" + hidden_Materialid.Value + "'"; DataSet ds2 = _operator.SelectQuery(query); if (ds2.Tables[0].Rows.Count == 1) { suc = true; DataTable dt = ds2.Tables[0]; DataRow dr = dt.Rows[0]; txt_MaterialName.Text = dr["MaterialName"].ToString(); cbo_materialType.SelectedValue = dr["MaterialTypeID"].ToString(); txt_MaterialSafeQuantity.Text = dr["MaterialSafeQuantity"].ToString(); txt_MaterialUnit.Text = dr["MaterialUnit"].ToString(); } return suc; }
public void FillCombiProductsToGrid() { objSQLdb = new SQLDB(); DataTable dt = new DataTable(); int intRow = 1; gvCombiProductDetails.Rows.Clear(); try { string strCommand = "SELECT PM_PRODUCT_ID CombiId " + ", PM_PRODUCT_NAME CombiName " + "FROM PRODUCT_MAS " + "WHERE PM_PRODUCT_TYPE='CMBPK'"; dt = objSQLdb.ExecuteDataSet(strCommand).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { DataGridViewRow tempRow = new DataGridViewRow(); DataGridViewCell cellSLNO = new DataGridViewTextBoxCell(); cellSLNO.Value = intRow; intRow = intRow + 1; tempRow.Cells.Add(cellSLNO); DataGridViewCell cellCombiId = new DataGridViewTextBoxCell(); cellCombiId.Value = dt.Rows[i]["CombiId"]; tempRow.Cells.Add(cellCombiId); DataGridViewCell cellCombiName = new DataGridViewTextBoxCell(); cellCombiName.Value = dt.Rows[i]["CombiName"]; tempRow.Cells.Add(cellCombiName); gvCombiProductDetails.Rows.Add(tempRow); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { objSQLdb = null; dt = null; } }
private bool CheckData() { objDB = new SQLDB(); if (DateTime.Now.AddDays(-15) < sLastNotice) { MessageBox.Show("Notice Allready Generated", "Legal :: Notice", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } if (txtStatus.Text != "LEFT") { MessageBox.Show("Employee was not left, Notice Generation Restricted to left Employees Only", "Legal :: Notice", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } if (Convert.ToDouble(txtLoanSanctioned.Text.ToString()) == 0) { MessageBox.Show("Invalid Loan Amount", "Legal :: Notice", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } if (txtEngNo.Text.Length == 0 || txtChassisNo.Text.Length == 0) { MessageBox.Show("Vehicle Engine No / Chassis No not Valid", "Legal :: Notice", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } string sAccess = string.Empty; try { sAccess = objDB.ExecuteDataSet("SELECT UB_STATUS FROM USER_BRANCH WHERE UB_USER_ID='" + CommonData.LogUserId + "' AND UB_BRANCH_CODE='" + sBranchCode + "'").Tables[0].Rows[0][0].ToString(); if (sAccess.Length == 0) { MessageBox.Show("You have no Authorization to generate Legal Notice for this branch employee.", "Legal :: Notice", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } } catch { MessageBox.Show("You have no Authorization to generate Legal Notice for this branch employee.", "Legal :: Notice", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } return(true); }
protected void SearchData() { gv.DataSource = null; gv.DataBind(); SQLDB db = new SQLDB(); StringBuilder query = new StringBuilder(" SELECT FaultDescribe,COUNT(*) as counts FROM WarrantyNotify "); string conditionName = ddlst_SearchType.SelectedValue; StringBuilder condition = new StringBuilder(); bool isquery = false; if (txt_Query_Reason.Text.Trim().Length > 0) { condition.Append(conditionName + " like '%" + txt_Query_Reason.Text.Trim() + "%' and"); isquery = true; } if (txt_startDateTime.Text.Length > 0) { condition.Append(" NotifyDate >= '" + txt_startDateTime.Text + "' and"); isquery = true; } if (txt_endDateTime.Text.Length > 0) { condition.Append(" NotifyDate <= '" + txt_endDateTime.Text + "' and"); isquery = true; } if (isquery) { query.Append(" WHERE " + condition.ToString().Substring(0, condition.ToString().Length - 3)); } query.Append(" GROUP BY FaultDescribe order by counts desc"); DataSet ds = db.SelectQuery(query.ToString()); //Session["DS_MIS"] = ds; gv.DataSource = ds; gv.DataBind(); if (ds.Tables[0].Rows.Count == 0) { ShowMsg2(UpdatePanel1, "查詢無資料"); } }
protected void SearchData() { gv.DataSource = null; gv.DataBind(); SQLDB db = new SQLDB(); StringBuilder query = new StringBuilder(" select * "); query.Append(" from View_ICS_InventoryCost "); string conditionName = ddlst_SearchType.SelectedValue; StringBuilder condition = new StringBuilder(); bool isquery = false; if (txt_Query_Reason.Text.Trim().Length > 0) { condition.Append(conditionName + " like '%" + txt_Query_Reason.Text.Trim() + "%' and"); isquery = true; } if (txt_startDateTime.Text.Length > 0) { condition.Append(" si.UpdateTime >= '" + txt_startDateTime.Text + "' and"); isquery = true; } if (txt_endDateTime.Text.Length > 0) { condition.Append(" si.UpdateTime <= '" + txt_endDateTime.Text + "' and"); isquery = true; } if (isquery) { query.Append(" WHERE " + condition.ToString().Substring(0, condition.ToString().Length - 3)); } DataSet ds = db.SelectQuery(query.ToString()); //Session["DS_MIS"] = ds; gv.DataSource = ds; gv.DataBind(); if (ds.Tables[0].Rows.Count == 0) { ShowMsg2(UpdatePanel1, "查詢無資料"); } }
//修改模式載入資料 private bool LoadData() { bool suc = false; SQLDB _operator = new SQLDB(); if (hidden_Caseid.Value != null ) { DataSet ds = new DataSet(); ds = _operator.Select("caseid = '" + hidden_Caseid.Value + "'", "", "WarrantyNotify"); if (ds.Tables[0].Rows.Count > 0) { suc = true; DataRow dr = ds.Tables[0].Rows[0]; DropDownList_DeviceID.SelectedValue = dr["DeviceID"].ToString(); TextBox_DeviceID_add.Text = dr["DeviceID"].ToString(); //找出保固廠商的廠商編號,因為資料庫只有紀錄廠商名稱 if (dr["WarrantyCompany"].ToString().Length > 0) { DataSet ds_company = (DataSet)Application["App_Mis_Company"]; DataRow[] dr_company = ds_company.Tables[0].Select("CompanyName = '" + dr["WarrantyCompany"].ToString() + "'"); DropDownList_WarrantyCompany_add.SelectedValue = dr_company[0]["CompanyID"].ToString(); } DropDownList_WarrantyContract_add.SelectedValue = dr["WarrantyContract"].ToString(); DropDownList_FaultModel_add.SelectedValue = dr["FaultModel"].ToString(); TextBox_FaultDescribe_add.Text = dr["FaultDescribe"].ToString(); DropDownList_ContractCombineNum.SelectedValue = dr["ContractCombineNum"].ToString(); if (dr["NotifyDate"].ToString().Length > 0) TextBox_NotifyDate_add.Text = Convert.ToDateTime(dr["NotifyDate"].ToString()).ToString("yyyy-MM-dd HH:mm:ss"); if (dr["RepairDeadline"].ToString().Length > 0) { TextBox_RepairDeadline_add.Text = Convert.ToDateTime(dr["RepairDeadline"].ToString()).ToString("yyyy-MM-dd HH:mm:ss"); } DropDownList_RepairDateOption_add.SelectedValue = dr["RepairDateOption"].ToString(); //併案編號 DropDownList_ContractCombineNum.SelectedValue = dr["ContractCombineNum"].ToString(); //重複通知說明 TextBox_RepeatNotify_add.Text = dr["RepeatNotify"].ToString(); } } return suc; }
protected void gv_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "cmd_delete") { int index = Convert.ToInt32(e.CommandArgument); GridViewRow row = gv.Rows[index]; string filename = row.Cells[0].Text; string delete = " delete StudyFileUpload where FileName = '" + filename + "'"; SQLDB _operator = new SQLDB(); if (_operator.ExecuteStatement(delete)) { ShowMsg(UpdatePanel1, "刪除成功"); SearchData(); } try { string strDestPath = Server.MapPath("../Temp/"); FileInfo TheFile = new FileInfo(@strDestPath+filename); if (TheFile.Exists) { File.Delete(@strDestPath + filename); } else { throw new FileNotFoundException(); } } catch (FileNotFoundException ex) { ShowMsg(UpdatePanel1, ex.Message); } catch (Exception ex) { ShowMsg(UpdatePanel1, ex.Message); } } }
protected void SearchData() { gv.DataSource = null; gv.DataBind(); SQLDB db = new SQLDB(); StringBuilder query = new StringBuilder(" select DeviceID,isnull(AVG(ABS(datediff(day,NotifyDate,RepairDate))),0) as RepairAvgDay FROM WarrantyNotify "); string conditionName = ddlst_SearchType.SelectedValue; StringBuilder condition = new StringBuilder(); bool isquery = false; if (txt_Query_Reason.Text.Trim().Length > 0) { condition.Append(conditionName + " like '%" + txt_Query_Reason.Text.Trim() + "%' and"); isquery = true; } if (txt_startDateTime.Text.Length > 0) { condition.Append(" NotifyDate >= '" + txt_startDateTime.Text + "' and"); isquery = true; } if (txt_endDateTime.Text.Length > 0) { condition.Append(" NotifyDate <= '" + txt_endDateTime.Text + "' and"); isquery = true; } if (isquery) { query.Append(" WHERE " + condition.ToString().Substring(0, condition.ToString().Length - 3)); } query.Append(" group by DeviceID order by RepairAvgDay desc"); DataSet ds = db.SelectQuery(query.ToString()); gv.DataSource = ds; gv.DataBind(); if (ds.Tables[0].Rows.Count == 0) { ShowMsg2(UpdatePanel1, "查詢無資料"); } }
protected void SearchData() { SQLDB _operator = new SQLDB("VD_DOORSILL", "KPT"); string conditionName = ddlst_SearchType.SelectedValue; string condition = (txt_Query_Reason.Text.Trim().Length > 0 ? " " + conditionName + " like '%" + txt_Query_Reason.Text.Trim() + "%' " : ""); //condition += query_company; DataSet ds = _operator.Select(condition); ////LINQ 測試 //DataSet ds_std = _operator.Select("", "", "VD_DOORSILL"); //DataTable dt = ds_std.Tables[0]; //var std = ( // from std_table in dt.AsEnumerable() // where std_table.Field<string>("DeviceID").ToString().Equals("V012441") // select std_table); //std.Single().SetField("DeviceID", "test"); //if (std.Any()) //{ // DataTable dt_door = std.CopyToDataTable(); // gv.DataSource = dt_door; // gv.DataBind(); //} //else //{ // ShowMsg2(UpdatePanel1, "查詢無資料"); //} Session["DS_MIS"] = ds; if (ds.Tables[0].Rows.Count > 0) { gv.DataSource = ds; gv.DataBind(); } else { ShowMsg2(UpdatePanel1, "查詢無資料"); } }
protected void submit_Click(object sender, EventArgs e) { Auth auth = new Auth(); SQLDB db = new SQLDB(); string netname = Netname.Text.ToUpper(); string login = Login.Text.ToUpper(); string password = Password.Text; string tab_num = auth.Authentication(netname, login, password); if (tab_num != null) { List<Role> roles = auth.getRoles(tab_num); Person pers = new Person(null, login, password, tab_num, auth.getRoles(tab_num)); Session["User"] = pers; if (roles != null) { db.insertLogon(tab_num, DateTime.Now, Request.UserHostAddress, Request.UserAgent); Response.Redirect("TimeTable.aspx?role=" + roles[0].RoleID); } else MessageBox.Show("Вам не присвоена роль!"); } else MessageBox.Show("Неправильный логин или пароль!"); }
protected void SearchData() { SQLDB _operator = new SQLDB("VD_ERRORRECORD", "KPT"); string conditionName = ddlst_SearchType.SelectedValue; StringBuilder condition = new StringBuilder(); if (conditionName.Equals("RecordTime") || conditionName.Equals("UpdateTime")) { if (txt_StartDate.Text.Length > 0 && txt_EndDate.Text.Length > 0) { condition.Append(conditionName + "> '" + txt_StartDate.Text + "' AND " + conditionName + "< '" + txt_EndDate.Text + "' "); } else { if (txt_StartDate.Text.Length > 0) { condition.Append(conditionName + "> '" + txt_StartDate.Text + "' "); } else { condition.Append(conditionName + "< '" + txt_EndDate.Text + "' "); } } } else { condition.Append(txt_Query_Reason.Text.Trim().Length > 0 ? " " + conditionName + " like '%" + txt_Query_Reason.Text.Trim() + "%' " : ""); } DataSet ds = _operator.Select(condition.ToString()); Session["DS_MIS"] = ds; gv.DataSource = ds; gv.DataBind(); if (ds.Tables[0].Rows.Count == 0) { ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert(\"查詢無資料\");", true); //ShowMsg2(UpdatePanel1, "查詢無資料"); } }
protected void Page_Init(object sender, EventArgs e) { // авторизация Windows Auth auth = new Auth(); SQLDB db = new SQLDB(); string netname = ""; string user = User.Identity.Name.ToUpper(); if (user.Contains("\\")) netname = user.Substring(user.IndexOf('\\') + 1, user.Length - user.IndexOf('\\') - 1); string tab_num = auth.Authentication(netname, "", ""); //string tab_num = auth.Authentication(user, "", ""); if (tab_num != null) { List<Role> roles = auth.getRoles(tab_num); Person pers = new Person(user, null, null, tab_num, roles); Session["User"] = pers; if (roles != null) { db.insertLogon(tab_num, DateTime.Now, Request.UserHostAddress, Request.UserAgent); Response.Redirect("TimeTable.aspx?role=" + roles[0].RoleID); } else MessageBox.Show("Вам не присвоена роль! "); } }
//private void ExportTOExcel() //{ // ExcelReport report = null; // try // { // report = new ExcelReport("MIS/EquipmentData"); // DataSet ds = (DataSet)Session["DS_MIS"]; // for (int j = 0; j < ds.Tables[0].Rows.Count; j++) // { // report.FillData(j + 3, 1, ds.Tables[0].Rows[j]["DeviceID"].ToString(), 1); // report.FillData(j + 3, 2, ds.Tables[0].Rows[j]["DeviceModelName"].ToString(), 1); // report.FillData(j + 3, 3, ds.Tables[0].Rows[j]["RegionName"].ToString(), 1); // report.FillData(j + 3, 4, ds.Tables[0].Rows[j]["SectorName"].ToString(), 1); // report.FillData(j + 3, 5, ds.Tables[0].Rows[j]["TCModel"].ToString(), 1); // report.FillData(j + 3, 6, ds.Tables[0].Rows[j]["ContractName"].ToString(), 1); // report.FillData(j + 3, 7, ds.Tables[0].Rows[j]["DeviceStatus"].ToString(), 1); // report.FillData(j + 3, 8, ds.Tables[0].Rows[j]["DeviceNote"].ToString(), 1); // report.FillData(j + 3, 9, ds.Tables[0].Rows[j]["Longitude"].ToString(), 1); // report.FillData(j + 3, 10, ds.Tables[0].Rows[j]["Latitude"].ToString(), 1); // //report.FillData(j + 1, 2, ds.Tables[0].Rows[j]["DevicePhoto"].ToString(), 1); // } // ScriptManager.RegisterStartupScript(this, this.GetType(), "newprintwindow2", "open_new_window(\"../Temp/" + report.Report() + "\");", true); // } // catch (Exception e) // { // if (report != null) // { // ScriptManager.RegisterStartupScript(this, this.GetType(), "newprintwindow2", "open_new_window(\"../Temp/" + report.Report() + "\");", true); // } // } // finally // { // try // { // report.Close(); // } // catch (Exception ex) // { // } // } //} /// <summary> /// 重新計算檢修周期:以設備合約起始日期開始累加檢修週期直到合約截止 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lnkbtn_Add_Click(object sender, EventArgs e) { SQLDB db = new SQLDB(); //先將舊有檢修日期刪除 string deleteCheckDate = "Delete from CD_DeviceCheckDate where 1=1"; db.ExecuteStatement(deleteCheckDate); string queryDevice = "SELECT [Device_ID],[ContractStartDate],[ContractEndDate],[Cycle] FROM [View_DeviceConfig] where [ContractStartDate] is not null and [ContractEndDate] is not null"; DataSet ds = db.SelectQuery(queryDevice); DataSet ds_checkdate = db.Select("1 = 0", "", "CD_DeviceCheckDate"); for (int i = 0; i < ds.Tables[0].Rows.Count ; i++) { string device = ds.Tables[0].Rows[i]["Device_ID"].ToString(); DateTime start = Convert.ToDateTime(ds.Tables[0].Rows[i]["ContractStartDate"].ToString()); DateTime end = Convert.ToDateTime(ds.Tables[0].Rows[i]["ContractEndDate"].ToString()); TimeSpan cycle = TimeSpan.FromDays( Convert.ToDouble( ds.Tables[0].Rows[i]["cycle"].ToString())); while (start < end) { start += cycle; if (start < end) { DataRow dr = ds_checkdate.Tables[0].NewRow(); dr["Device_ID"] = ds.Tables[0].Rows[i]["Device_ID"].ToString(); dr["CheckDate"] = start.ToString("yyyy/MM/dd HH:mm:ss"); ds_checkdate.Tables[0].Rows.Add(dr); } } } //開始將檢修日期塞到資料庫 DataSet DSChange = ds_checkdate.GetChanges(); if (db.Insert(DSChange)) { ShowMsg(UpdatePanel1, "資料計算成功"); } }
protected void gv_RowCommand(object sender, GridViewCommandEventArgs e) { SQLDB db = new SQLDB(); if (e.CommandName == "singleMapView") { int index = Convert.ToInt32(e.CommandArgument); GridViewRow row = gv.Rows[index]; string id = row.Cells[2].Text; Response.Redirect("mapViewer.aspx?type=Device&id=" + id); } if (e.CommandName == "Search") { int index = Convert.ToInt32(e.CommandArgument); DataSet DS = db.Select("device_id = '" + gv.Rows[index].Cells[2].Text.Replace(" ", "") + "'", " CheckDate desc", "CD_DeviceCheckDate"); //hid_deviceid.Value = gv2.Rows[index].Cells[0].Text.Replace(" ", ""); if (DS.Tables[0].Rows.Count > 0) { Session["MIS_DeviceHeckDate"] = DS; gv3.DataSource = DS; gv3.DataBind(); } else { gv3.DataSource = null; gv3.DataBind(); ShowMsg2(UpdatePanel2, "無資料"); } } }
protected void lnkbtn_saveStandardall_Click(object sender, EventArgs e) { SQLDB _operator = new SQLDB("VD_Info", "KPT"); string query = "select vdid from VD_Info group by vdid"; DataSet ds_allvd = _operator.SelectQuery(query); for (int f = 10; f < ds_allvd.Tables[0].Rows.Count; f++) { int vsrdir2 = 2; for (int k = 0; k < vsrdir2; k++) { DataSet dsCaledStd = new DataSet(); dsCaledStd = calStandard(ds_allvd.Tables[0].Rows[f]["vdid"].ToString(), k.ToString(), new DateTime(2014, 06, 09, 12, 0, 0), new DateTime(2014, 07, 09, 12, 0, 0)); if (dsCaledStd.Tables[0].Rows.Count > 0) { DataSet ds_standard = _operator.Select("", "", "VD_STANDARD"); DateTime updatetime = DateTime.Now; DataSet ds_standardAdd = _operator.Select("1=0", "", "VD_STANDARD"); DataSet ds_standardAddHis = _operator.Select("1=0", "", "VD_STANDARD_HIS"); for (int i = 0; i < dsCaledStd.Tables[0].Rows.Count; i++) { DataRow dr = dsCaledStd.Tables[0].Rows[i]; string vdid = dr["vdid"].ToString(); string vsrdir = dr["vsrdir"].ToString(); string week = dr["week"].ToString(); string hours = dr["hours"].ToString(); DataRow[] dr_std = ds_standard.Tables[0].Select("Vdid = '" + vdid + "' AND Vsrdir = '" + vsrdir + "' AND Week = '" + week + "' AND Hours = '" + hours + "' "); DataRow dr_add = ds_standardAdd.Tables[0].NewRow(); dr_add["Vdid"] = vdid; dr_add["TypeName"] = "Default"; dr_add["Vsrdir"] = vsrdir; dr_add["Hours"] = hours; dr_add["Week"] = week; dr_add["SpeedAvg"] = dr["SpeedAvg"].ToString(); dr_add["SpeedStandard"] = dr["SpeedStandard"].ToString(); dr_add["LaneOccupyAvg"] = dr["LaneOccupyAvg"].ToString(); dr_add["LaneOccupyStandard"] = dr["LaneOccupyStandard"].ToString(); dr_add["FlowAvg"] = dr["FlowAvg"].ToString(); dr_add["FlowStandard"] = dr["FlowStandard"].ToString(); dr_add["Times"] = 2; dr_add["UpdateTime"] = updatetime; ds_standardAdd.Tables[0].Rows.Add(dr_add); //將有衝突的標準型態備份到VD_STANDARD_HIS if (dr_std.Length > 0) { DataRow dr_addhis = ds_standardAddHis.Tables[0].NewRow(); dr_addhis["StandardNum"] = dr_std[0]["StandardNum"]; dr_addhis["Vdid"] = vdid; dr_addhis["TypeName"] = "Default"; dr_addhis["Vsrdir"] = vsrdir; dr_addhis["Hours"] = hours; dr_addhis["Week"] = week; dr_addhis["SpeedAvg"] = dr_std[0]["SpeedAvg"].ToString(); dr_addhis["SpeedStandard"] = dr_std[0]["SpeedStandard"].ToString(); dr_addhis["LaneOccupyAvg"] = dr_std[0]["LaneOccupyAvg"].ToString(); dr_addhis["LaneOccupyStandard"] = dr_std[0]["LaneOccupyStandard"].ToString(); dr_addhis["FlowAvg"] = dr_std[0]["FlowAvg"].ToString(); dr_addhis["FlowStandard"] = dr["FlowStandard"].ToString(); dr_addhis["Times"] = 2; dr_addhis["UpdateTime"] = updatetime; ds_standardAddHis.Tables[0].Rows.Add(dr_addhis); dr_std[0].Delete(); } } DataSet DSChange = ds_standard.GetChanges(DataRowState.Deleted); if (DSChange != null) { if (_operator.Delete(DSChange)) { // ShowMsg(UpdatePanel1, "資料刪除成功"); } } DataSet DSChangeAdd = ds_standardAdd.GetChanges(); DataSet DSChangeAddHis = ds_standardAddHis.GetChanges(); bool suc = false; if (DSChangeAdd != null) { if (_operator.Insert(DSChangeAdd)) { suc = true; } } if (DSChangeAddHis != null) { if (_operator.Insert(DSChangeAdd)) { suc = true; } } //if (suc) //{ // ShowMsg(UpdatePanel2, "建立成功"); //} } } } ShowMsg(UpdatePanel2, "建立成功"); }