// 失分说明
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);
}
}
