public Project Create(string name, PlanDate startdate) { Project newProject = new Project(name, startdate); _repository.Add(newProject); return(newProject); }
private void loadPlanDate(string usernameTo, string usernameFrom, List <DateRequest> dateRequests) { User tempUser = new User(); int userIDTo = tempUser.getUserID(usernameTo); int userIDFrom = tempUser.getUserID(usernameFrom); foreach (DateRequest dateRequest in dateRequests) { if (dateRequest.UserIDFrom == userIDFrom && dateRequest.UserIDTo == userIDTo) { string url = "https://localhost:44369/api/DatingService/Profiles/GetDatePlanDetails/" + GlobalData.APIKey + "/" + userIDFrom + "/" + userIDTo; WebRequest request = WebRequest.Create(url); WebResponse response = request.GetResponse(); Stream theDataStream = response.GetResponseStream(); StreamReader reader = new StreamReader(theDataStream); string data = reader.ReadToEnd(); reader.Close(); response.Close(); JavaScriptSerializer js = new JavaScriptSerializer(); PlanDate planDateObj = js.Deserialize <PlanDate>(data); txtDate.Text = planDateObj.Date; txtTime.Text = planDateObj.Time; txtDescription.Text = planDateObj.Description; planDate.Visible = true; } } }
public PlanDate getDatePlanDetails(string APIKey, int userIDFrom, int userIDTo) { if (APIKey == this.APIKey) { DBConnect objDB = new DBConnect(); SqlCommand objCmd = new SqlCommand(); objCmd.CommandType = CommandType.StoredProcedure; objCmd.CommandText = "TP_GetDatePlanDetails"; objCmd.Parameters.AddWithValue("@requestTo", userIDTo); objCmd.Parameters.AddWithValue("@requestFrom", userIDFrom); DataSet detailsDS = objDB.GetDataSetUsingCmdObj(objCmd); PlanDate planDate = new PlanDate(); if (detailsDS.Tables[0].Rows.Count > 0) { planDate.Date = detailsDS.Tables[0].Rows[0]["Date"].ToString(); planDate.Time = detailsDS.Tables[0].Rows[0]["Time"].ToString(); planDate.Description = detailsDS.Tables[0].Rows[0]["Description"].ToString(); return(planDate); } else { return(planDate); } } else { return(new PlanDate()); } }
void on_btnOk_clicked(object sender, EventArgs args) { string t = projektName.Text; PlanDate startdate = new PlanDate(calStartdate.Day, calStartdate.Month, calStartdate.Year); _factory.Create(t, startdate); Destroy(); }
protected void btnSavePlan_Click(object sender, EventArgs e) { lblErrorMsg.Text = string.Empty; lblErrorMsg.Visible = false; if (validatePlanDetails()) { PlanDate datePlan = new PlanDate(); datePlan.Date = txtDate.Text; datePlan.Time = txtTime.Text; datePlan.Description = txtDescription.Text; JavaScriptSerializer js = new JavaScriptSerializer(); string jsonDatePlan = js.Serialize(datePlan); try { string url = "https://localhost:44369/api/DatingService/Profiles/ModifyDatePlan/" + GlobalData.APIKey + "/" + Session["PlanDateUsernameTo"].ToString() + "/" + Session["PlanDateUsernameFrom"].ToString(); WebRequest request = WebRequest.Create(url); request.Method = "PUT"; request.ContentLength = jsonDatePlan.Length; request.ContentType = "application/json"; //Write the JSON data to the Web Request StreamWriter writer = new StreamWriter(request.GetRequestStream()); writer.Write(jsonDatePlan); writer.Flush(); writer.Close(); //Read the data from the Web Response WebResponse response = request.GetResponse(); Stream theDataStream = response.GetResponseStream(); StreamReader reader = new StreamReader(theDataStream); string data = reader.ReadToEnd(); reader.Close(); response.Close(); if (data == "true") { btnClose.Text = "Close"; lblErrorMsg.Text += "Date Plan saved successfully. <br />"; lblErrorMsg.Visible = true; } else { lblErrorMsg.Text += "*A problem occured while updating your date plan. <br />"; lblErrorMsg.Visible = true; } } catch (Exception ex) { lblErrorMsg.Text += "*Error: " + ex.Message + "<br />"; lblErrorMsg.Visible = true; } } }
private void button2_Click(object sender, EventArgs e) { if (this.dataGridView1.Rows.Count == 0) { MessageBox.Show("请先选择需要生成的记录"); } else if (comboBox3.Text.ToString().Length <= 0 || comboBox4.Text.ToString().Length <= 0 || comboBox5.Text.ToString().Length <= 0 || comboBox7.Text.ToString().Length <= 0 || comboBox9.Text.ToString().Length <= 0 || comboBox11.Text.ToString().Length <= 0 || comboBox13.Text.ToString().Length <= 0 || comboBox15.Text.ToString().Length <= 0) { MessageBox.Show("请先设置各类审批人和申请人"); } else { try { String BID, Name, Invoice; //invoic 如果不为空 需要自动生成一个 String pNmae; //提供者公司 对应BuyId : provider String Ename; //审批者 如果为空选择框中读取 对应BuyId 的person String Sub; //总金额 对应BuyId SumMoney String BDate; //购买日期 对应BuyId OrderDate DateTime Temp_BDate; //转化的过度 String PJID, BAPID, GDID; String sql1_1, sql1_2, sql1_3, sql5_1, sql4_1; String sql1, sql2, sql3, sql4, sql5, sql6; String OrderPerson, Person; String BIID, ID; String type, unit; String Num, CurrentNum; //买入数量和当前库存 String Price; String PlanID; DateTime PlanDate, GetDate, OrderDate, PlanGetDate, CheckDate; //入库日期是BDate 预计到货 PlanDate = BDate-3 GetDate = BDate-1 OrderDate = BDate -7 DateTime EndDate; //截止日期 DataGridViewCheckBoxCell checkCell; //PlanGetDate 计划到货时间 Boolean flag; Random r = new Random(); for (int row = 0; row <= this.dataGridView1.Rows.Count - 1; row++) { checkCell = (DataGridViewCheckBoxCell)dataGridView1.Rows[row].Cells[0]; flag = Convert.ToBoolean(checkCell.Value); if (flag == false) { continue; } ID = this.dataGridView1["ID", row].Value.ToString(); BID = this.dataGridView1["BID", row].Value.ToString(); Name = this.dataGridView1["Name", row].Value.ToString(); Invoice = this.dataGridView1["Invoice", row].Value.ToString(); pNmae = this.dataGridView1["PName", row].Value.ToString(); Ename = this.dataGridView1["Ename", row].Value.ToString(); Sub = this.dataGridView1["Sub", row].Value.ToString(); BDate = this.dataGridView1["BDate", row].Value.ToString(); Temp_BDate = Convert.ToDateTime(BDate); //强制转化 PJID = this.dataGridView1["PJID", row].Value.ToString(); type = this.dataGridView1["Type", row].Value.ToString(); unit = this.dataGridView1["Unit", row].Value.ToString(); Num = this.dataGridView1["Num", row].Value.ToString(); Price = this.dataGridView1["Price", row].Value.ToString(); CurrentNum = this.dataGridView1["CurrentNum", row].Value.ToString(); OrderPerson = comboBox3.Text.ToString(); //申请人 if (Ename.Length <= 0) { Person = comboBox4.Text.ToString(); } else { Person = Ename; } if (Invoice.Length <= 0) { TimeSpan cha = (DateTime.Now - TimeZone.CurrentTimeZone.ToLocalTime(new System.DateTime(1970, 1, 1))); long t = (long)cha.TotalSeconds; //用时间戳生成一个不会重复的表示符 Invoice = t.ToString(); } if (Sub.Length <= 0) { Sub = "0"; } if (CurrentNum.Length <= 0) { CurrentNum = "0"; } PlanDate = Temp_BDate.AddDays(-3); OrderDate = Temp_BDate.AddDays(-7); GetDate = Temp_BDate.AddDays(-1); CheckDate = PlanDate.AddDays(r.Next(0, 1)); //审核日期 0-1 PlanGetDate = PlanDate.AddDays(r.Next(2, 3)); //PlanGetDate 计划到货时间 PlanDate 0-3 //入库日期是BDate 预计到货 PlanDate = BDate-3 GetDate = BDate-1 OrderDate = BDate -7 EndDate = OrderDate.AddDays(5); //截止日期是申请日期+1 sql1_1 = @"INSERT INTO BuyPlan (PlanDate,Maker,Checker,CheckDate,State,IsInShopping,PlanType) VALUES('" + PlanDate + "','" + comboBox5.Text.ToString() + "','" + comboBox7.Text.ToString() + "','" + CheckDate + "','1','3','1')"; SQLHelper db1_1 = new SQLHelper(); DataTable dt1_1 = db1_1.ExecuteDataTable(sql1_1); sql1_2 = "select top(1) ID from BuyPlan order by id desc"; SQLHelper db1_2 = new SQLHelper(); DataTable dt1_2 = db1_2.ExecuteDataTable(sql1_2); PlanID = dt1_2.Rows[0][0].ToString(); //获取planID sql1_3 = @"INSERT INTO BuyPlanDetail (BPID,Name,Type,Unit,MonthNeedAmount,PJDate,PJAmount,LowAmount,TopAmount,NeedAmount,PlanBuyAmount,PlanGetDate,BuyType,Remark,BuyAmount,toothcolor,pjid) VALUES('" + PlanID + "','" + Name + "','" + type + "','" + unit + "','0','" + PlanDate + "','" + CurrentNum + "','1','0','" + Num + "','" + Num + "','" + PlanGetDate + "','0','库存报警','" + Num + "','','" + PJID + "')"; SQLHelper db1_3 = new SQLHelper(); DataTable dt1_3 = db1_3.ExecuteDataTable(sql1_3); sql1 = @"INSERT INTO BuyIn (Invoice,OrderPerson,Provider,Person,SumMoney,OrderDate,PlanID,Phone,Fax,Address,PayKind) VALUES ('" + Invoice + "','" + comboBox3.Text.ToString() + "','" + pNmae + "','" + comboBox4.Text.ToString() + "','" + Sub + "','" + OrderDate + "','" + PlanID + "','','','','')"; SQLHelper db = new SQLHelper(); DataTable dt = db.ExecuteDataTable(sql1); sql2 = "select top(1) ID from BuyIn order by id desc"; SQLHelper db2 = new SQLHelper(); DataTable dt2 = db2.ExecuteDataTable(sql2); BIID = dt2.Rows[0][0].ToString(); //获取BII sql3 = @"INSERT INTO BuyInDetail (BIID,BIName,BItype,BIUnit,BIAmount,Price,PlanDate,GetAmount,pjid,BIArea,Remark,toothcolor) VALUES ('" + BIID + "','" + Name + "','" + type + "','" + unit + "','" + Num + "','" + Price + "','" + PlanDate + "','" + Num + "','" + PJID + "','','','')"; SQLHelper db3 = new SQLHelper(); DataTable dt3 = db3.ExecuteDataTable(sql3); sql4 = @"INSERT INTO BuyInGetDetail (BIID,Name,type,unit,Price,GetDate,GetAmount,BID,pjid,Area,Remark,toothcolor,State) VALUES ('" + BIID + "','" + Name + "','" + type + "','" + unit + "','" + Price + "','" + GetDate + "','" + Num + "','" + BID + "','" + PJID + "','','','','1')"; SQLHelper db4 = new SQLHelper(); DataTable dt4 = db4.ExecuteDataTable(sql4); sql4_1 = "select top(1) ID from BuyInGetDetail order by id desc"; SQLHelper db4_1 = new SQLHelper(); DataTable dt4_1 = db4_1.ExecuteDataTable(sql4_1); GDID = dt4_1.Rows[0][0].ToString(); //获取GDID sql5 = @"INSERT INTO BuyApplyPay(ApplyPerson,ApplyDate,Provider,Person,Bank,BankAccount,SumMoney,endPayDate,GetDate,verify1State,verify1,verify1Date,verify2State,verify2,verify2Date,IsPayed,PayMoney,Remark,PayDate,PayPerson) VALUES('" + comboBox11.Text.ToString() + "','" + OrderDate + "','" + pNmae + "','','','','" + Sub + "','" + EndDate + "','','1','" + comboBox13.Text.ToString() + "','" + CheckDate + "','1','" + comboBox13.Text.ToString() + "','" + CheckDate + "','1','" + Sub + "','','" + CheckDate + "','" + comboBox15.Text.ToString() + "')"; SQLHelper db5 = new SQLHelper(); DataTable dt5 = db5.ExecuteDataTable(sql5); sql5_1 = "select top(1) ID from BuyApplyPay order by id desc"; SQLHelper db5_1 = new SQLHelper(); DataTable dt5_1 = db5_1.ExecuteDataTable(sql5_1); BAPID = dt5_1.Rows[0][0].ToString(); //获取BAPID sql6 = @"INSERT INTO BuyApplyPayDetail(BAPID,GDID,BIID,Name,type,Unit,Price,Area,GetDate,GetAmount,Remark) VALUES('" + BAPID + "','" + GDID + "','" + BIID + "','" + Name + "','" + type + "','" + unit + "','" + Price + "','','" + GetDate + "','" + Num + "','')"; SQLHelper db6 = new SQLHelper(); DataTable dt6 = db6.ExecuteDataTable(sql6); string newLine = "入库ID:" + ID + "已生成对应的采购记录和采购计划\n"; // 将textBox1的内容插入到第一行 // 索引0是 richText1 第一行位置 richTextBox1.Text = richTextBox1.Text.Insert(0, newLine); richTextBox1.ScrollToCaret(); } MessageBox.Show("生成完成"); GetGridView(); } catch (Exception e3) { WriteLog.Write_Log(e3); MessageBox.Show(e3.Message); } } }
public bool modifyDatePlan(string APIKey, string usernameTo, string usernameFrom, [FromBody] PlanDate planDate) { if (APIKey == this.APIKey) { User tempUser = new User(); int userIDTo = tempUser.getUserID(usernameTo); int userIDFrom = tempUser.getUserID(usernameFrom); DBConnect objDB = new DBConnect(); SqlCommand objCmd = new SqlCommand(); objCmd.CommandType = CommandType.StoredProcedure; objCmd.CommandText = "TP_ModifyDatePlan"; objCmd.Parameters.AddWithValue("@date", planDate.Date); objCmd.Parameters.AddWithValue("@time", planDate.Time); objCmd.Parameters.AddWithValue("@description", planDate.Description); objCmd.Parameters.AddWithValue("@requestFrom", userIDFrom); objCmd.Parameters.AddWithValue("@requestTo", userIDTo); int result = objDB.DoUpdateUsingCmdObj(objCmd); if (result == 1) { return(true); } else { return(false); } } else { return(false); } }
public Project(string name, PlanDate startdate) { Name = name; Startdate = startdate; }