protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
DataTable dt = new DYDAB01Service().GetDataTable(null);
this.dataGridView1.DataSource = dt;
}
void bgw_DoWork(object sender, DoWorkEventArgs e)
{
List <SortInfo> lstSortInfo = e.Argument as List <SortInfo>;
DYDAB01Service dyDab01Service = new DYDAB01Service();
DataTable dt = dyDab01Service.GetDataTable(data.ID);
List <DYDAB01Row> lstDyDab01 = new List <DYDAB01Row>();
foreach (DataRow dr in dt.Rows)
{
DYDAB01Row dyDab01 = DYDAB01Row.GetModel(dr);
lstDyDab01.Add(dyDab01);
}
e.Result = GetLstDYDAB01Row(lstSortInfo, lstDyDab01);
}
void bgwLoad_DoWork(object sender, DoWorkEventArgs e)
{
UnitType unitType = (UnitType)e.Argument;
List <string> lstdydm = PublicMethods.GetLstStringByLstT(lstAssetsData, "ID");
DBAccessEx dbAccess = localService.GetNewDBAccessEx();
dbAccess.BeginTransaction();
if (unitType == UnitType.EnUnit)
{
DYDAB01Service dyDAB01Service = new DYDAB01Service(dbAccess);
DataTable dtDydmWithOutYymd = dyDAB01Service.GetDataTableWithOutYYMD(decParams.ProID, decParams.Pjnd, OrganizationType.Dydm, lstdydm);
if (dtDydmWithOutYymd != null && dtDydmWithOutYymd.Rows.Count > 0)
{
dtDydmWithOutYymd.TableName = "yymd";
e.Result = dtDydmWithOutYymd;
return;
}
}
DataTable dtPreMonthData;
PreMonthDataService preMonthDataService = new PreMonthDataService(dbAccess);
if (unitType == UnitType.CnUnit)
{
dtPreMonthData = preMonthDataService.GetDataTableCN(decParams.ProID, decParams.Pjnd, lstdydm);
}
else
{
dtPreMonthData = preMonthDataService.GetDataTableEN(decParams.ProID, decParams.Pjnd, lstdydm);
}
dbAccess.Commit();
DataTable dtEmpty = dtPreMonthData.Clone();
GetEmptyDataTable(ref dtEmpty);
MergerDataTable(ref dtEmpty, dtPreMonthData);
e.Result = dtEmpty;
}
/// <summary>
/// 填充数据，刚开始数据不全时调用
/// </summary>
private void FillData()
{
DYDAB01Service dyDab01Service = new DYDAB01Service();
DataTable dt = dyDab01Service.GetDataTable(null);
Random rd = new Random();
//遍历行
foreach (DataRow dr in dt.Rows)
{
string filedName;
//遍历排序类型
foreach (SortType item in Enum.GetValues(typeof(SortType)))
{
int curIndex;
Array array;
filedName = item.ToString();
switch (item)
{
case SortType.YQCLX:
array = Enum.GetValues(typeof(EnumYQCLX));
curIndex = rd.Next(array.Length);
EnumYQCLX yqclx = (EnumYQCLX)curIndex;
dr[filedName] = EnumDictionary <EnumYQCLX> .Instance.GetDescription(yqclx);
break;
case SortType.QDLX:
array = Enum.GetValues(typeof(EnumQDLX));
curIndex = rd.Next(array.Length);
EnumQDLX qdlx = (EnumQDLX)curIndex;
dr[filedName] = EnumDictionary <EnumQDLX> .Instance.GetDescription(qdlx);
break;
case SortType.QBLX:
array = Enum.GetValues(typeof(EnumQBLX));
curIndex = rd.Next(array.Length);
EnumQBLX qblx = (EnumQBLX)curIndex;
dr[filedName] = EnumDictionary <EnumQBLX> .Instance.GetDescription(qblx);
break;
case SortType.KFFS:
array = Enum.GetValues(typeof(EnumKFFS));
curIndex = rd.Next(array.Length);
EnumKFFS kffs = (EnumKFFS)curIndex;
dr[filedName] = EnumDictionary <EnumKFFS> .Instance.GetDescription(kffs);
break;
case SortType.CLLB:
array = Enum.GetValues(typeof(EnumCLLB));
curIndex = rd.Next(array.Length);
EnumCLLB cllb = (EnumCLLB)curIndex;
dr[filedName] = EnumDictionary <EnumCLLB> .Instance.GetDescription(cllb);
break;
case SortType.KFZT:
array = Enum.GetValues(typeof(EnumKFZT));
curIndex = rd.Next(array.Length);
EnumKFZT kfzt = (EnumKFZT)curIndex;
dr[filedName] = EnumDictionary <EnumKFZT> .Instance.GetDescription(kfzt);
break;
default:
break;
}
}
}
dyDab01Service.DBAccess.UpdateDateTable(dt, "select * from DYDAB01");
}
void bgwSave_DoWork(object sender, DoWorkEventArgs e)
{
DataTable dtData = e.Argument as DataTable;
DBAccessEx dbAccess = localService.GetNewDBAccessEx();
dbAccess.BeginTransaction();
//首先删除表中数据，删除数据分主表和字表，主表为preline,字表为premonthdata
PreLineService m_PreLineService = new PreLineService(dbAccess);
m_PreLineService.Delete(decParams.ProID, decParams.Pjnd, decParams.Dydm, StudyType.DYFX);
PreMonthDataService m_PreMonthDataService = new PreMonthDataService(dbAccess);
m_PreMonthDataService.Delete(decParams.ProID, decParams.Pjnd, decParams.Dydm);
//插入线数据
string prelineID_YCY = Guid.NewGuid().ToString(); //月产油
string prelineID_YCQ = Guid.NewGuid().ToString(); //月产气
DataTable dt_preline = m_PreLineService.GetEmptyDataTable();
//插入月产油数据
DataRow dr_line_ycy = dt_preline.NewRow();
dr_line_ycy["prelineID"] = prelineID_YCY;
dr_line_ycy["proID"] = decParams.ProID;
dr_line_ycy["pjnd"] = decParams.Pjnd;
dr_line_ycy["dydm"] = decParams.Dydm;
dr_line_ycy["studyType"] = "DYFX";
dr_line_ycy["seriesName"] = "ycy";
dt_preline.Rows.Add(dr_line_ycy);
//插入月产气数据
DataRow dr_line_ycq = dt_preline.NewRow();
dr_line_ycq["prelineID"] = prelineID_YCQ;
dr_line_ycq["proID"] = decParams.ProID;
dr_line_ycq["pjnd"] = decParams.Pjnd;
dr_line_ycq["dydm"] = decParams.Dydm;
dr_line_ycq["studyType"] = "DYFX";
dr_line_ycq["seriesName"] = "ycq";
dt_preline.Rows.Add(dr_line_ycq);
m_PreLineService.Insert(dt_preline);
//插入预测数据
DataTable dt_data = m_PreMonthDataService.GetEmptyDataTable();
foreach (DataRow dr in dtData.Rows)
{
//添加月产油
DataRow dr_data_ycy = dt_data.NewRow();
dr_data_ycy["prelineID"] = prelineID_YCY;
dr_data_ycy["NY"] = dr["NY"];
double ycy = dr["YCY"].ToDouble();
if (tsbUnitSwich.Text == "切换为英式单位")
{
DYDAB01Service M_DYDAB01Service = new DYDAB01Service();
double YYMD = M_DYDAB01Service.GetYYMD(decParams.ProID, decParams.Dydm);
ycy = InternalMethods.GetWTonByMBBL(ycy, YYMD);
}
dr_data_ycy["YCValue"] = dr["YCY"];
dt_data.Rows.Add(dr_data_ycy);
//添加月产气
DataRow dr_data_ycq = dt_data.NewRow();
dr_data_ycq["prelineID"] = prelineID_YCQ;
dr_data_ycq["NY"] = dr["NY"];
double YCQ = dr["YCQ"].ToDouble();
if (tsbUnitSwich.Text == "切换为英式单位")
{
DYDAB01Service M_DYDAB01Service = new DYDAB01Service();
YCQ = InternalMethods.GetM3ByMCF(YCQ);
}
dr_data_ycq["YCValue"] = YCQ;
dt_data.Rows.Add(dr_data_ycq);
}
e.Result = m_PreMonthDataService.Insert(dt_data);
dbAccess.Commit();
}
