// GET: Car2/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Store2 store2 = db.Store2.Find(id);
if (store2 == null)
{
return(HttpNotFound());
}
return(View(store2));
}
protected void Page_Load(object sender, EventArgs e)
{
loginService.HaveUrlRight();
if (!X.IsAjaxRequest)
{
if (!Page.IsPostBack)
{
var platArray = new MobileOption[] { MobileOption.iPhone, MobileOption.Android, MobileOption.IPAD }.Select(p => new { PlatID = (int)p, PlatName = p.GetDescription() }).ToList();
Store2.DataSource = platArray;
Store2.DataBind();
comboxPlats.SelectedItem.Value = platArray[0].PlatID.ToString();
isSearch.Text = "1";
}
}
}
protected void Store2_ReadData(object sender, StoreReadDataEventArgs e)
{
TemplateBodyListReuqest req = new TemplateBodyListReuqest();
req.TemplateId = Convert.ToInt32(recordId.Text);
ListResponse <TemplateBody> bodies = _administrationService.ChildGetAll <TemplateBody>(req);
if (!bodies.Success)
{
X.MessageBox.ButtonText.Ok = Resources.Common.Ok;
Common.errorMessage(bodies);
return;
}
this.Store2.DataSource = bodies.Items;
Store2.DataBind();
}
public async Task Retrying_Write_After_a_DuplicateStreamIndexException_Should_Work()
{
// Repo1 writes to the stream (no index specified)
await Store.AppendAsync("test", 1).ConfigureAwait(false);
// Repo2 writes to the same stream (no index specified)
var ex = await Assert.ThrowsAnyAsync <DuplicateStreamIndexException>(() =>
Store2.AppendAsync("test", 2)
).ConfigureAwait(false);
Assert.Equal("Duplicated index 1 on stream test", ex.Message);
Assert.Equal("test", ex.StreamId);
Assert.Equal(1, ex.StreamIndex);
// Repo2 retries to write the same chunk again
await Store2.AppendAsync("test", 2).ConfigureAwait(false);
}
public void TbuRadioTwoClick()
{
try
{
this.RadioOne.Checked = false;
this.RadioTwo.Checked = true;
string checkTimes = "2";
string userid = Session["user_id"] as string;
Store1.DataSource = tgsPproperty.GetUserStationInfo(userid, checkTimes);
Store1.DataBind();
Store2.DataSource = tgsPproperty.GetNoUserStationInfo(checkTimes);
Store2.DataBind();
}
catch (Exception ex)
{
ILog.WriteErrorLog(ex);
logManager.InsertLogError("TmsUserLocation.aspx-TbuRadioTwoClick", ex.Message + "；" + ex.StackTrace, "TbuRadioTwoClick has an exception");
}
}
private void AddDataBind()
{
int year = Convert.ToInt32(HidYear.Value);
int depid = Convert.ToInt32(HidDepid.Value);
DataTable dt = BG_BudItemsLogic.GetBEA(depid, year);
dt.Columns.Add("Name");
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
int piid = (int)dt.Rows[i]["PIID"];
BG_PayIncome pi = BG_PayIncomeManager.GetBG_PayIncomeByPIID(piid);
dt.Rows[i]["Name"] = pi.PIEcoSubName;
}
}
Store2.DataSource = dt;
Store2.DataBind();
}
public async Task Verify_that_index_is_always_equal_to_id_when_Append_chunk_without_explicit_index()
{
// Repo1 writes to a stream (no index specified)
await Store.AppendAsync("test1", -1, "CHUNK1").ConfigureAwait(false);
// Repo2 writes to another stream.
await Store2.AppendAsync("test2", -1, "Stuff not interesting").ConfigureAwait(false);
// Repo1 write again on Test1, but in memory index is wrong. WE expect index to be ok
await Store.AppendAsync("test1", -1, "CHUNK2").ConfigureAwait(false);
Recorder rec = new Recorder();
await Store.ReadForwardAsync("test1", rec).ConfigureAwait(false);
foreach (var chunk in rec.Chunks)
{
Assert.Equal(chunk.Position, chunk.Index);
}
}
public void ButQueryClick()
{
if (string.IsNullOrEmpty(kakou.Value) && string.IsNullOrEmpty(cbocllx.Text))
{
DateTime start = Convert.ToDateTime(startdate);
DateTime end = Convert.ToDateTime(enddate);
TimeSpan sp = end.Subtract(start);
if (sp.TotalMinutes > 120)
{
Notice("信息提示", "只能选择两个小时之内的时间！");
this.lblCurpage.Text = "1";
this.lblAllpage.Text = "0";
this.lblRealcount.Text = "0";
totalpage.Value = "0";
ButNext.Disabled = true;
ButLast.Disabled = true;
Store2.DataSource = new DataTable();
Store2.DataBind();
return;
}
}
if (!string.IsNullOrEmpty(kakou.Value))
{
if (kakou.Value.Contains(","))
{
string[] strs = kakou.Value.Split(',');
if (strs.Length > 10)
{
Notice("信息提示", "最多只能选择10个卡口！");
this.lblCurpage.Text = "1";
this.lblAllpage.Text = "0";
this.lblRealcount.Text = "0";
ButNext.Disabled = true;
ButLast.Disabled = true;
Store2.DataSource = new DataTable();
Store2.DataBind();
return;
}
}
}
curpage.Value = 1;
Query(1);
}
private void PlanPlaceStoreLoad(Decimal dt)
{
var detail = from pp in dc.YPlanplace
from p in dc.Place
where pp.Placeid == p.Placeid && pp.Ctid == dt
orderby pp.Moveorder
select new
{
pp.Recordtime,
pp.Placeid,
pp.Moveorder,
p.Placename,
pp.Id,
pp.Ctid
};
Store2.DataSource = detail;
Store2.DataBind();
btnPlaceDel.Disabled = true;
}
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 async Task Verify_that_index_is_always_equal_to_id_when_Append_chunk_without_explicit_index()
{
// Repo1 writes to a stream (no index specified)
await Store.AppendAsync("test1", -1, "CHUNK1").ConfigureAwait(false);
// Repo2 writes to another stream.
await Store2.AppendAsync("test2", -1, "Stuff not interesting").ConfigureAwait(false);
await Store2.AppendAsync("test1", -1, "CHUNK2").ConfigureAwait(false);
// Repo1 write again on Test1, but in memory index is wrong. WE expect index to be ok
await Store.AppendAsync("test1", -1, "CHUNK3").ConfigureAwait(false);
Recorder rec = new Recorder();
await Store.ReadBackwardAsync("test1", long.MaxValue, rec).ConfigureAwait(false);
Assert.Equal("CHUNK3", rec.Data.ElementAt(0));
Assert.Equal("CHUNK2", rec.Data.ElementAt(1));
Assert.Equal("CHUNK1", rec.Data.ElementAt(2));
}
public void DeleteBody(string te, string language)
{
try
{
//Step 1 Code to delete the object from the database
TemplateBody s = new TemplateBody();
s.teId = Convert.ToInt32(te);
s.languageId = Convert.ToInt32(language);
//s.intName = "";
PostRequest <TemplateBody> req = new PostRequest <TemplateBody>();
req.entity = s;
PostResponse <TemplateBody> r = _administrationService.ChildDelete <TemplateBody>(req);
if (!r.Success)
{
X.MessageBox.ButtonText.Ok = Resources.Common.Ok;
Common.errorMessage(r);;
return;
}
else
{
//Step 2 : remove the object from the store
Store2.Remove(language);
//Step 3 : Showing a notification for the user
Notification.Show(new NotificationConfig
{
Title = Resources.Common.Notification,
Icon = Icon.Information,
Html = Resources.Common.RecordDeletedSucc
});
}
}
catch (Exception ex)
{
//In case of error, showing a message box to the user
X.MessageBox.ButtonText.Ok = Resources.Common.Ok;
X.Msg.Alert(Resources.Common.Error, Resources.Common.ErrorDeletingRecord).Show();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!X.IsAjaxRequest && !IsPostBack)
{
SetExtLanguage();
HideShowButtons();
HideShowColumns();
Store2.Reload();
FillExpressionStore();
try
{
AccessControlApplier.ApplyAccessControlOnPage(typeof(EntitlementDeduction), BasicInfoTab, GridPanel1, btnAdd, SaveButton);
}
catch (AccessDeniedException exp)
{
X.MessageBox.ButtonText.Ok = Resources.Common.Ok;
X.Msg.Alert(Resources.Common.Error, Resources.Common.ErrorAccessDenied).Show();
Viewport1.Hidden = true;
return;
}
}
}
private void LoadValue()
{
if (Request["sheetNo"] != null)
{
hidsheetNo.Text = Request["sheetNo"];
}
if (Request["mbl"] != null)
{
hidmbl.Text = Request["mbl"];
}
if (Request["status"] != null)
{
hidstatus.Text = Request["status"];
}
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_Print_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "PrintList")
.Append("prt_STAT", FSecurityHelper.CurrentUserDataGET()[12]).Append("prt_ReportCode", "Verify").Append("prt_sys", "")
}).GetList();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Store2.DataSource = ds.Tables[0];
Store2.DataBind();
}
if (ds != null && ds.Tables[1].Rows.Count > 0)
{
CmbPrint.SelectedItem.Value = ds.Tables[1].Rows[0][0].ToString();
}
if (ds != null && ds.Tables[2].Rows.Count > 0)
{
hidtop.Text = ds.Tables[2].Rows[0][0].ToString();
hidbottom.Text = ds.Tables[2].Rows[0][1].ToString();
hidleft.Text = ds.Tables[2].Rows[0][2].ToString();
hidright.Text = ds.Tables[2].Rows[0][3].ToString();
}
}
protected void loadgrid1(object sender, DirectEventArgs e)
{
DataTable dt = new DataTable();
dt.Columns.Add("Name");
for (int i = 0; i < 6; i++)
{
DataRow dr = dt.NewRow();
dr[0] = "a" + i.ToString();
dt.Rows.Add(dr);
}
Store2.DataSource = dt;
Store2.DataBind();
//Ext.Net.Button btn = new Ext.Net.Button();
//btn.X = 560; btn.Y = 40; btn.Width = 70; btn.ID = "new_btn"; btn.Text = "new";
//this.Panel3.Items.Add(btn);
//btn.Render();
//var button = new Ext.Net.Button
//{
// ID = "buttomdi",
// Text = "Button",
// X = 560,
// Y = 40,
// Width = 70
//};
//Panel3.Items.Add(button);
//button.Render();
//Ext.Net.MenuItem mi1 = new Ext.Net.MenuItem("New item 1");
//Ext.Net.MenuItem mi2 = new Ext.Net.MenuItem("New item 2");
//this.Menu1.Items.Add(mi1);
//mi1.Render();
//this.Menu1.Items.Add(mi2);
//mi2.Render();
}
/// <summary>
/// 加载传入用户的审核地点
/// </summary>
/// <param name="userid"></param>
/// <param name="shjb"></param>
private void GetData(string userid, string shjb)
{
try
{
Session["user_id"] = userid;
DataTable dt1 = tgsPproperty.GetUserStationInfo(userid, shjb);
if (dt1 != null)
{
Store1.DataSource = dt1;
Store1.DataBind();
}
DataTable dt2 = tgsPproperty.GetNoUserStationInfo(shjb);
if (dt2 != null)
{
Store2.DataSource = dt2;
Store2.DataBind();
}
}
catch (Exception ex)
{
ILog.WriteErrorLog(ex);
logManager.InsertLogError("TmsUserLocation.aspx-GetData", ex.Message + "；" + ex.StackTrace, "GetData has an exception");
}
}
public void Save_Contador_EM(object sender, EventArgs e)
{
DataClasses1DataContext contador = new DataClasses1DataContext();
TContadoresLuz tcounter = new TContadoresLuz();
try
{
tcounter.SerialNumber = (int)txtSerialEM.Number;
tcounter.Marca = txtMarcaEM.Text;
tcounter.Modelo = txtModeloEM.Text;
#region ADD ID VALUE
var query = (from c in contador.TContadoresLuz
select c);
List <TContadoresLuz> listaValores = query.ToList <TContadoresLuz>();
var maxID = 0;
if (listaValores.Count != 0)
{
maxID = listaValores.Max(x => x.Id);
tcounter.Id = maxID++;
tcounter.Id = maxID++;
}
else
{
maxID = 1;
}
#endregion
#region check Serial
var querydupli = (from c in contador.TContadoresLuz where c.SerialNumber == txtSerial.Number select c);
List <TContadoresLuz> listaValoresdupli = querydupli.ToList <TContadoresLuz>();
#endregion
if (listaValoresdupli.Count == 0)
{
var result = contador.GetTable <TContadoresLuz>(); // get table
result.InsertOnSubmit(tcounter);
contador.SubmitChanges();
// Response.Write("Saved Successfully...");
Store2.DataBind();
X.Msg.Notify("Line Saved Correctly At:", DateTime.Now.ToLongTimeString()).Show();
FormPanel2.Reset();
}
else
{
X.Msg.Notify("Error Saving", "Serial Number Already exists!").Show();
}
}
catch (Exception ex)
{
throw new Exception();
}
}
private void LoadValue()
{
hdraft = "";
if (!string.IsNullOrEmpty(Request.QueryString["type"]))
{
hidtype.Text = Request.QueryString["type"];
}
if (!string.IsNullOrEmpty(Request.QueryString["ID"]))
{
hidID.Text = Request.QueryString["ID"];
}
if (Request["HType"] != null)
{
hdraft = Request.QueryString["HType"];
lbltishi.Hide();
btnPrint.Show();
btnDraft.Show();
btnACI.Show();
if (!string.IsNullOrEmpty(Request.QueryString["HAttach"]))
{
if (Request["HAttach"] == "1")
{
btnAttachList.Show();
}
else
{
btnAttachList.Hide();
}
}
}
else
{
btnPrint.Hide();
btnDraft.Hide();
btnACI.Hide();
btnAttachList.Hide();
}
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_Print_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "PrintList")
.Append("prt_STAT", FSecurityHelper.CurrentUserDataGET()[12]).Append("prt_ReportCode", Request.QueryString["type"]).Append("prt_sys", "OE")
}).GetList();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Store2.DataSource = ds.Tables[0];
Store2.DataBind();
}
if (ds != null && ds.Tables[1].Rows.Count > 0)
{
CmbPrint.SelectedItem.Value = ds.Tables[1].Rows[0][0].ToString();
}
if (ds != null && ds.Tables[2].Rows.Count > 0)
{
hidtop.Text = ds.Tables[2].Rows[0][0].ToString();
hidbottom.Text = ds.Tables[2].Rows[0][1].ToString();
hidleft.Text = ds.Tables[2].Rows[0][2].ToString();
hidright.Text = ds.Tables[2].Rows[0][3].ToString();
}
if (ds != null && ds.Tables.Count > 3)
{
storeCopies.DataSource = ds.Tables[3];
storeCopies.DataBind();
}
if (ds != null && ds.Tables.Count > 4)
{
if (ds.Tables[4].Rows.Count > 0)
{
cmbPrintCount.SelectedItem.Value = ds.Tables[4].Rows[0][0].ToString();
}
}
if (hidtype.Text.ToUpper() == "INVOICE")
{
DataSet ckDs = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirImport_Invoice_SP", new List <IFields>()
{
dal.CreateIFields().
Append("Option", "CheckDetailData").
Append("inv_seed", hidID.Text)
}).GetList();
if (ckDs.Tables[0].Rows[0][0].ToString() == "N")
{
LinBtnPDF.Visible = false;
LinBtnPrint.Visible = false;
}
else
{
LinBtnPDF.Visible = true;
LinBtnPrint.Visible = true;
}
}
}
private void LoadValue()
{
if (Request["Sys"] != null)
{
hidsys.Text = Request["Sys"];
}
if (Request["type"] != null)
{
hidtype.Text = Request["type"];
}
if (Request["ID"] != null)
{
hidID.Text = Request["ID"];
}
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_Print_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "PrintList")
.Append("prt_STAT", FSecurityHelper.CurrentUserDataGET()[12]).Append("prt_ReportCode", hidtype.Text).Append("prt_sys", hidsys.Text)
}).GetList();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Store2.DataSource = ds.Tables[0];
Store2.DataBind();
}
if (ds != null && ds.Tables[1].Rows.Count > 0)
{
CmbPrint.SelectedItem.Value = ds.Tables[1].Rows[0][0].ToString();
}
if (ds != null && ds.Tables[2].Rows.Count > 0)
{
hidtop.Text = ds.Tables[2].Rows[0][0].ToString();
hidbottom.Text = ds.Tables[2].Rows[0][1].ToString();
hidleft.Text = ds.Tables[2].Rows[0][2].ToString();
hidright.Text = ds.Tables[2].Rows[0][3].ToString();
}
if (ds != null && ds.Tables[3].Rows.Count > 0)
{
storeCopies.DataSource = ds.Tables[3];
storeCopies.DataBind();
}
if (ds != null && ds.Tables.Count > 4)
{
if (ds.Tables[4].Rows.Count > 0)
{
cmbPrintCount.SelectedItem.Value = ds.Tables[4].Rows[0][0].ToString();
}
}
if (hidtype.Text.ToUpper() == "INVOICE")
{
DataSet ckDs = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirImport_Invoice_SP", new List <IFields>()
{
dal.CreateIFields().
Append("Option", "CheckDetailData").
Append("inv_seed", hidID.Text)
}).GetList();
if (ckDs.Tables[0].Rows[0][0].ToString() == "N")
{
LinBtnPDF.Disabled = true;
LinBtnPrint.Disabled = true;
}
else
{
LinBtnPDF.Disabled = false;
LinBtnPrint.Disabled = false;
}
DataSet dsInv = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_AirImport_Invoice_SP", new List <IFields>()
{
dal.CreateIFields().
Append("Option", "CheckInvoiceNo").
Append("inv_seed", hidID.Text)
}).GetList();
showBtnDraft.Visible = true;
if (dsInv.Tables[0].Rows[0][0].ToString() == "Y")
{
chkFlagDraft.Checked = false;
chkFlagDraft.Disabled = true;
btnInvDraft.Disabled = true;
}
}
}
private void DecodeURL()
{
if (Request["Sys"] != null)
{
sys = Request["Sys"];
}
if (Request["From"] != null)
{
from = Server.UrlDecode(Request["From"]);
if (from == "")
{
from = "1900/01/01";
}
else
{
from = (string)ControlBinder.getDate(from);
}
}
if (Request["To"] != null)
{
to = Server.UrlDecode(Request["To"]);
if (to == "")
{
to = "2100/01/01";
}
else
{
to = (string)ControlBinder.getDate(to);
}
}
if (Request["Dest"] != null)
{
dest = Server.UrlDecode(Request["Dest"]);
}
if (Request["Sales"] != null)
{
sales = Server.UrlDecode(Request["Sales"]);
}
if (Request["Shipper"] != null)
{
shipper = Server.UrlDecode(Request["Shipper"]);
}
if (Request["Consignee"] != null)
{
consignee = Server.UrlDecode(Request["Consignee"]);
}
if (Request["JobNo"] != null)
{
JobNo = Server.UrlDecode(Request["JobNo"]);
}
if (Request["MBL"] != null)
{
MBL = Server.UrlDecode(Request["MBL"]);
}
if (Request["HBL"] != null)
{
HBL = Server.UrlDecode(Request["HBL"]);
}
if (Request["Container"] != null)
{
Container = Server.UrlDecode(Request["Container"]);
}
if (Request["Vessel"] != null)
{
Vessel = Server.UrlDecode(Request["Vessel"]);
}
if (Request["Voyage"] != null)
{
Voyage = Server.UrlDecode(Request["Voyage"]);
}
if (Request["Coloader"] != null)
{
coloader = Server.UrlDecode(Request["Coloader"]);
}
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_Print_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "PrintList")
.Append("prt_STAT", FSecurityHelper.CurrentUserDataGET()[12]).Append("prt_ReportCode", "JobReference").Append("prt_sys", sys)
}).GetList();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Store2.DataSource = ds.Tables[0];
Store2.DataBind();
}
if (ds != null && ds.Tables[1].Rows.Count > 0)
{
CmbPrint.SelectedItem.Value = ds.Tables[1].Rows[0][0].ToString();
}
if (ds != null && ds.Tables[2].Rows.Count > 0)
{
hidtop.Text = ds.Tables[2].Rows[0][0].ToString();
hidbottom.Text = ds.Tables[2].Rows[0][1].ToString();
hidleft.Text = ds.Tables[2].Rows[0][2].ToString();
hidright.Text = ds.Tables[2].Rows[0][3].ToString();
}
if (ds != null && ds.Tables[3].Rows.Count > 0)
{
storeCopies.DataSource = ds.Tables[3];
storeCopies.DataBind();
}
if (ds != null && ds.Tables.Count > 4)
{
if (ds.Tables[4].Rows.Count > 0)
{
cmbPrintCount.SelectedItem.Value = ds.Tables[4].Rows[0][0].ToString();
}
}
}
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();
}
}
}
private void InsertData()
{
#region chuẩn bị
//if (ruleList == null)
ruleList = new XMLProcess().GetAll(XDocument.Load(Server.MapPath(MathRuleXmlUrl)));
string sql = "insert into " + this.TableName + "({0}) values";
string strUpdate = "update " + this.TableName + " set {0} where {1}";
string col = "";
List <MathRule> mr = new List <MathRule>();
//Lấy ra các cột cần insert
foreach (var item in RowSelectionModel1.SelectedRows)
{
col += "[" + item.RecordID + "],";
MathRule mathRule = ruleList.Where(t => t.ColumnInDB == item.RecordID).FirstOrDefault();
if (mathRule != null && mathRule.ColumnInExcel != "")
{
mr.Add(new MathRule()
{
ColumnInDB = item.RecordID,
ColumnInExcel = mathRule.ColumnInExcel,
DataType = mathRule.DataType,
AllowBlank = mathRule.AllowBlank,
DisplayOnGrid = mathRule.DisplayOnGrid,
DefaultValue = mathRule.DefaultValue
});
}
}
//col += "[MA_DONVI],";
if (col.LastIndexOf(",") != -1)
{
sql = string.Format(sql, col.Remove(col.LastIndexOf(",")));
}
string ExcelFileName = Server.MapPath(ExcelStoreFolder + "/") + fUpload.FileName;
//Lấy các cột trong file Excel
IEnumerable <string> ColumnInExcelFile = ExcelEngine.GetInstance().GetColumnName(ExcelFileName, cbSheetName.SelectedItem.Value);
int completedRows = 0, updatedRows = 0;
int errorLine = 1;
List <object> errorData = new List <object>();
#endregion
List <Row> dataExcel = null;
dataExcel = ExcelEngine.GetInstance().GetDataFromExcel(ExcelFileName, cbSheetName.SelectedItem.Value, 0, MaxRecord);
#region lấy dữ liệu và insert
foreach (var row in dataExcel)
{
bool isExist = false; // đã tồn tại mã cán bộ hay chưa
if (string.IsNullOrEmpty(row[0]))
{
break;
}
// lấy Trường mã cán bộ trong file Excel
MathRule mr1 = ruleList.Where(t => t.ColumnInDB == "MA_CB").FirstOrDefault();
DAL.HOSO hs = new HoSoController().GetByMaCB(row[mr1.ColumnInExcel]);
if (hs != null)
{
isExist = true;
}
string v = "", u = "";
foreach (MathRule rule in mr)
{
// bỏ qua prkey tự tăng
if (rule.ColumnInDB.Equals("PR_KEY"))
{
continue;
}
if (rule.DisplayOnGrid == false && string.IsNullOrEmpty(rule.DefaultValue) == false)
{
if (isExist == true)
{
if (rd_CapNhatBanGhiTonTai.Checked == true)
{
u += "[" + rule.ColumnInDB + "] = N'" + GetDefaultValue(rule.DefaultValue) + "',";
}
}
else
{
v += "N'" + GetDefaultValue(rule.DefaultValue) + "',";
}
continue;
}
if (rule.ColumnInExcel.Contains(";") == false)
{
string vTmp = row[rule.ColumnInExcel].ToString();
if (string.IsNullOrEmpty(vTmp))
{
vTmp = GetDefaultValue(rule.DefaultValue);
}
vTmp = GetCastedData(rule.DataType.ToLower(), vTmp);
if (vTmp == "$$$")
{
errorData.Add(new
{
Data = row[rule.ColumnInExcel].ToString(),
ErrorMessage = "Dữ liệu tại cột \"" + rule.ColumnInExcel + "\" dòng " + (errorLine + 1) + " trong tệp tin excel chưa tồn tại trong danh mục.",
LineInExcel = errorLine,
});
continue;
}
if (isExist == true)
{
if (rd_CapNhatBanGhiTonTai.Checked == true)
{
u += "[" + rule.ColumnInDB + "] = N'" + vTmp + "',";
}
}
else
{
v += "N'" + vTmp + "',";
}
}
else
{
string[] tmp = rule.ColumnInExcel.Split(';');
foreach (var item in tmp)
{
if (string.IsNullOrEmpty(item) == false && ColumnInExcelFile.Contains(item))
{
if (string.IsNullOrEmpty(row[item].ToString()))
{
if (isExist == true)
{
if (rd_CapNhatBanGhiTonTai.Checked == true)
{
u += "[" + rule.ColumnInDB + "] = N'" + GetDefaultValue(rule.DefaultValue) + "',";
}
}
else
{
v += "N'" + GetDefaultValue(rule.DefaultValue) + "',";
}
}
else
{
string tmp1 = GetCastedData(rule.DataType.ToLower(), row[item]);
if (tmp1 == "$$$")
{
errorData.Add(new
{
Data = row[item].ToString(),
ErrorMessage = "Dữ liệu tại cột \"" + rule.ColumnInExcel + "\" dòng " + (errorLine + 1) + " trong tệp tin excel chưa tồn tại trong danh mục.",
LineInExcel = errorLine,
});
continue;
}
if (isExist == true)
{
if (rd_CapNhatBanGhiTonTai.Checked == true)
{
u += "[" + rule.ColumnInDB + "] = N'" + tmp1 + "',";
}
}
else
{
v += "N'" + tmp1 + "',";
}
}
break;
}
else
{
//v += "N'',";
}
}
}
}
//v += "N'" + Session["MaDonVi"] + "',";
errorLine++;
try
{
// insert
string query = string.Empty;
if (v != "")
{
if (v.LastIndexOf(",") != -1)
{
query = sql + "(" + v.Remove(v.LastIndexOf(",")) + ")";
}
DataHandler.GetInstance().ExecuteNonQuery(query);
completedRows++;
}
// update
if (u != "")
{
string queryUpdate = string.Empty;
if (u.LastIndexOf(",") != -1)
{
queryUpdate = string.Format(strUpdate, u.Remove(u.LastIndexOf(",")), " MA_CB = N'" + row[mr1.ColumnInExcel] + "'");
}
DataHandler.GetInstance().ExecuteNonQuery(queryUpdate);
updatedRows++;
}
}
catch (Exception ex)
{
string Er = string.Empty;
if (ex.Message.Contains("Cannot insert duplicate key in object"))
{
Er = GlobalResourceManager.GetInstance().GetErrorMessageValue("DuplicateKey");
}
else if (ex.Message.Contains("Error converting data type nvarchar to numeric."))
{
Er = GlobalResourceManager.GetInstance().GetErrorMessageValue("NvarcharToNumeric");
}
else if (ex.Message.Contains("Conversion failed when converting date and/or time from character string."))
{
Er = GlobalResourceManager.GetInstance().GetErrorMessageValue("DateFromString");
}
else
{
Er = ex.Message;
}
errorData.Add(new
{
Data = v.Replace("N", "").Replace("'", ""),
ErrorMessage = Er,
LineInExcel = errorLine,
});
}
}
#endregion
// delete file
FileInfo file = new FileInfo(ExcelFileName);
if (file.Exists)
{
file.Delete();
}
#region thông báo kết quả insert
lblCompletedRow.Html = "<span style='color:#15428B;font-weight:bold;display:block;margin-bottom:6px;'>Tổng số dòng được thêm thành công : " + completedRows + " dòng</span>";
if (updatedRows > 0)
{
lblUpdatedRow.Html = "<span style='color:#15428B;font-weight:bold;display:block;margin-bottom:6px;'>Tổng số dòng được cập nhật thành công : " + updatedRows + " dòng</span>";
}
else
{
lblUpdatedRow.Html = "";
}
// lblError.Text = "Tổng số dòng bị lỗi : " + errorData.Count();
grp_ErrorRows.Title = "Tổng số dòng bị lỗi : " + errorData.Count() + " dòng";
Store2.DataSource = errorData;
Store2.DataBind();
#endregion
}
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();
}
public void DBB()
{
string TTstation = "";
string TTyears = "";
if (DLStation.Value == null && Session["TTstation"] != null)
{
TTstation = Session["TTstation"].ToString();
TTyears = Session["TTyears"].ToString();
}
if (DLStation.Value != null)
{
TTstation = DLStation.Value.ToString();
TTyears = DLYears.Value.ToString();
Session["TTstation"] = DLStation.Value.ToString();
Session["TTyears"] = DLYears.Value.ToString();
}
if (DLStation.Value == null && Session["TTstation"] != null)
{
DLStation.Value = TTstation;
DLYears.Value = TTyears;
}
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("sort", typeof(string)));
dt.Columns.Add(new DataColumn("my", typeof(string)));
dt.Columns.Add(new DataColumn("main", typeof(string)));
dt.Columns.Add(new DataColumn("code", typeof(string)));
dt.Columns.Add(new DataColumn("des", typeof(string)));
dt.Columns.Add(new DataColumn("m1", typeof(string)));
dt.Columns.Add(new DataColumn("m2", typeof(string)));
dt.Columns.Add(new DataColumn("m3", typeof(string)));
dt.Columns.Add(new DataColumn("m4", typeof(string)));
dt.Columns.Add(new DataColumn("m5", typeof(string)));
dt.Columns.Add(new DataColumn("m6", typeof(string)));
dt.Columns.Add(new DataColumn("m7", typeof(string)));
dt.Columns.Add(new DataColumn("m8", typeof(string)));
dt.Columns.Add(new DataColumn("m9", typeof(string)));
dt.Columns.Add(new DataColumn("m10", typeof(string)));
dt.Columns.Add(new DataColumn("m11", typeof(string)));
dt.Columns.Add(new DataColumn("m12", typeof(string)));
dt.Columns.Add(new DataColumn("tt", typeof(string)));
dt.Columns.Add(new DataColumn("Type", typeof(string)));
dt.Columns.Add(new DataColumn("id", typeof(string)));
DataSet ds = dbs.GetSqlDataSet("select *,(m1+m2+m3+m4+m5+m6+m7+m8+m9+m10+m11+m12) as TT from BudgetMain where station='" + TTstation + "' AND YEARS='" + TTyears + "'");
int k = 0;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string main = ds.Tables[0].Rows[i]["AccountCode"].ToString() + "/" + ds.Tables[0].Rows[i]["AccountDes"].ToString();
DataRow mdr = dt.NewRow();
mdr["id"] = ds.Tables[0].Rows[i]["id"].ToString();
mdr["sort"] = k.ToString();
mdr["my"] = "0";
mdr["main"] = main;
mdr["code"] = ds.Tables[0].Rows[i]["AccountCode"].ToString();
mdr["des"] = ds.Tables[0].Rows[i]["AccountDes"].ToString();;
mdr["m1"] = ds.Tables[0].Rows[i]["m1"].ToString();
mdr["m2"] = ds.Tables[0].Rows[i]["m2"].ToString();
mdr["m3"] = ds.Tables[0].Rows[i]["m3"].ToString();
mdr["m4"] = ds.Tables[0].Rows[i]["m4"].ToString();
mdr["m5"] = ds.Tables[0].Rows[i]["m5"].ToString();
mdr["m6"] = ds.Tables[0].Rows[i]["m6"].ToString();
mdr["m7"] = ds.Tables[0].Rows[i]["m7"].ToString();
mdr["m8"] = ds.Tables[0].Rows[i]["m8"].ToString();
mdr["m9"] = ds.Tables[0].Rows[i]["m9"].ToString();
mdr["m10"] = ds.Tables[0].Rows[i]["m10"].ToString();
mdr["m11"] = ds.Tables[0].Rows[i]["m11"].ToString();
mdr["m12"] = ds.Tables[0].Rows[i]["m12"].ToString();
mdr["tt"] = ds.Tables[0].Rows[i]["TT"].ToString();
mdr["Type"] = ds.Tables[0].Rows[i]["Type"].ToString();
dt.Rows.Add(mdr);
DataSet dss = dbs.GetSqlDataSet("select distinct SAccoundcode,SAccoundName from BudgetDetail where fid='" + ds.Tables[0].Rows[i]["id"].ToString() + "'");
if (dss.Tables[0].Rows.Count == 0)
{
k = k + 1;
}
for (int j = 0; j < dss.Tables[0].Rows.Count; j++)
{
k = k + 1;
DataRow dr = dt.NewRow();
dr["sort"] = k.ToString();
dr["my"] = "1";
dr["main"] = main;
dr["id"] = "0";
dr["code"] = dss.Tables[0].Rows[j]["SAccoundcode"].ToString();
dr["Type"] = ds.Tables[0].Rows[i]["type"].ToString();
dr["des"] = dss.Tables[0].Rows[j]["SAccoundName"].ToString();
string saccountcode = dss.Tables[0].Rows[j]["SAccoundcode"].ToString();
double Stotal = 0;
for (int m = 1; m < 13; m++)
{
string samount = dbs.ExeSqlScalar("select sum(Amount) from BudgetDetail where Months=" + m + " and fid='" + ds.Tables[0].Rows[i]["id"].ToString() + "' and SAccoundcode='" + saccountcode + "'");
string mid = "m" + m.ToString();
if (samount != "")
{
dr[mid] = samount;
Stotal = Stotal + double.Parse(samount);
}
else
{
dr[mid] = "0.00";
}
}
dr["tt"] = Stotal.ToString();
dt.Rows.Add(dr);
}
if (dss.Tables[0].Rows.Count > 0)
{
k = k + 1;
DataRow tdr = dt.NewRow();
tdr["sort"] = k.ToString();
tdr["my"] = "1";
tdr["main"] = main;
tdr["id"] = "0";
tdr["code"] = "";
tdr["Type"] = ds.Tables[0].Rows[i]["type"].ToString();
tdr["des"] = "The balance";
double ttamount = 0;
for (int q = 1; q < 13; q++)
{
string mq = "m" + q.ToString();
double tms = jdouble(lastamout(q.ToString(), ds.Tables[0].Rows[i]["id"].ToString()));
ttamount = ttamount + tms;
tdr[mq] = Convert.ToString(double.Parse(ds.Tables[0].Rows[i][mq].ToString()) - tms);
}
tdr["tt"] = Convert.ToString(double.Parse(ds.Tables[0].Rows[i]["tt"].ToString()) - ttamount);
dt.Rows.Add(tdr);
k = k + 1;
}
}
//GridView1.DataSource = dt;
//GridView1.DataBind();
Store2.DataSource = dt;
Store2.DataBind();
}
protected void ChangeGrid(object sender, DirectEventArgs e)
{
string ss = e.ExtraParams[0].Value;
DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add("ID");
dt.Columns.Add("DateT");
dt.Columns.Add("From");
dt.Columns.Add("To");
dt.Columns.Add("Purpose");
dt.Columns.Add("Amounts");
for (int i = 0; i < 10; i++)
{
dr = dt.NewRow();
dr[0] = i.ToString();
dr[1] = "2012-08-1" + i.ToString();
dr[2] = "Beijing" + ss;
dr[3] = "Tianjin" + i.ToString();
dr[4] = "吃饭" + i.ToString();
dr[5] = "50.1" + i.ToString();
dt.Rows.Add(dr);
}
Store2.RemoveAll();
Store2.DataSource = dt;
Store2.DataBind();
//GridPanel2.ColumnModel.Columns[2].Header = "Column2";
//GridPanel2.ColumnModel.Columns.RemoveAt(3);
//GridPanel2.ColumnModel.Columns.Add(new Column()
//{
// Header = "New Header",
// DataIndex = "To",
// Editor = {
// new TextField ()
// {
// AllowBlank=false
// }
// }
//});
//GridPanel2.Reconfigure();
//Ext.Net.TemplateColumn col1 = new Ext.Net.TemplateColumn();
//col1.Header = "Change";
//col1.Width = 75;
//col1.Sortable = true;
//col1.Template.ID = "Template3";
//col1.Template.Html = @"<input id=""{Purpose}"" type=""text"" value=""{Purpose}"" style=""width: 100%""></input>";
//GridPanel2.AddColumn(col1);
//add Column
//Column col = new Column();
//col.Header = "Change %";
//col.Width = 75;
//col.Sortable = true;
//col.DataIndex = "From";
//ComboBox cb = new ComboBox();
//cb.Items.Add(new Ext.Net.ListItem("1", "1"));
//cb.Items.Add(new Ext.Net.ListItem("2", "2"));
//cb.Items.Add(new Ext.Net.ListItem("3", "3"));
//this.Controls.Add(cb);
//col.Editor.Add(cb);
//this.GridPanel2.AddColumn(col);
//Ext.Net.TemplateColumn col = new Ext.Net.TemplateColumn();
//col.Header = "Change";
//col.Width = 75;
//col.Sortable = true;
//col.Template.ID = "Template5";
//col.Template.Html = @"<input id=""{Purpose}"" type=""text"" value=""{Purpose}"" style=""width: 100%""></input>";
//GridPanel2.AddColumn(col);
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="page">页码</param>
private void Query(int page)
{
try
{
int startrow = 0, len = 15, endrow = 15;
string cllx = cbocllx.Text;
// string kkid = cbostation.Text;
string kkid = "";
string clpp = ClppChoice.Value == null ? "" : ClppChoice.Value.ToString(), clxh = cbocllx.Value == null ? "" : cbocllx.Value.ToString(), csys = cbocsys.Value == null ? "" : cbocsys.Value.ToString();
string zjhsl = cboxZjh.Checked ? "1" : "", zybsl = cboxZyb.Checked ? "1" : "", dzsl = cboxDz.Checked ? "1" : "", njbsl = cboxNjb.Checked ? "1" : "", bjsl = cboxBj.Checked ? "1" : "";
//if (cbostation.Value != null)
// kkid = cbostation.Value.ToString();
if (this.kakouId.Value != null)
{
kkid = this.kakouId.Value;
}
if (page == 1)
{
startrow = 0;
}
else
{
startrow = (page - 1) * len;
}
clpp = tgsDataInfo.GetClzppString(clpp);
string xml = getxml(startrow, endrow, startdate, enddate, kkid, cllx, csys, clpp, clxh, zjhsl, zybsl, dzsl, njbsl, bjsl);
string rsxml = client.GetPassCarInfo(xml);
Dt_passcar.Clear();
CXmlToDataTable(rsxml);
int lens = getlenxml(rsxml);
realCount.Value = lens;
totalpage.Value = Math.Ceiling(double.Parse(lens.ToString()) / Convert.ToInt32(len)).ToString();
if (rsxml != "" && lens > 0)
{
this.lblCurpage.Text = (Convert.ToInt32(curpage.Value.ToString())).ToString();
this.lblAllpage.Text = totalpage.Value.ToString();
this.lblRealcount.Text = realCount.Value.ToString();
}
else
{
this.lblCurpage.Text = "1";
this.lblAllpage.Text = "0";
this.lblRealcount.Text = "0";
//GridPanel2.Title = "当前0页,共0页";
totalpage.Value = "0";
}
if (Dt_passcar != null && Dt_passcar.Rows.Count > 0)
{
Store2.DataSource = Dt_passcar;
Store2.DataBind();
SetButState(Convert.ToInt32(curpage.Value));
}
else
{
Notice("信息提示", "未查询到相关记录");
Store2.RemoveAll();
Store2.DataBind();
ButEnable(true);
}
}
catch (Exception ex)
{
ILog.WriteErrorLog(ex);
logManager.InsertLogError("OneCarMulLisence.aspx-Query", ex.Message + "；" + ex.StackTrace, "Query has an exception");
}
}
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();
}
protected void Button5_DirectClick(object sender, DirectEventArgs e)
{
if (string.IsNullOrEmpty(kakou.Value))
{
DateTime start = Convert.ToDateTime(starttime);
DateTime end = Convert.ToDateTime(endtime);
TimeSpan sp = end.Subtract(start);
if (sp.TotalMinutes > 120)
{
Notice("信息提示", "只能选择两个小时之内的时间！");
this.lblCurpage.Text = "1";
this.lblAllpage.Text = "0";
this.lblRealcount.Text = "0";
ButNext.Disabled = true;
ButLast.Disabled = true;
Store2.DataSource = new DataTable();
Store2.DataBind();
return;
}
}
if (!string.IsNullOrEmpty(kakou.Value))
{
if (kakou.Value.Contains(","))
{
string[] strs = kakou.Value.Split(',');
if (strs.Length > 10)
{
Notice("信息提示", "最多只能选择10个卡口！");
this.lblCurpage.Text = "1";
this.lblAllpage.Text = "0";
this.lblRealcount.Text = "0";
ButNext.Disabled = true;
ButLast.Disabled = true;
Store2.DataSource = new DataTable();
Store2.DataBind();
return;
}
}
}
if (Session["Condition"] != null)
{
Session["Condition"] = null;
}
Condition con = new Condition();
if (!string.IsNullOrEmpty(starttime))
{
con.StartTime = starttime;
}
if (!string.IsNullOrEmpty(endtime))
{
con.EndTime = endtime;
}
if (!string.IsNullOrEmpty(this.kakou.Value))
{
string kkid = this.kakouId.Value.ToString();
if (!string.IsNullOrEmpty(kkid))
{
con.Kkid = kkid;
if (Session["tree"] != null)
{
Session["tree"] = null;
}
Session["tree"] = kkid;
}
con.Kkidms = this.kakou.Value;
}
//if (CBkk2.Value != null)
//{
// con.Kkid = CBkk2.Value.ToString();
//}
if (CBZjs.Checked == false && CBFjs.Checked == false)
{
con.Zdmb = "0";
}
else if (CBZjs.Checked == true && CBFjs.Checked == false)
{
con.Zdmb = "2";
}
else if (CBZjs.Checked == false && CBFjs.Checked == true)
{
con.Zdmb = "3";
}
else if (CBZjs.Checked == true && CBFjs.Checked == true)
{
con.Zdmb = "4";
}
else
{
con.Zdmb = "1";
}
Session["Condition"] = con;
QueryFaceShelter(1);
//ShowQuery(1);
//string kk2 = objectToString(CBkk2.Value);
//string begin = objectToString(DateField3.Value);
//string end = DateTimeToString(DateField4.Value);
//this.Store2.DataSource = VehiclesBLL.FaceShelterDataQuery(begin, end, kk2);
//this.Store2.DataBind();
}
static void Main(string[] args)
{
string ModeSwitch()
{
Console.WriteLine("please enter store if you wish to continue as as store or user to continue as a user");
switch (Console.ReadLine())
{
case "store":
return("store");
case "user":
return("user");
default:
return(ModeSwitch());
}
}
PIZZASTORE2Context dbo = new PIZZASTORE2Context();
CL.Store currentStore = new CL.Store("temp");
List <CL.Store> availableStores = new List <CL.Store>();
{
foreach (var s in dbo.Store2.ToList())
{
var tempStore = new CL.Store(s.Name);
var tempID = -1;
foreach (var oj in dbo.OrderJunction2)
{
if (oj.StoreId == s.StoreId)
{
tempID = (int)oj.OrderId;
}
foreach (var o in dbo.Order2)
{
if (tempID == o.OrderId)
{
var tempOrder = new CL.Order();
foreach (var poj in dbo.PizzaOrderJunction2.ToList())
{
if (tempID == poj.OrderId)
{
List <string> toppings = new List <string>();
foreach (var pj in dbo.PizzaJunction2.ToList())
{
if (pj.PizzaId == poj.PizzaId)
{
foreach (var t in dbo.Toppings2)
{
if (pj.ToppingsId == t.ToppingsId)
{
toppings.Add(t.Name);
}
}
}
var pizzaName = "";
DB.Crust2 dbCrust = new Crust2();
DB.Size2 dbSize = new Size2();
foreach (var p in dbo.Pizza2)
{
if (p.PizzaId == poj.PizzaId)
{
pizzaName = p.Name;
foreach (var c in dbo.Crust2)
{
if (c.CrustId == p.CrustId)
{
dbCrust = c;
}
}
foreach (var si in dbo.Size2)
{
if (si.SizeId == p.SizeId)
{
dbSize = si;
}
}
}
}
var tempPizza = new Pizza(new CL.Crust(dbCrust.Name), new CL.Size(dbSize.Size), new CL.Toppings(toppings), pizzaName);
tempOrder.pizzas.Add(tempPizza);
}
tempStore.orders.Add(tempOrder);
}
}
availableStores.Add(tempStore);
}
}
}
}
}
if (ModeSwitch() == "store")
{
var flag = true;
Console.WriteLine("selct your store");
var inputName = Console.ReadLine();
foreach (CL.Store a in availableStores)
{
if (a.Name == inputName)
{
currentStore = a;
flag = false;
}
}
if (flag)
{
currentStore = new CL.Store(inputName);
DB.Store2 dbStore = new Store2();
dbStore.Name = inputName;
dbo.Store2.Add(dbStore);
dbo.SaveChanges();
}
Console.WriteLine("type sales to see sales");
Console.WriteLine("type orders to see orders");
Console.WriteLine("press enter top exit");
switch (Console.ReadLine())
{
default:
break;
}
}
else
{
Console.WriteLine("Please enter username");
string currentUsername = Console.ReadLine();
var currentUser = new PizzaStore.Domain.User(currentUsername);
Console.WriteLine("please select a pizza store");
foreach (var ast in availableStores)
{
Console.WriteLine($"type {ast.Name} to select {ast.Name} as the resteraunt you want to go to.");
}
var currentStoreName = Console.ReadLine();
currentStore = new CL.Store(currentStoreName);
foreach (var ast in availableStores)
{
if (ast.Name == currentStoreName)
{
currentStore = ast;
}
}
foreach (var u in dbo.User2.ToList())
{
if (u.Name == currentUsername)
{
currentUser.Name = currentUsername;
foreach (var oj2 in dbo.OrderJunction2)
{
var tempID = -1;
if (oj2.UserId == u.UserId)
{
tempID = (int)oj2.OrderId;
}
foreach (var o in dbo.Order2)
{
if (tempID == o.OrderId)
{
var tempOrder = new CL.Order();
foreach (var poj in dbo.PizzaOrderJunction2.ToList())
{
if (tempID == poj.OrderId)
{
List <string> toppings = new List <string>();
foreach (var pj in dbo.PizzaJunction2.ToList())
{
if (pj.PizzaId == poj.PizzaId)
{
foreach (var t in dbo.Toppings2)
{
if (pj.ToppingsId == t.ToppingsId)
{
toppings.Add(t.Name);
}
}
}
var pizzaName = "";
DB.Crust2 dbCrust = new Crust2();
DB.Size2 dbSize = new Size2();
foreach (var p in dbo.Pizza2)
{
if (p.PizzaId == poj.PizzaId)
{
pizzaName = p.Name;
foreach (var c in dbo.Crust2)
{
if (c.CrustId == p.CrustId)
{
dbCrust = c;
}
}
foreach (var si in dbo.Size2)
{
if (si.SizeId == p.SizeId)
{
dbSize = si;
}
}
}
}
var tempPizza = new Pizza(new CL.Crust(dbCrust.Name), new CL.Size(dbSize.Size), new CL.Toppings(toppings), pizzaName);
tempOrder.pizzas.Add(tempPizza);
}
}
currentUser.orders.Add(tempOrder);
}
}
}
}
}
}
var Starter = new Starter();
PizzaStore.Domain.Order cart = Starter.CreateOrder(currentUser, currentStore);
bool flag = true;
while (flag)
{
flag = newInput(cart, currentUser, currentStoreName);
}
}
bool newInput(CL.Order cart, CL.User currentUser, string currentStoreName)
{
Console.WriteLine("type cheese if you want to add a cheese pizza to the cart");
Console.WriteLine("type peperoni if you want peperoni");
Console.WriteLine("type sausage if you want suasage");
Console.WriteLine("type custom if you want a custom pizza");
Console.WriteLine("type cart to display the cart");
Console.WriteLine("type past to display the past orders");
Console.WriteLine("type total to see your total");
Console.WriteLine("type delete to delete a pizza");
Console.WriteLine("press enter if you want to exit");
var temp = new PizzaStore.Client.Starter();
Pizza tempPizza;
switch (Console.ReadLine())
{
case "cheese":
tempPizza = new Pizza(GetCrust(), GetSize(), new CL.Toppings(new List <string> {
"Cheese"
}), "cheese");
cart.pizzas.Add(tempPizza);
break;
case "pepperoni":
tempPizza = new Pizza(GetCrust(), GetSize(), new CL.Toppings(new List <string> {
"Pepperoni"
}), "pepperoni");
cart.pizzas.Add(tempPizza);
break;
case "suasage":
tempPizza = new Pizza(GetCrust(), GetSize(), new CL.Toppings(new List <string> {
"Suasage"
}), "suasage");
cart.pizzas.Add(tempPizza);
break;
case "custom":
tempPizza = new Pizza(GetCrust(), GetSize(), custom(), "custom");
cart.pizzas.Add(tempPizza);
break;
case "past":
var pastCart = currentUser;
foreach (CL.Order O in pastCart.orders)
{
foreach (CL.Pizza p in O.pizzas)
{
Console.WriteLine($"{p.ToString()}");
}
}
break;
case "cart":
foreach (Pizza x in cart.pizzas)
{
Console.WriteLine($"{x.ToString()}");
}
break;
case "total":
double tempTotal = 0;
foreach (Pizza x in cart.pizzas)
{
tempTotal += x.Price;
}
Console.WriteLine($"your total is: {tempTotal}");
break;
case "delete":
deletePizza(cart);
break;
default:
DB.User2 dbUser = new DB.User2();
var userExists = false;
DB.Store2 dbStore = new DB.Store2();
{
foreach (var p in dbo.User2.ToList())
{
var tempName = p.Name;
if (tempName == currentUser.Name)
{
dbUser = p;
userExists = true;
}
}
if (!userExists)
{
dbUser.Name = currentUser.Name;
dbo.User2.Add(dbUser);
dbo.SaveChanges();
}
}
foreach (var st in dbo.Store2.ToList())
{
if (st.Name == currentStoreName)
{
dbStore = st;
}
}
DB.Order2 dbCart = new DB.Order2();
dbo.SaveChanges();
dbo.Order2.Add(dbCart);
DB.OrderJunction2 dbOrderJunction = new OrderJunction2();
dbOrderJunction.Order = dbCart;
dbOrderJunction.User = dbUser;
dbo.OrderJunction2.Add(dbOrderJunction);
foreach (Pizza P in cart.pizzas)
{
var crustExists = false;
var sizeExists = false;
DB.Crust2 tempCrust = new Crust2();
tempCrust.Name = P.Crust.Name;
DB.Size2 tempSize = new Size2();
tempSize.Size = P.Size.size;
DB.Pizza2 dbPizza = new Pizza2();
dbPizza.Name = P.Name;
foreach (var c in dbo.Crust2.ToList())
{
if (c.Name == P.Crust.Name)
{
dbPizza.CrustId = c.CrustId;
crustExists = true;
}
}
if (!crustExists)
{
dbPizza.Crust = tempCrust;
}
foreach (var si in dbo.Size2.ToList())
{
if (si.Size == P.Size.size)
{
dbPizza.SizeId = si.SizeId;
sizeExists = true;
}
}
if (!sizeExists)
{
dbPizza.Size = tempSize;
}
dbo.Pizza2.Add(dbPizza);
dbo.Size2.Add(tempSize);
dbo.Crust2.Add(tempCrust);
DB.PizzaOrderJunction2 POJ = new PizzaOrderJunction2();
POJ.Order = dbCart;
POJ.Pizza = dbPizza;
dbo.PizzaOrderJunction2.Add(POJ);
foreach (var t in P.Toppings.Content)
{
DB.PizzaJunction2 PJ = new PizzaJunction2();
PJ.Pizza = dbPizza;
var toppingExists = false;
foreach (var dbT in dbo.Toppings2)
{
if (dbT.Name == t)
{
PJ.Toppings = dbT;
toppingExists = true;
}
}
if (!toppingExists)
{
DB.Toppings2 tempToppings = new Toppings2();
tempToppings.Name = t;
dbo.Add(tempToppings);
PJ.Toppings = tempToppings;
}
dbo.Add(PJ);
}
}
dbo.SaveChanges();
return(false);
}
return(true); //returns the result of the operation
}
CL.Toppings custom()
{
bool flag = true;
List <string> customPizza = new List <string>();
int customIndex = 0;
while (flag)
{
Console.WriteLine("you may only add four toppingsto your pizza");
Console.WriteLine("type cheese if you want top add a cheese pizza to the cart");
Console.WriteLine("type peperoni if you want peperoni");
Console.WriteLine("type sausage if you want suasage");
Console.WriteLine("press enter if you want to exit");
switch (Console.ReadLine())
{
case "cheese":
customPizza.Add("cheese");
customIndex += 1;
break;
case "pepperoni":
customPizza.Add("Pepperoni");
customIndex += 1;
break;
case "suasage":
customPizza.Add("suasage");
customIndex += 1;
break;
default:
flag = false;
break;
}
if (customIndex == 4)
{
flag = false;
}
}
return(new CL.Toppings(customPizza));
}
PizzaStore.Domain.Crust GetCrust()
{
Console.WriteLine("type thin if you want a thin crust");
Console.WriteLine("type thick if you want a thick crust");
Console.WriteLine("type garlic if you want a garlic crust");
switch (Console.ReadLine())
{
case "thin":
return(new CL.Crust("thin"));
case "thick":
return(new CL.Crust("thick"));
case "garlic":
return(new CL.Crust("garlic"));
default:
return(GetCrust());
}
}
CL.Size GetSize()
{
Console.WriteLine("type small or 12 if you want a small pizza");
Console.WriteLine("type medium or 14 if you want a medium pizza");
Console.WriteLine("type large or 16 if you want a large pizza");
Console.WriteLine("type 21 or extralarge if you want a large pizza");
switch (Console.ReadLine())
{
case "small":
case "12":
return(new CL.Size("small"));
case "medium":
case "14":
return(new CL.Size("medium"));
case "large":
case "16":
return(new CL.Size("large"));
case "extralarge":
case "21":
return(new CL.Size("extralarge"));
default:
return(GetSize());
}
}
void deletePizza(CL.Order cart)
{
foreach (Pizza p in cart.pizzas)
{
Console.WriteLine($" {p.ToString()}");
Console.WriteLine("delete this pizza(y/n)?");
if (Console.ReadLine() == "y")
{
cart.pizzas.Remove(p);
}
}
}
}
private void LoadValue()
{
if (Request["Sys"] != null)
{
hidsys.Text = Request["Sys"];
}
if (Request["Type"] != null)
{
hidtype.Text = Request["Type"];
}
if (Request["From"] != null)
{
hidfrom.Text = Server.UrlDecode(Request["From"]);
if (hidfrom.Text == "")
{
hidfrom.Text = "1900/01/01";
}
else
{
hidfrom.Text = (string)ControlBinder.getDate(hidfrom.Text);
}
}
if (Request["To"] != null)
{
hidto.Text = Server.UrlDecode(Request["To"]);
if (hidto.Text == "")
{
hidto.Text = "2100/01/01";
}
else
{
hidto.Text = (string)ControlBinder.getDate(hidto.Text);
}
}
if (Request["Dest"] != null)
{
hiddest.Text = Server.UrlDecode(Request["Dest"]);
}
if (Request["Sales"] != null)
{
hidsales.Text = Server.UrlDecode(Request["Sales"]);
}
if (Request["Shipper"] != null)
{
hidshipper.Text = Server.UrlDecode(Request["Shipper"]);
}
if (Request["Consignee"] != null)
{
hidconsignee.Text = Server.UrlDecode(Request["Consignee"]);
}
DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_BasicData_Print_SP", new List <IFields>()
{
dal.CreateIFields().Append("Option", "PrintList")
.Append("prt_STAT", FSecurityHelper.CurrentUserDataGET()[12]).Append("prt_ReportCode", hidtype.Text).Append("prt_sys", hidsys.Text.ToUpper() == "SYS"?"":hidsys.Text)
}).GetList();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Store2.DataSource = ds.Tables[0];
Store2.DataBind();
}
if (ds != null && ds.Tables[1].Rows.Count > 0)
{
CmbPrint.SelectedItem.Value = ds.Tables[1].Rows[0][0].ToString();
}
if (ds != null && ds.Tables[2].Rows.Count > 0)
{
hidtop.Text = ds.Tables[2].Rows[0][0].ToString();
hidbottom.Text = ds.Tables[2].Rows[0][1].ToString();
hidleft.Text = ds.Tables[2].Rows[0][2].ToString();
hidright.Text = ds.Tables[2].Rows[0][3].ToString();
}
if (ds != null && ds.Tables[3].Rows.Count > 0)
{
storeCopies.DataSource = ds.Tables[3];
storeCopies.DataBind();
}
if (ds != null && ds.Tables.Count > 4)
{
if (ds.Tables[4].Rows.Count > 0)
{
cmbPrintCount.SelectedItem.Value = ds.Tables[4].Rows[0][0].ToString();
}
}
}
