public async Task <ActionResult <Store3> > PostStore3(Store3 store3)
{
_context.Store3s.Add(store3);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetStore3", new { id = store3.Id }, store3));
}
public async Task <IActionResult> PutStore3(long id, Store3 store3)
{
if (id != store3.Id)
{
return(BadRequest());
}
_context.Entry(store3).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!Store3Exists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
private void data_Bind()
{
//项目数据
var projectList = XMProjectService.GetXMProjectList();
Store2.DataSource = projectList;
Store2.DataBind();
//发货点数据(发货仓)
var codeList = CodeService.GetCodeListInfoByCodeTypeID(227);
Store3.DataSource = codeList;
Store3.DataBind();
//省份数据
var provinceList = AreaCodeService.GetAreaCodeByRank(2);
Store4.DataSource = provinceList;
Store4.DataBind();
//物流公司数据
var logisticsList = CodeService.GetCodeListInfoByCodeTypeID(243);
Store7.DataSource = logisticsList;
Store7.DataBind();
}
protected void MyData_Refresh(object sender, StoreRefreshDataEventArgs e)
{
int count = 0;
///是查询
if (isSearch.Text == "1")
{
hiddenlan.Text = txtlan.Text.Trim();
hiddenlanname.Text = txtlanname.Text.Trim();
var list = Sjqd_CpuService.GetSjqd_LanList(hiddenlan.Text, hiddenlanname.Text, 0, pagecut.PageSize, out count);
Store3.DataSource = list;
Store3.DataBind();
(Store3.Proxy[0] as PageProxy).Total = count;
isSearch.Text = "0";
}
else
{
int PageSize = this.pagecut.PageSize;
int IndexSize = e.Start;
if (IndexSize == -1)
{
IndexSize = 0;
}
var list = Sjqd_CpuService.GetSjqd_LanList(hiddenlan.Text, hiddenlanname.Text, IndexSize, pagecut.PageSize, out count);
Store3.DataSource = list;
Store3.DataBind();
(Store3.Proxy[0] as PageProxy).Total = count;
}
}
protected void MyData_Refresh(object sender, StoreRefreshDataEventArgs e)
{
int count = 0;
hiddenplat.Text = comboxPlats.SelectedItem.Value;
hiddensbxh.Text = txtsbxh.Text.Trim();
hiddensbxhname.Text = txtsbxhname.Text.Trim();
///是查询
if (isSearch.Text == "1")
{
var list = Sjqd_SBXHService.GetSjqd_SBXHList(Convert.ToInt32(hiddenplat.Text), hiddensbxhname.Text, hiddensbxh.Text, 0, pagecut.PageSize + 1, out count);
Store3.DataSource = list;
Store3.DataBind();
(Store3.Proxy[0] as PageProxy).Total = count;
isSearch.Text = "0";
}
else
{
int PageSize = this.pagecut.PageSize;
int IndexSize = e.Start;
if (IndexSize == -1)
{
IndexSize = 0;
}
var list = Sjqd_SBXHService.GetSjqd_SBXHList(Convert.ToInt32(hiddenplat.Text), hiddensbxhname.Text, hiddensbxh.Text, IndexSize, pagecut.PageSize, out count);
Store3.DataSource = list;
Store3.DataBind();
(Store3.Proxy[0] as PageProxy).Total = count;
}
}
public void PYchange(string py, string store)
{
string oracletext = "select * from M_OBJECT where RISK_TYPESID = 8 and MO_F_PINYIN like '%" + py.ToUpper() + "%'";
switch (store)
{
case "Store1":
string oracletext1 = "select * from M_OBJECT where RISK_TYPESID = " + extRISK_TYPESNUMBER.SelectedItem.Value.Trim() + " and MO_F_PINYIN like '%" + py.ToUpper() + "%'";
Store1.DataSource = OracleHelper.Query(oracletext1);
Store1.DataBind();
break;
case "Store2":
Store2.DataSource = OracleHelper.Query(oracletext);
Store2.DataBind();
break;
case "Store3":
Store3.DataSource = OracleHelper.Query(oracletext);
Store3.DataBind();
break;
case "Store4":
Store4.DataSource = OracleHelper.Query(oracletext);
Store4.DataBind();
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
string fechaInicio, fechaFin;
if (DateField1.Text == "" || DateField1.Text == "01/01/0001 12:00:00 a.m.")
{
fechaInicio = "";
}
else
{
fechaInicio = Convert.ToDateTime(DateField1.Text).ToString("yyyy-MM-dd");
}
if (DateField2.Text == "" || DateField2.Text == "01/01/0001 12:00:00 a.m.")
{
fechaFin = "";
}
else
{
fechaFin = Convert.ToDateTime(DateField2.Text).ToString("yyyy-MM-dd");
}
wsConsultaReportesDA.wsConsultaReportesDA reportegral = new wsConsultaReportesDA.wsConsultaReportesDA();
List <wsConsultaReportesDA.ReporteSiniestrosDA> lista = new List <wsConsultaReportesDA.ReporteSiniestrosDA>(reportegral.ReporteSiniestros(1, fechaInicio, fechaFin, 9));
//indicadores.wsIndicadoresPrybe indica = new indicadores.wsIndicadoresPrybe();
//List<indicadores.CoopAseg> lista = new List<indicadores.CoopAseg>(indica.CotizacionesPorCoopAseg(fechaInicio, fechaFin));
//Store1.DataSource = lista;
//Store1.DataBind();
Store3.DataSource = lista;
Store3.DataBind();
}
private void BindCombox()
{
DataTable dt = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_ComboBoxBinder_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "PrintForStat")
}).GetTable();
if (dt != null && dt.Rows.Count > 0)
{
Store2.DataSource = dt;
Store2.DataBind();
}
DataTable dt1 = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_ComboBoxBinder_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "PrintForSys")
}).GetTable();
if (dt1 != null && dt1.Rows.Count > 0)
{
Store3.DataSource = dt1;
Store3.DataBind();
}
DataSet dt2 = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_Print_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "PrinterForPrinter")
}).GetList();
StorePrinter.DataSource = dt2;
StorePrinter.DataBind();
}
protected void MyData_Refresh(object sender, StoreRefreshDataEventArgs e)
{
//是查询
if (isSearch.Text == "1")
{
hiddenplat.Text = comboxPlats.SelectedItem.Value;
hiddensoft.Text = comboxSofts.SelectedItem.Value;
hiddenversion.Text = txtversion.Text.Trim();
var list = Sjqd_SoftVersionsService.GetSoftVersions(Convert.ToInt32(hiddensoft.Text), Convert.ToInt32(hiddenplat.Text), hiddenversion.Text);
Store3.DataSource = list.Take(this.pagecut.PageSize + 1);
Store3.DataBind();
(Store3.Proxy[0] as PageProxy).Total = list.Count();
isSearch.Text = "0";
}
else
{
int PageSize = this.pagecut.PageSize;
int IndexSize = e.Start;
if (IndexSize == -1)
{
IndexSize = 0;
}
var list = Sjqd_SoftVersionsService.GetSoftVersions(Convert.ToInt32(hiddensoft.Text), Convert.ToInt32(hiddenplat.Text), hiddenversion.Text);
Store3.DataSource = list.Skip(IndexSize).Take(PageSize);
Store3.DataBind();
(Store3.Proxy[0] as PageProxy).Total = list.Count();
}
}
protected void FillTimeApproval(int dayId, int employeeId)
{
try
{
string rep_params = "";
Dictionary <string, string> parameters = new Dictionary <string, string>();
parameters.Add("1", employeeId.ToString());
parameters.Add("2", dayId.ToString());
parameters.Add("3", dayId.ToString());
parameters.Add("4", "0");
parameters.Add("5", "0");
parameters.Add("6", "0");
parameters.Add("7", "0");
parameters.Add("8", "0");
parameters.Add("9", "0");
parameters.Add("10", "0");
foreach (KeyValuePair <string, string> entry in parameters)
{
rep_params += entry.Key.ToString() + "|" + entry.Value + "^";
}
if (rep_params.Length > 0)
{
if (rep_params[rep_params.Length - 1] == '^')
{
rep_params = rep_params.Remove(rep_params.Length - 1);
}
}
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = rep_params;
ListResponse <Time> Times = _timeAttendanceService.ChildGetAll <Time>(req);
timeCode = ConstTimeVariationType.TimeCodeList(_systemService);
if (!Times.Success)
{
Common.errorMessage(Times);
return;
}
Times.Items.ForEach(x =>
{
x.timeCodeString = timeCode.Where(y => y.key == Convert.ToInt16(x.timeCode)).Count() != 0 ? timeCode.Where(y => y.key == Convert.ToInt32(x.timeCode)).First().value : string.Empty;
x.statusString = FillApprovalStatus(x.status);
});
Store3.DataSource = Times.Items;
////List<ActiveLeave> leaves = new List<ActiveLeave>();
//leaves.Add(new ActiveLeave() { destination = "dc", employeeId = 8, employeeName = new Model.Employees.Profile.EmployeeName() { fullName = "vima" }, endDate = DateTime.Now.AddDays(10) });
Store3.DataBind();
}
catch (Exception exp)
{
X.Msg.Alert(Resources.Common.Error, exp.Message).Show();
}
}
protected void documentsStore_ReadData(object sender, StoreReadDataEventArgs e)
{
//GEtting the filter from the page
string filter = string.Empty;
int totalCount = 1;
//Fetching the corresponding list
//in this test will take a list of News
DocumentListRequest request = new DocumentListRequest();
request.Status = 0;
request.Filter = "";
ListResponse <AdminDocument> routers = _administrationService.ChildGetAll <AdminDocument>(request);
if (!routers.Success)
{
Common.errorMessage(routers);
return;
}
if (!string.IsNullOrEmpty(DeptId1.Text))
{
Store1.DataSource = routers.Items.Where(x => x.departmentId == DeptId1.Text);
Store1.DataBind();
}
if (!string.IsNullOrEmpty(DeptId2.Text))
{
Store2.DataSource = routers.Items.Where(x => x.departmentId == DeptId2.Text);
Store2.DataBind();
}
if (!string.IsNullOrEmpty(DeptId3.Text))
{
Store3.DataSource = routers.Items.Where(x => x.departmentId == DeptId3.Text);
Store3.DataBind();
}
if (!string.IsNullOrEmpty(DeptId4.Text))
{
Store3.DataSource = routers.Items.Where(x => x.departmentId == DeptId4.Text);
Store4.DataBind();
}
if (!string.IsNullOrEmpty(DeptId5.Text))
{
Store5.DataSource = routers.Items.Where(x => x.departmentId == DeptId5.Text);
Store5.DataBind();
}
if (!string.IsNullOrEmpty(DeptId6.Text))
{
Store6.DataSource = routers.Items.Where(x => x.departmentId == DeptId6.Text);
Store6.DataBind();
}
}
public void FillWorkingCalendar()
{
ListRequest req = new ListRequest();
ListResponse <WorkingCalendar> response = _timeAttendanceService.ChildGetAll <WorkingCalendar>(req);
if (!response.Success)
{
Common.errorMessage(response);
Store3.DataSource = new List <Department>();
}
Store3.DataSource = response.Items;
Store3.DataBind();
}
protected void MyData_Refresh(object sender, StoreRefreshDataEventArgs e)
{
int PageSize = this.pagecut.PageSize;
int IndexSize = Convert.ToInt32(e.Parameters["start"]);
if (IndexSize == -1)
{
IndexSize = 0;
}
int pageIndex = IndexSize / PageSize + 1;
int recordCount = 0;
List <Soft> list = biService.GetSofts((SoftTypeOptions)Convert.ToInt32(SelectSoftType.SelectedItem.Value), txtsoftName.Text, pageIndex, PageSize, ref recordCount);
Store3.DataSource = list;
Store3.DataBind();
(Store3.Proxy[0] as PageProxy).Total = recordCount;
}
protected void RefreshData(object sender, StoreRefreshDataEventArgs e)
{
try
{
List <MathRule> tudien = new XMLProcess().GetAll(XDocument.Load(Server.MapPath(MathRuleXmlUrl)), true);
List <object> obj = new List <object>();
foreach (var item in tudien)
{
obj.Add(new { ColumnInDB = item.ColumnInDB, ColumnInSoftware = item.ColumnInSoftware, ColumnInExcel = item.ColumnInExcel, AllowBlank = item.AllowBlank, MathStatus = item.MathStatus, DataType = item.DataType });
}
Store3.DataSource = obj;
Store3.DataBind();
}
catch (Exception ex)
{
Dialog.ShowError(ex.Message.ToString());
}
}
private void dataBind()
{
//项目数据
var projectList = XMProjectService.GetXMProjectList();
Store2.DataSource = projectList;
Store2.DataBind();
//物流公司数据
var logisticsList = CodeService.GetCodeListInfoByCodeTypeID(244);
Store3.DataSource = logisticsList;
Store3.DataBind();
//发货点数据(发货仓)
var codeList = CodeService.GetCodeListInfoByCodeTypeID(188);
Store4.DataSource = codeList;
Store4.DataBind();
}
public void DisplayApprovals(string dayId, string employeeId, string shiftId, string code)
{
ReportGenericRequest req = new ReportGenericRequest();
req.paramString = "1|" + employeeId + "^2|" + dayId + "^3|" + dayId + "^5|" + code;
ListResponse <Time> resp = _timeAttendanceService.ChildGetAll <Time>(req);
if (!resp.Success)
{
Common.errorMessage(resp);
return;
}
timeCode = ConstTimeVariationType.TimeCodeList(_systemService);
resp.Items.ForEach(x =>
{
x.timeCodeString = timeCode.Where(y => y.key == Convert.ToInt16(x.timeCode)).Count() != 0 ? timeCode.Where(y => y.key == Convert.ToInt32(x.timeCode)).First().value : string.Empty;
x.statusString = FillApprovalStatus(x.status);
});
Store3.DataSource = resp.Items;
Store3.DataBind();
TimeApprovalWindow.Show();
}
public void Save_GW(object sender, EventArgs e)
{
DataClasses1DataContext contador = new DataClasses1DataContext();
TGateways tGateway = new TGateways();
try
{
tGateway.SerialNumber = (int)txtSerialGW.Number;
tGateway.Marca = txtMarcaGW.Text;
tGateway.Modelo = txtModeloGW.Text;
tGateway.IP = txtIPGW.Text;
tGateway.Puerto = txtPuertoGW.Text;
#region ADD ID VALUE
var query = (from c in contador.TGateways
select c);
List <TGateways> listaValores = query.ToList <TGateways>();
var maxID = 0;
if (listaValores.Count != 0)
{
maxID = listaValores.Max(x => x.Id);
tGateway.Id = maxID++;
tGateway.Id = maxID++;
}
else
{
maxID = 1;
}
#endregion
#region check Serial
var querydupli = (from c in contador.TGateways where c.SerialNumber == txtSerialGW.Number select c);
List <TGateways> listaValoresdupli = querydupli.ToList <TGateways>();
#endregion
if (listaValoresdupli.Count == 0)
{
var result = contador.GetTable <TGateways>(); // get table
result.InsertOnSubmit(tGateway);
contador.SubmitChanges();
// Response.Write("Saved Successfully...");
Store3.DataBind();
X.Msg.Notify("Line Saved Correctly At:", DateTime.Now.ToLongTimeString()).Show();
FormPanel3.Reset();
}
else
{
X.Msg.Notify("Error Saving", "Serial Number Already exists!").Show();
}
}
catch (Exception ex)
{
throw new Exception();
}
}
protected void ReloadData(object sender, DirectEventArgs e)
{
//Store1.DataBind();
Store3.DataBind();
}
private void PreviewDataBind()
{
int year = common.IntSafeConvert(CurrentYear);
DataTable dt1 = BG_PreviewDataLogic.GetPersonPart();
dt1.Columns.Add("rsold");
dt1.Columns.Add("rsnew");
dt1.Columns.Add("rjsold");
dt1.Columns.Add("rjsnew");
DataTable dt2 = BG_PreviewDataLogic.GetPublicPart();
dt2.Columns.Add("rsold");
dt2.Columns.Add("rsnew");
dt2.Columns.Add("rjsold");
dt2.Columns.Add("rjsnew");
DataTable dt3 = BG_PreviewDataLogic.GetCapitalPart();
dt3.Columns.Add("rsold");
dt3.Columns.Add("rsnew");
dt3.Columns.Add("rjsold");
dt3.Columns.Add("rjsnew");
for (int j = 0; j < dt1.Rows.Count; j++)
{
string pnumold = "";
string pnumnew = "";
DataTable dt = BG_SysSettingManager.GetAllBG_SysSetting();
if (dt.Rows.Count > 0)
{
pnumold = BG_SysSettingLogic.GetPerByYear(year - 1);
pnumnew = BG_SysSettingLogic.GetPerByYear(year);
hidbn1.Value = pnumnew;
}
else
{
pnumold = "0";
pnumnew = "0";
hidbn1.Value = pnumnew;
}
dt1.Rows[j]["rsold"] = pnumold;
dt1.Rows[j]["rsnew"] = pnumnew;
int Pepold = common.IntSafeConvert(pnumold);
int Pepnew = common.IntSafeConvert(pnumnew);
dt1.Rows[j]["rjsold"] = (Convert.ToDouble(dt1.Rows[j]["PDProjectLYData"]) / (Pepold * 1.0f)).ToString("f8").TrimEnd('0').TrimEnd('.');
dt1.Rows[j]["rjsnew"] = (Convert.ToDouble(dt1.Rows[j]["PDProjectData"]) / (Pepnew * 1.0f)).ToString("f8").TrimEnd('0').TrimEnd('.');
}
for (int k = 0; k < dt2.Rows.Count; k++)
{
string pnumold = ""; string pnumnew = "";
DataTable dt = BG_SysSettingManager.GetAllBG_SysSetting();
if (dt.Rows.Count > 0)
{
pnumold = BG_SysSettingLogic.GetPerByYear(year - 1);
pnumnew = BG_SysSettingLogic.GetPerByYear(year);
hidbn2.Value = pnumnew;
}
else
{
pnumold = "0";
pnumnew = "0";
hidbn2.Value = pnumnew;
}
dt2.Rows[k]["rsold"] = pnumold;
dt2.Rows[k]["rsnew"] = pnumnew;
int Pepold = common.IntSafeConvert(pnumold);
int Pepnew = common.IntSafeConvert(pnumnew);
dt2.Rows[k]["rjsold"] = (Convert.ToDouble(dt2.Rows[k]["PDProjectLYData"]) / (Pepold * 1.0f)).ToString("f8").TrimEnd('0').TrimEnd('.');
dt2.Rows[k]["rjsnew"] = (Convert.ToDouble(dt2.Rows[k]["PDProjectData"]) / (Pepnew * 1.0f)).ToString("f8").TrimEnd('0').TrimEnd('.');
}
for (int i = 0; i < dt3.Rows.Count; i++)
{
string pnumold = ""; string pnumnew = "";
DataTable dt = BG_SysSettingManager.GetAllBG_SysSetting();
if (dt.Rows.Count > 0)
{
pnumold = BG_SysSettingLogic.GetPerByYear(year - 1);
pnumnew = BG_SysSettingLogic.GetPerByYear(year);
hidbn3.Value = pnumnew;
}
else
{
pnumold = "0";
pnumnew = "0";
hidbn3.Value = pnumnew;
}
dt3.Rows[i]["rsold"] = pnumold;
dt3.Rows[i]["rsnew"] = pnumnew;
int Pepold = common.IntSafeConvert(pnumold);
int Pepnew = common.IntSafeConvert(pnumnew);
dt3.Rows[i]["rjsold"] = (Convert.ToDouble(dt3.Rows[i]["PDProjectLYData"]) / (Pepold * 1.0f)).ToString("f8").TrimEnd('0').TrimEnd('.');
dt3.Rows[i]["rjsnew"] = (Convert.ToDouble(dt3.Rows[i]["PDProjectData"]) / (Pepnew * 1.0f)).ToString("f8").TrimEnd('0').TrimEnd('.');
}
Store2.DataSource = Getquota(dt1, hidbn1.Value == null ? "" : hidbn1.Value.ToString());
Store2.DataBind();
Store3.DataSource = Getquota(dt2, hidbn2.Value == null ? "" : hidbn2.Value.ToString());
Store3.DataBind();
Store1.DataSource = Getquota(dt3, hidbn3.Value == null ? "" : hidbn3.Value.ToString());
Store1.DataBind();
}
private void PreviewDataBind()
{
DataTable dt = new DataTable();
dt.Columns.Add("PSName");
dt.Columns.Add("rjs1");
dt.Columns.Add("rjs2");
dt.Columns.Add("rjs3");
dt.Columns.Add("rjs4");
dt.Columns.Add("rjs5");
dt.Columns.Add("rjs6");
dt.Columns.Add("rjs7");
for (int i = 0; i < 5; i++)
{
dt.Rows.Add();
dt.Rows[i]["PSName"] = "";
dt.Rows[i]["rjs1"] = "";
dt.Rows[i]["rjs2"] = "";
dt.Rows[i]["rjs3"] = "";
dt.Rows[i]["rjs4"] = "";
dt.Rows[i]["rjs5"] = "";
dt.Rows[i]["rjs6"] = "";
dt.Rows[i]["rjs7"] = "";
}
Store1.DataSource = dt;
Store1.DataBind();
DataTable dt2 = new DataTable();
dt2.Columns.Add("PSName");
dt2.Columns.Add("rjs1");
dt2.Columns.Add("rjs2");
dt2.Columns.Add("rjs3");
dt2.Columns.Add("rjs4");
dt2.Columns.Add("rjs5");
dt2.Columns.Add("rjs6");
dt2.Columns.Add("rjs7");
dt2.Columns.Add("rjs8");
dt2.Columns.Add("rjs9");
for (int i = 0; i < 5; i++)
{
dt2.Rows.Add();
dt2.Rows[i]["PSName"] = "";
dt2.Rows[i]["rjs1"] = "";
dt2.Rows[i]["rjs2"] = "";
dt2.Rows[i]["rjs3"] = "";
dt2.Rows[i]["rjs4"] = "";
dt2.Rows[i]["rjs5"] = "";
dt2.Rows[i]["rjs6"] = "";
dt2.Rows[i]["rjs7"] = "";
dt2.Rows[i]["rjs8"] = "";
dt2.Rows[i]["rjs9"] = "";
}
Store2.DataSource = dt2;
Store2.DataBind();
DataTable dt3 = new DataTable();
dt3.Columns.Add("PSName");
dt3.Columns.Add("rjs1");
dt3.Columns.Add("rjs2");
dt3.Columns.Add("rjs3");
dt3.Columns.Add("rjs4");
dt3.Columns.Add("rjs5");
dt3.Columns.Add("rjs6");
dt3.Columns.Add("rjs7");
dt3.Columns.Add("rjs8");
dt3.Columns.Add("rjs9");
dt3.Columns.Add("rjs10");
dt3.Columns.Add("rjs11");
dt3.Columns.Add("rjs12");
dt3.Columns.Add("rjs13");
dt3.Columns.Add("rjs14");
for (int i = 0; i < 5; i++)
{
dt3.Rows.Add();
dt3.Rows[i]["PSName"] = "";
dt3.Rows[i]["rjs1"] = "";
dt3.Rows[i]["rjs2"] = "";
dt3.Rows[i]["rjs3"] = "";
dt3.Rows[i]["rjs4"] = "";
dt3.Rows[i]["rjs5"] = "";
dt3.Rows[i]["rjs6"] = "";
dt3.Rows[i]["rjs7"] = "";
dt3.Rows[i]["rjs8"] = "";
dt3.Rows[i]["rjs9"] = "";
dt3.Rows[i]["rjs10"] = "";
dt3.Rows[i]["rjs11"] = "";
dt3.Rows[i]["rjs12"] = "";
dt3.Rows[i]["rjs13"] = "";
dt3.Rows[i]["rjs14"] = "";
}
Store3.DataSource = dt3;
Store3.DataBind();
DataTable dt4 = BG_PayProjectManager.GetAllBG_PayProject();
dt4.Columns.Add("rjs1");
dt4.Columns.Add("rjs2");
dt4.Columns.Add("rjs3");
dt4.Columns.Add("rjs4");
dt4.Columns.Add("rjs5");
dt4.Columns.Add("rjs6");
dt4.Columns.Add("rjs7");
dt4.Columns.Add("rjs8");
dt4.Columns.Add("rjs9");
dt4.Columns.Add("rjs10");
dt4.Columns.Add("rjs11");
dt4.Columns.Add("rjs12");
dt4.Columns.Add("rjs13");
for (int i = 0; i < 5; i++)
{
dt4.Rows[i]["rjs1"] = "0";
dt4.Rows[i]["rjs2"] = "0";
dt4.Rows[i]["rjs3"] = "0";
dt4.Rows[i]["rjs4"] = "0";
dt4.Rows[i]["rjs5"] = "0";
dt4.Rows[i]["rjs6"] = "0";
dt4.Rows[i]["rjs7"] = "0";
dt4.Rows[i]["rjs8"] = "0";
dt4.Rows[i]["rjs9"] = "0";
dt4.Rows[i]["rjs10"] = "0";
dt4.Rows[i]["rjs11"] = "0";
dt4.Rows[i]["rjs12"] = "0";
dt4.Rows[i]["rjs13"] = "0";
}
Store4.DataSource = dt4;
Store4.DataBind();
}
private void SearchLoad()//查询窗口初始化
{
//初始化日期
df_begin.SelectedDate = System.DateTime.Today;
df_end.SelectedDate = System.DateTime.Today;
//df_begin.SelectedDate = System.DateTime.Today;//.AddDays(-1);
//df_end.SelectedDate = System.DateTime.Today;
#region 初始化职务
var pos = from p in dc.Position
from per in dc.Person
where p.Posid == per.Posid && per.Maindeptid == SessionBox.GetUserSession().DeptNumber
select new
{
p.Posid,
p.Posname
};
Store3.DataSource = pos;
Store3.DataBind();
#endregion
#region 初始化部门
//var dep = from d in dc.Department
// where d.Fatherid == SessionBox.GetUserSession().DeptNumber
// select new
// {
// d.Deptname,
// Deptid = d.Deptnumber
// };
//DeptStore.DataSource = dep;
//DeptStore.DataBind();
var dep = from d in dc.Department
from p in dc.Person
where d.Deptnumber == p.Areadeptid && p.Maindeptid == SessionBox.GetUserSession().DeptNumber
select new
{
d.Deptname,
Deptid = d.Deptnumber
};
DeptStore.DataSource = dep;
DeptStore.DataBind();
#endregion
#region 初始化单位
if (SessionBox.GetUserSession().rolelevel.Trim().IndexOf("1") > -1)
{
var dept = from d in dc.Department
where d.Deptnumber.Substring(4) == "00000" && d.Deptname.EndsWith("矿")
select new
{
d.Deptname,
Deptid = d.Deptnumber
};
UnitStore.DataSource = dept;
UnitStore.DataBind();
cbbUnit.Disabled = false;
cbb_position.Disabled = true;
cbb_person.Disabled = true;
cbb_part.Disabled = true;
cbb_status.Disabled = true;
}
else
{
var dept = from d in dc.Department
where d.Deptnumber == SessionBox.GetUserSession().DeptNumber
select new
{
d.Deptname,
Deptid = d.Deptnumber
};
UnitStore.DataSource = dept;
UnitStore.DataBind();
cbbUnit.SelectedItem.Value = SessionBox.GetUserSession().DeptNumber;
cbbUnit.Disabled = true;
}
#endregion
//#region 初始化级别
//var lavel = from l in dc.Yinhuanlevel
// select new
// {
// l.YHLevelID,
// l.YHLevel
// };
//LevelStore.DataSource = lavel;
//LevelStore.DataBind();
//#endregion
#region 初始化类型
int zyID = int.Parse(PublicMethod.ReadXmlReturnNode("ZY", this));
var type = from t in dc.CsBaseinfoset
where t.Fid == zyID
select new
{
YHTypeID = t.Infoid,
YHType = t.Infoname
};
TypeStore.DataSource = type;
TypeStore.DataBind();
#endregion
#region 初始化状态
StatusStore.DataBind();
#endregion
}
static void Main(string[] args)
{
PizzaStore Tienda = new NyStylePizzaStore();
List <string> MenuD = new List <string>();
foreach (StoreType Store in (StoreType[])Enum.GetValues(typeof(StoreType)))
{
MenuD.Add(Store.ToString());
}
//Agregando la opcion Salir
MenuD.Add("Salir");
while (true)
{
//cargar el menu de pizza store
string Store = Menu.MultipleChoice(true, MenuD, "Selecciona una Pizza Store");
//guardar la variable de tipo StoreType
StoreType resultado = StoreType.ChicagoStylePizzaStore; //valor por defecto
if (Store == "Salir") //Salida del programa
{
break;
}
//Compararla con el texto retornado para obtener otravez el objeto
foreach (StoreType Store2 in (StoreType[])Enum.GetValues(typeof(StoreType)))
{
if (Store == Store2.ToString())
{
resultado = Store2;
}
}
//instanciando la pizza store seleccionada
switch (resultado)
{
case StoreType.ChicagoStylePizzaStore:
Tienda = new ChicagoStylePizzaStore();
break;
case StoreType.NewYorkStylePizzaStore:
Tienda = new NyStylePizzaStore();
break;
}
while (true)
{
List <string> MenuP = new List <string>();
foreach (PizzaType Store3 in (PizzaType[])Enum.GetValues(typeof(PizzaType)))
{
MenuP.Add(Store3.ToString());
}
MenuP.Add("Salir");
string Seleccion = Menu.MultipleChoice(true, MenuP, "Selecciona un tipo de pizza");
PizzaType Seleccionp = PizzaType.Cheese;
if (Seleccion == "Salir")//Salida de la tienda
{
break;
}
foreach (PizzaType Store2 in (PizzaType[])Enum.GetValues(typeof(PizzaType)))
{
if (Seleccion == Store2.ToString())
{
Seleccionp = Store2;
}
}
Pizza pizza = Tienda.CreatePizza(Seleccionp);
Console.WriteLine($"Se a Ordenado una {pizza.Name}\n");
pizza.Prepare();
Console.ReadKey();
}
}
}
