private void Awake() { if (instance == null) { instance = this; } }
protected void Btnsave_Click(object sender, System.EventArgs e) { try { SqlConnection conn = new SqlConnection(DbSmartCode.x); SqlCommand Syscmd = new SqlCommand(); Syscmd.CommandType = CommandType.StoredProcedure; Syscmd.CommandText = "Sp_Export_Data"; DateTime shipDate = DateTime.ParseExact(txtentdt.Text, "d", null); Syscmd.Parameters.AddWithValue("@sp_Date", shipDate); Syscmd.Parameters.AddWithValue("@sp_StyleID", GetStyle.SelectedValue.ToString()); Syscmd.Parameters.AddWithValue("@sp_POLot", GetPo.SelectedItem.ToString()); Syscmd.Parameters.AddWithValue("@sp_ColorID", GetColor.SelectedValue.ToString()); Syscmd.Parameters.AddWithValue("@sp_CompanyID", GetFactory.SelectedValue.ToString()); Syscmd.Parameters.AddWithValue("@sp_Size", GetSize.SelectedItem.ToString()); Syscmd.Parameters.AddWithValue("@sp_SizeQty", int.Parse(txtShipQty.Text.Trim())); Syscmd.Parameters.AddWithValue("@sp_User", this.Session["Username"].ToString()); Syscmd.Parameters.AddWithValue("@sp_Fob", decimal.Parse(txtFob.Text.Trim())); Syscmd.Connection = conn; conn.Open(); Syscmd.ExecuteNonQuery(); conn.Close(); } catch (Exception ex) { } GetSize.ClearSelection(); txtShipQty.Text = string.Empty; }
public void Setup([NotNull] Type inType, [NotNull] GetSize inGetSize, SetSize inSetSize) { #if DEV_MODE && PI_ASSERTATIONS Debug.Assert(inType != null); Debug.Assert(inGetSize != null); #endif type = inType; getSize = inGetSize; setSize = inSetSize; }
private void BindGetSize() { GetSize.Items.Clear(); //GetSize.Items.Add(new ListItem("-", "")); //GetSize.AppendDataBoundItems = true; SqlConnection conn = new SqlConnection(DbSpecFo.x); String strQuery1 = @"select distinct sm.cStyleNo,om.cPoNum,so.Size1,so.Size2,so.Size3,so.Size4,so.Size5,so.Size6,so.Size7,so.Size8,so.Size9,so.Size10,so.Size11,so.Size12,so.Size13,so.Size14,so.Size15 from Smt_OrdersMaster om join Smt_StyleMaster sm on om.nOStyleId=sm.nStyleID join Smt_OrderSize so on om.nOStyleId=so.nStyleID where sm.cStyleNo='" + GetStyle.SelectedItem.Text + "' and om.cPoNum='" + GetPo.SelectedItem.Text + "' "; //SqlCommand cmd1 = new SqlCommand(); //cmd1.CommandType = CommandType.Text; //cmd1.CommandText = strQuery1; //cmd1.Connection = conn; try { conn.Open(); SqlDataAdapter da = new SqlDataAdapter(strQuery1, conn); DataTable dt = new DataTable(); da.Fill(dt); List <string> size = new List <string>(); if (dt.Rows.Count > 0) { int i; for (i = 2; i <= dt.Columns.Count - 1; i++) { string sz = dt.Rows[0][i].ToString(); if (!String.IsNullOrWhiteSpace(sz)) { size.Add(sz); } } } GetSize.DataSource = size; //GetSize.DataTextField = "cColour"; GetSize.DataBind(); } catch (Exception ex) { throw ex; } finally { conn.Close(); conn.Dispose(); } }
protected void Btnsave_Click(object sender, System.EventArgs e) { try { SqlConnection conn = new SqlConnection(DbSmartCode.x); SqlCommand Syscmd = new SqlCommand(); Syscmd.CommandType = CommandType.StoredProcedure; Syscmd.CommandText = "Sp_Shipment_Data"; DateTime shipDate = DateTime.ParseExact(txtentdt.Text, "d", null); Syscmd.Parameters.AddWithValue("@sp_Date", shipDate); //string line = drpLine.SelectedValue.ToString(); //Syscmd.Parameters.AddWithValue("@line_no", line); //Syscmd.Parameters.AddWithValue("@ord_no", txtOrder.Text.Trim()); Syscmd.Parameters.AddWithValue("@sp_StyleID", GetStyle.SelectedValue.ToString()); Syscmd.Parameters.AddWithValue("@sp_POLot", GetPo.SelectedItem.ToString()); Syscmd.Parameters.AddWithValue("@sp_ColorID", GetColor.SelectedValue.ToString()); Syscmd.Parameters.AddWithValue("@sp_CompanyID", GetFactory.SelectedValue.ToString()); Syscmd.Parameters.AddWithValue("@sp_Size", GetSize.SelectedItem.ToString()); Syscmd.Parameters.AddWithValue("@sp_SizeQty", int.Parse(txtShipQty.Text.Trim())); Syscmd.Parameters.AddWithValue("@sp_User", this.Session["Username"].ToString()); //Syscmd.Parameters.AddWithValue("@ord_buyer", txtBuyer.Text.Trim()); //Syscmd.Parameters.AddWithValue("@target_hr", int.Parse(txtTargerHr.Text.Trim())); //Syscmd.Parameters.AddWithValue("@target_dy", int.Parse(txtTargetDy.Text.Trim())); //Syscmd.Parameters.AddWithValue("@ord_factory", txtOrdFactory.Text.Trim()); //Syscmd.Parameters.AddWithValue("@plan_hr", int.Parse(txtPlanHr.Text.Trim())); //int size = int.Parse(drpHour.SelectedValue.ToString()); //Syscmd.Parameters.AddWithValue("@prodHr", prodHr); //int hrValue = int.Parse(txtHour.Text.Trim()); //Syscmd.Parameters.AddWithValue("@hrValue", hrValue); Syscmd.Connection = conn; conn.Open(); Syscmd.ExecuteNonQuery(); conn.Close(); } catch (Exception ex) { } GetSize.ClearSelection(); txtShipQty.Text = string.Empty; //Response.Redirect(Request.RawUrl); //page refreash }
/// <summary> /// Initializes a new instance of the <see cref="T:IndexConnector" /> class. /// </summary> /// <param name="getWordFetcher">The GetWordFetcher delegate.</param> /// <param name="getSize">The GetSize delegate.</param> /// <param name="getCount">The GetCount delegate.</param> /// <param name="clearIndex">The ClearIndex delegate.</param> /// <param name="deleteData">The DeleteDataForDocument delegate.</param> /// <param name="saveData">The SaveData delegate.</param> /// <param name="tryFindWord">The TryFindWord delegate.</param> public IndexConnector(GetWordFetcher getWordFetcher, GetSize getSize, GetCount getCount, ClearIndex clearIndex, DeleteDataForDocument deleteData, SaveDataForDocument saveData, TryFindWord tryFindWord) { if (getWordFetcher == null) { throw new ArgumentNullException("getWordFetcher"); } if (getSize == null) { throw new ArgumentNullException("getSize"); } if (getCount == null) { throw new ArgumentNullException("getCount"); } if (clearIndex == null) { throw new ArgumentNullException("clearIndex"); } if (deleteData == null) { throw new ArgumentNullException("deleteData"); } if (saveData == null) { throw new ArgumentNullException("saveData"); } if (tryFindWord == null) { throw new ArgumentNullException("tryFindWord"); } this.getWordFetcher = getWordFetcher; this.getSize = getSize; this.getCount = getCount; this.clearIndex = clearIndex; this.deleteData = deleteData; this.saveData = saveData; this.tryFindWord = tryFindWord; }
/// <summary> /// Initializes a new instance of the <see cref="T:IndexConnector" /> class. /// </summary> /// <param name="getWordFetcher">The GetWordFetcher delegate.</param> /// <param name="getSize">The GetSize delegate.</param> /// <param name="getCount">The GetCount delegate.</param> /// <param name="clearIndex">The ClearIndex delegate.</param> /// <param name="deleteData">The DeleteDataForDocument delegate.</param> /// <param name="saveData">The SaveData delegate.</param> /// <param name="tryFindWord">The TryFindWord delegate.</param> public IndexConnector(GetWordFetcher getWordFetcher, GetSize getSize, GetCount getCount, ClearIndex clearIndex, DeleteDataForDocument deleteData, SaveDataForDocument saveData, TryFindWord tryFindWord) { if(getWordFetcher == null) throw new ArgumentNullException("getWordFetcher"); if(getSize == null) throw new ArgumentNullException("getSize"); if(getCount == null) throw new ArgumentNullException("getCount"); if(clearIndex == null) throw new ArgumentNullException("clearIndex"); if(deleteData == null) throw new ArgumentNullException("deleteData"); if(saveData == null) throw new ArgumentNullException("saveData"); if(tryFindWord == null) throw new ArgumentNullException("tryFindWord"); this.getWordFetcher = getWordFetcher; this.getSize = getSize; this.getCount = getCount; this.clearIndex = clearIndex; this.deleteData = deleteData; this.saveData = saveData; this.tryFindWord = tryFindWord; }
public static LinkedMemberInfo CreateForCollectionResizer(LinkedMemberHierarchy hierarchy, [NotNull] LinkedMemberInfo parent, [NotNull] Type type, GetSize getSizeDelegate, SetSize setSizeDelegate) { #if DEV_MODE && PI_ASSERTATIONS Debug.Assert(parent != null, " CreateForCollectionResizer was called with null parent!"); Debug.Assert(type != null, " CreateForCollectionResizer was called with null type!"); #endif CollectionResizerData memberData; if (!resizerPool.TryGet(out memberData)) { memberData = new CollectionResizerData(); } var created = Create(hierarchy, memberData); created.SetupCollectionResizer(parent, type, getSizeDelegate, setSizeDelegate); return(created); }
void Start() { determineWidth(); startPoint = 0 - (GetSize.getX() / 2); InvokeRepeating("spawnFood", 2.0f, 1.0f); }