// 失分说明 public List <LossResultDto> SubjectLossImport(string ossPath) { // 从OSS下载文件 string downLoadFilePath = basePath + @"Excel\ExcelImport\" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + ".xlsx"; OSSClientHelper.GetObject(ossPath, downLoadFilePath); Workbook book = Workbook.Load(downLoadFilePath, false); Worksheet sheet = book.Worksheets[3]; List <LossResultDto> list = new List <LossResultDto>(); for (int i = 0; i < 10000; i++) { string subjectCode = sheet.GetCell("A" + (i + 3)).Value == null ? "" : sheet.GetCell("A" + (i + 3)).Value.ToString().Trim(); if (string.IsNullOrEmpty(subjectCode)) { break; } LossResultDto loss = new LossResultDto(); loss.SubjectCode = subjectCode; loss.LossDesc = sheet.GetCell("B" + (i + 3)).Value == null ? "" : sheet.GetCell("B" + (i + 3)).Value.ToString().Trim(); list.Add(loss); } return(list); }
public override void AddRowButtonClick() { LossResultDto loss = new LossResultDto(); List <LossResultDto> lossList = grcLossReg.DataSource as List <LossResultDto>; int seqNO = 0; if (lossList == null || lossList.Count == 0) { loss.LossCode = Convert.ToString(1); } else { foreach (LossResultDto inp in lossList) { if (Convert.ToInt32(inp.LossCode) > seqNO) { seqNO = Convert.ToInt32(inp.LossCode); } } } loss.LossCode = (seqNO + 1).ToString(); loss.InDateTime = DateTime.Now; loss.InUserID = "sysadmin"; dataHandler.AddRow(loss); }
//绑定失分说明 public static void BindLoss(ComboBoxEdit combox1, ComboBoxEdit combox2, ComboBoxEdit combox3, string projectCode, string subjectCode) { List <LossResultDto> losslist = new List <LossResultDto>(); LossResultDto l = new LossResultDto(); l.LossCode = ""; l.LossName = "选择"; losslist.Add(l); List <LossResultDto> losslist1 = new List <LossResultDto>(); LossResultDto l1 = new LossResultDto(); l1.LossCode = ""; l1.LossName = "选择"; losslist1.Add(l1); List <LossResultDto> losslist2 = new List <LossResultDto>(); LossResultDto l2 = new LossResultDto(); l2.LossCode = ""; l2.LossName = "选择"; losslist2.Add(l2); //DataSet ds = webService.SearchLoss(projectCode, subjectCode); DataSet ds = null; if (IsNetWork) { ds = webService.SearchLoss(projectCode, subjectCode); } else { localService.Url = "http://192.168.1.99/XHX.YiQiServer/service.asmx"; ds = localService.SearchLoss(projectCode, subjectCode); } if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { LossResultDto loss = new LossResultDto(); loss.LossCode = Convert.ToString(ds.Tables[0].Rows[i]["LossCode"]); loss.LossName = Convert.ToString(ds.Tables[0].Rows[i]["LossName"]); loss.LossType = Convert.ToString(ds.Tables[0].Rows[i]["LossType"]); if (loss.LossType == "01") { losslist.Add(loss); } else if (loss.LossType == "02") { losslist1.Add(loss); } else { losslist2.Add(loss); } } } CommonHandler.SetComboBoxEditItems(combox1, losslist, "LossName", "LossName"); CommonHandler.SetComboBoxEditItems(combox2, losslist1, "LossName", "LossName"); CommonHandler.SetComboBoxEditItems(combox3, losslist2, "LossName", "LossName"); }
private void grvLossReg_CustomDrawCell(object sender, DevExpress.XtraGrid.Views.Base.RowCellCustomDrawEventArgs e) { if (grcLossReg.DataSource == null || grvLossReg.RowCount == 0) { return; } LossResultDto loss = grvLossReg.GetRow(e.RowHandle) as LossResultDto; if (e.Column != gcLossName) { e.Appearance.BackColor = Color.Gray; } }
private void grvLossReg_ShowingEditor(object sender, CancelEventArgs e) { LossResultDto shop = grvLossReg.GetRow(grvLossReg.FocusedRowHandle) as LossResultDto; if (grvLossReg.FocusedColumn != gcLossName) { //if (shop.StatusType != 'I') //{ e.Cancel = true; //} //else //{ // e.Cancel = false; //} } }
private void SearchLoss() { List <LossResultDto> LossList = new List <LossResultDto>(); DataSet ds = webService.SearchLoss("", txtLossDesc.Text); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { LossResultDto loss = new LossResultDto(); loss.LossCode = Convert.ToString(ds.Tables[0].Rows[i]["LossCode"]); loss.LossName = Convert.ToString(ds.Tables[0].Rows[i]["LossName"]); loss.InUserID = Convert.ToString(ds.Tables[0].Rows[i]["InUserID"]); loss.InDateTime = Convert.ToDateTime(ds.Tables[0].Rows[i]["InDateTime"]); LossList.Add(loss); } } grcLossReg.DataSource = LossList; }
private void SearchLoss() { List <LossResultDto> LossList = new List <LossResultDto>(); DataSet ds = webService.SearchLossResult(CommonHandler.GetComboBoxSelectedValue(cboProject).ToString(), btnShopCode.Text); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { LossResultDto loss = new LossResultDto(); loss.ProjectCode = Convert.ToString(ds.Tables[0].Rows[i]["ProjectCode"]); loss.ShopCode = Convert.ToString(ds.Tables[0].Rows[i]["ShopCode"]); loss.SubjectCode = Convert.ToString(ds.Tables[0].Rows[i]["SubjectCode"]); loss.LossDesc = Convert.ToString(ds.Tables[0].Rows[i]["LossDesc"]); loss.PicName = Convert.ToString(ds.Tables[0].Rows[i]["PicName"]); loss.SeqNO = Convert.ToInt32(ds.Tables[0].Rows[i]["SeqNO"]); LossList.Add(loss); } } grcLossReg.DataSource = LossList; }
private void SearchLoss(string projectCode, string subjectCode) { List <LossResultDto> LossList1 = new List <LossResultDto>(); List <LossResultDto> LossList2 = new List <LossResultDto>(); List <LossResultDto> LossList3 = new List <LossResultDto>(); DataSet ds = webService.SearchLoss(projectCode, subjectCode); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { LossResultDto loss = new LossResultDto(); loss.ProjectCode = Convert.ToString(ds.Tables[0].Rows[i]["ProjectCode"]); loss.SubjectCode = Convert.ToString(ds.Tables[0].Rows[i]["SubjectCode"]); loss.LossCode = Convert.ToString(ds.Tables[0].Rows[i]["LossCode"]); loss.LossName = Convert.ToString(ds.Tables[0].Rows[i]["LossName"]); loss.InUserID = Convert.ToString(ds.Tables[0].Rows[i]["InUserID"]); loss.InDateTime = Convert.ToDateTime(ds.Tables[0].Rows[i]["InDateTime"]); loss.LossType = Convert.ToString(ds.Tables[0].Rows[i]["LossType"]); if (loss.LossType == "01") { LossList1.Add(loss); } else if (loss.LossType == "02") { LossList2.Add(loss); } else { LossList3.Add(loss); } } } grcLossResult1.DataSource = LossList1; grcLossResult2.DataSource = LossList2; grcLossResult3.DataSource = LossList3; }
private void btnAddRow_Click(object sender, EventArgs e) { if (tabControl.SelectedTab == tabPage1) { LossResultDto inspection = new LossResultDto(); //List<LossResultDto> inspectionList = grcLossResult1.DataSource as List<LossResultDto>; //int seqNO = 0; //if (inspectionList == null || inspectionList.Count == 0) //{ // inspection.LossCode = Convert.ToString(1); //} //else //{ // foreach (LossResultDto inp in inspectionList) // { // if (Convert.ToInt32(inp.LossCode) > seqNO) // { // seqNO = Convert.ToInt32(inp.LossCode); // } // } //} //inspection.LossCode = Convert.ToString(seqNO + 1); inspection.ProjectCode = projectCode; inspection.SubjectCode = subjectCode; dataHandler1.AddRow(inspection); } else if (tabControl.SelectedTab == tabPage2) { LossResultDto inspection = new LossResultDto(); ////List<LossResultDto> inspectionList = grcLossResult2.DataSource as List<LossResultDto>; ////int seqNO = 0; ////if (inspectionList == null || inspectionList.Count == 0) ////{ //// inspection.LossCode = Convert.ToString(1); ////} ////else ////{ //// foreach (LossResultDto inp in inspectionList) //// { //// if (Convert.ToInt32(inp.LossCode) > seqNO) //// { //// seqNO = Convert.ToInt32(inp.LossCode); //// } //// } ////} ////inspection.LossCode = Convert.ToString(seqNO + 1); inspection.ProjectCode = projectCode; inspection.SubjectCode = subjectCode; dataHandler2.AddRow(inspection); } else { LossResultDto inspection = new LossResultDto(); //List<LossResultDto> inspectionList = grcLossResult3.DataSource as List<LossResultDto>; //int seqNO = 0; //if (inspectionList == null || inspectionList.Count == 0) //{ // inspection.LossCode = Convert.ToString(1); //} //else //{ // foreach (LossResultDto inp in inspectionList) // { // if (Convert.ToInt32(inp.LossCode) > seqNO) // { // seqNO = Convert.ToInt32(inp.LossCode); // } // } //} //inspection.LossCode = Convert.ToString(seqNO + 1); inspection.ProjectCode = projectCode; inspection.SubjectCode = subjectCode; dataHandler3.AddRow(inspection); } }