public HttpResponseMessage GetTransferList()
{
WeChatAccessTokenBLL bll = new WeChatAccessTokenBLL();
String access_token = bll.GetAccessToken();
//return access_token;
string json = new JavaScriptSerializer().Serialize(new
{
db = "transfer", //指定操作的数据表
});
string cloudfuncurl = string.Format("https://api.weixin.qq.com/tcb/invokecloudfunction?access_token={0}&env={1}&name=GetTransfer", access_token, AppConsts.ENV);
string resString = Untils.HttpPost(cloudfuncurl, json);
WeChatTransferRootModel res = JsonConvert.DeserializeObject <WeChatTransferRootModel>(resString);
WeChatRootModel model = JsonConvert.DeserializeObject <WeChatRootModel>(res.resp_data.ToString());
model.code = 20000;
JavaScriptSerializer serializer = new JavaScriptSerializer();
string str = serializer.Serialize(model);
HttpResponseMessage result = new HttpResponseMessage {
Content = new StringContent(str, Encoding.GetEncoding("UTF-8"), "application/json")
};
return(result);
}
public void generateExcelToCheck(List <ReceiveOrderStruct> StockCheckList, string startTime, string endTime)
{
List <string> titleList = new List <string>();
List <Object> contentList = new List <object>();
titleList.Add("订单号");
titleList.Add("跟踪条码");
titleList.Add("客户料号");
titleList.Add("8S码");
titleList.Add("DPK类型");
titleList.Add("MAC");
titleList.Add("MPN");
titleList.Add("MB描述");
foreach (ReceiveOrderStruct stockcheck in StockCheckList)
{
ExportExcelContent ctest1 = new ExportExcelContent();
List <string> ct1 = new List <string>();
ct1.Add(stockcheck.orderNo);
ct1.Add(stockcheck.trackno);
ct1.Add(stockcheck.customMaterialNo);
ct1.Add(stockcheck.custom_serial_no);
ct1.Add(stockcheck.dpktype);
ct1.Add(stockcheck.mac);
ct1.Add(stockcheck.mpn);
ct1.Add(stockcheck.mbdescribe);
ctest1.contentArray = ct1;
contentList.Add(ctest1);
}
Untils.createExcel("D:\\收货单信息" + startTime.Replace('/', '-') + "-" + endTime.Replace('/', '-') + ".xlsx", titleList, contentList);
}
/// <summary>
/// Post Http Request
/// </summary>
/// <param name="url">Request Url</param>
/// <param name="contentStr">Post Content</param>
/// <returns></returns>
public async Task <string> HttpPostRequest(string url, string contentStr)
{
string result = string.Empty;
try
{
Untils.ChangeStatus(StatusType.Busy);
HttpContent httpContent = new StringContent(contentStr);
httpContent.Headers.ContentType = new MediaTypeHeaderValue("application/x-www-form-urlencoded");
HttpResponseMessage httpResponseMessage = await httpClient.PostAsync(url, httpContent);
if (httpResponseMessage != null && httpResponseMessage.Content != null)
{
result = await httpResponseMessage.Content.ReadAsStringAsync();
}
if (httpResponseMessage.StatusCode == System.Net.HttpStatusCode.InternalServerError)
{
throw new HttpRequestException("500 Internal Server Error");
}
}
catch (HttpRequestException ex)
{
throw ex;
}
finally
{
Untils.ChangeStatus(StatusType.Idle);
}
return(result);
}
private async void LikeClick(object sender, RoutedEventArgs e)
{
UserContentProvider user = new UserContentProvider();
LikeResult reuslt = null;
if (LikeBtn.Visibility == Visibility.Collapsed)
{
reuslt = await user.LikeNote(NoteDetail.Id, GlobalValue.CurrentUserContext.UserId, GlobalValue.CurrentUserContext.MobileToken);
}
else
{
reuslt = await user.UnlikeNote(NoteDetail.Id, GlobalValue.CurrentUserContext.UserId, GlobalValue.CurrentUserContext.MobileToken);
}
Untils.UpdateNoteDetail(NoteDetail);
LikeBtn.Visibility = reuslt.isLiked ? Visibility.Visible : Visibility.Collapsed;
if (reuslt.isLiked)
{
GalaSoft.MvvmLight.Messaging.Messenger.Default.Send(new ShowMessage()
{
MessageContent = App.Current.Resources["LikeMessage"].ToString()
});
}
else
{
GalaSoft.MvvmLight.Messaging.Messenger.Default.Send(new ShowMessage()
{
MessageContent = App.Current.Resources["UnlikeMessage"].ToString()
});
}
}
public void LoginOutlook(string email, string pass)
{
IWebDriver driver = Untils.FireFoxDriver();
try
{
driver.Manage().Window.Position = new Point(1200, 50);
driver.Manage().Window.Size = new Size(1000, 700);
string url = "https://login.live.com/login.srf";
driver.Navigate().GoToUrl(url);
WebDriverWait wait = new WebDriverWait(driver, new TimeSpan(0, 0, 8000));
wait.Until(ExpectedConditions.ElementExists(By.XPath("//*[@id=\"i0116\"]")));
//输入邮箱
driver.FindElement(By.XPath("//*[@id=\"i0116\"]")).SendKeys(email);
driver.FindElement(By.XPath("//*[@id=\"idSIButton9\"]")).Click();
//输入密码
wait.Until(ExpectedConditions.ElementToBeClickable(By.XPath("//*[@id=\"i0118\"]")));
Thread.Sleep(1000);
driver.FindElement(By.XPath("//*[@id=\"i0118\"]")).SendKeys(pass);
wait.Until(ExpectedConditions.ElementExists(By.XPath("//*[@id=\"idSIButton9\"]")));
driver.FindElement(By.XPath("//*[@id=\"idSIButton9\"]")).Click();
Thread.Sleep(3000);
driver.Navigate().GoToUrl("https://outlook.live.com/mail/0/inbox");
}
catch (Exception ex)
{
driver.Quit();
//MessageBox.Show(ex.Message);
}
}
public void generateExcelToCheck(List <BgaOutStruct> StockCheckList, string startTime, string endTime)
{
List <string> titleList = new List <string>();
List <Object> contentList = new List <object>();
titleList.Add("MPN");
titleList.Add("BGA简称");
titleList.Add("BGA描述");
titleList.Add("库位");
titleList.Add("出库数量");
titleList.Add("备注");
titleList.Add("领用人");
titleList.Add("日期");
foreach (BgaOutStruct stockcheck in StockCheckList)
{
ExportExcelContent ctest1 = new ExportExcelContent();
List <string> ct1 = new List <string>();
ct1.Add(stockcheck.mpn);
ct1.Add(stockcheck.bga_brief);
ct1.Add(stockcheck.bga_describe);
ct1.Add(stockcheck.stock_place);
ct1.Add(stockcheck.out_number);
ct1.Add(stockcheck.note);
ct1.Add(stockcheck.taker);
ct1.Add(stockcheck.input_date);
ctest1.contentArray = ct1;
contentList.Add(ctest1);
}
Untils.createExcel("D:\\BGA出库信息" + startTime.Replace('/', '-') + "-" + endTime.Replace('/', '-') + ".xlsx", titleList, contentList);
}
public void addWorkListHeads(List <TrackNoCustomRelation> TrackNoCustomRelationList, bool isGood, ref Dictionary <string, string> materialbomDic)
{
foreach (TrackNoCustomRelation trackTemp in TrackNoCustomRelationList)
{
WorkOrderHead init1 = new WorkOrderHead();
init1.wo_no = trackTemp.trackno;
init1.wo_date = Untils.getCustomDate(trackTemp.date);
init1.goods_nature = "E";
//if (isGood)
//{
string temp = trackTemp.custom_materialNo;
if (temp.Length == 10 && temp.StartsWith("000"))
{
temp = temp.Substring(3);
}
init1.cop_g_no = temp;//此处要区分对待， 如果良品入库要用正常料号，不良品入库用71料号,之前已经改过，这里直接使用
//}
//else
//{
// init1.cop_g_no = materialbomDic[trackTemp.custom_materialNo];
//}
init1.qty = "1";
init1.unit = Untils.getCustomCode(trackTemp.declare_unit);
init1.emo_no = ems_no;
workOrderHeadList.Add(init1);
}
}
public static void generateExcelToCheck(List <StockCheck> StockCheckList)
{
List <string> titleList = new List <string>();
List <Object> contentList = new List <object>();
titleList.Add("料号");
titleList.Add("数量");
titleList.Add("库房");
titleList.Add("储位");
titleList.Add("描述");
titleList.Add("真实数量");
foreach (StockCheck stockcheck in StockCheckList)
{
ExportExcelContent ctest1 = new ExportExcelContent();
List <string> ct1 = new List <string>();
ct1.Add(stockcheck.material_no);
ct1.Add(stockcheck.num);
ct1.Add(stockcheck.house);
ct1.Add(stockcheck.place);
ct1.Add(stockcheck.describe);
ct1.Add("");
ctest1.contentArray = ct1;
contentList.Add(ctest1);
}
Untils.createExcel("D:\\test.xlsx", titleList, contentList);
}
public ResultModel GetIdeaDatas(string searchKey, string orderType, int page = 1, int limit = 9999)
{
var res = _newIdeaRepository.GetList(searchKey, page, limit, orderType, out int total);
if (total == 0)
{
return(new ResultModel(0, 0, null));
}
var list = new List <object>();
foreach (var item in res)
{
var tempUser = _userRepositry.Find(item.CreateUserID);
list.Add(new
{
Oid = item.Id,
userAvtar = tempUser.Avatar,
userName = tempUser.Name,
cyintroduce = item.Introduce,
createTime = Untils.GetTimeStamp(item.CreationTime),
CommentCount = item.CommentCount,
ViewCount = item.ViewCount,
PublishCount = item.PublishCount,
Reputation = tempUser.Reputation
});
}
return(new ResultModel(0, total, list));
}
public ResultModel GetIdeaDetail(Guid id)
{
var newIdea = _ideaRepositry.Find(id);
if (newIdea == null)
{
return(new ResultModel(0, "数据不存在", null));
}
var createUser = _userRepositry.Find(newIdea.CreateUserID);
var model = new
{
Id = newIdea.Id,
Title = newIdea.Title,
Introduce = newIdea.Introduce,
ContentList = JsonConvert.DeserializeObject <List <IdeaItem> >(newIdea.Graphic),
Remark = newIdea.Remark,
CreateUser = new {
authorName = createUser.Name,
createUser.Avatar,
createUser.Gender,
createUser.Id
},
createTime = Untils.GetTimeStamp(newIdea.CreationTime),
};
return(new ResultModel(0, model));
}
/// <summary>
/// 获取access_token
/// </summary>
public string GetAccessToken()
{
string access_token = string.Empty;
string resString;
WeChatAccessTokenDAL dal = new WeChatAccessTokenDAL();
WxResponseResultModel model = dal.GetLocalAccessToken();
if (string.IsNullOrWhiteSpace(model.Access_Token)) //尚未保存过access_token
{
resString = Untils.GetToken(AppConsts.WxOpenAppId, AppConsts.WxOpenAppSecret);
WxResponseResultModel newModel = JsonConvert.DeserializeObject <WxResponseResultModel>(resString);
UpdateAccessToken(newModel);
access_token = newModel.Access_Token;
}
else
{
if (Untils.TokenExpired(model)) //access_token过期
{
resString = Untils.GetToken(AppConsts.WxOpenAppId, AppConsts.WxOpenAppSecret);
WxResponseResultModel newModel = JsonConvert.DeserializeObject <WxResponseResultModel>(resString);
UpdateAccessToken(newModel);
access_token = newModel.Access_Token;
}
else
{
return(model.Access_Token);
}
}
return(access_token);
}
public void generateExcelToCheck(List <MaterialConsumeStruct> StockCheckList, string startTime, string endTime)
{
List <string> titleList = new List <string>();
List <Object> contentList = new List <object>();
titleList.Add("MPN");
titleList.Add("描述");
titleList.Add("存储位置");
titleList.Add("消耗数量");
titleList.Add("当前库存数量");
foreach (MaterialConsumeStruct stockcheck in StockCheckList)
{
ExportExcelContent ctest1 = new ExportExcelContent();
List <string> ct1 = new List <string>();
ct1.Add(stockcheck.mpn);
ct1.Add(stockcheck.brief);
ct1.Add(stockcheck.stock_place);
ct1.Add(stockcheck.out_number);
ct1.Add(stockcheck.left_number);
ctest1.contentArray = ct1;
contentList.Add(ctest1);
}
Untils.createExcel("D:\\材料消耗信息" + startTime.Replace('/', '-') + "-" + endTime.Replace('/', '-') + ".xlsx", titleList, contentList);
}
public void EAsignup(string email, string name, string Password)
{
IWebDriver driver = Untils.FireFoxDriver();
driver.Manage().Cookies.DeleteAllCookies();
try
{
driver.Manage().Window.Size = new Size(800, 900);
String url = String.Format("https://signin.ea.com/p/originX/create?execution=e1{0}s6&initref=https%3A%2F%2Faccounts.ea.com%3A443%2Fconnect%2Fauth%3Fresponse_type%3Dcode%26client_id%3DORIGIN_SPA_ID%26display%3DoriginXWeb%252Fcreate", random.Next(10000, 99999).ToString());
driver.Navigate().GoToUrl(url);
WebDriverWait wait = new WebDriverWait(driver, new TimeSpan(0, 0, 8000));
//driver.ExecuteJavaScript(Properties.Resources.EASignup);
wait.Until(ExpectedConditions.ElementExists(By.XPath("//*[@id=\"clientreg_country-selctrl\"]")));
//地区
optionclick(driver, "//*[@id=\"clientreg_country-selctrl\"]", random.Next(1, 100).ToString());
//webselect(driver, "//*[@id=\"clientreg_country-selctrl\"]", getRandStringAll(2, 0));
//日期
optionclick(driver, "//*[@id=\"clientreg_dobyear-selctrl\"]", random.Next(20, 100).ToString());
optionclick(driver, "//*[@id=\"clientreg_dobmonth-selctrl\"]", random.Next(1, 12).ToString());
optionclick(driver, "//*[@id=\"clientreg_dobday-selctrl\"]", random.Next(1, 30).ToString());
//Thread.Sleep(502222);
var btn = driver.FindElement(By.XPath("//*[@id=\"alternativeContent\"]"));
driver.ExecuteJavaScript("arguments[0].click();", btn);
driver.FindElement(By.XPath("//*[@id=\"countryDobNextBtn\"]")).Click();
wait.Until(ExpectedConditions.ElementToBeClickable(By.XPath("//*[@id=\"email\"]")));
//Thread.Sleep(1000);
//邮箱
driver.FindElement(By.XPath("//*[@id=\"email\"]")).SendKeys(email);
//密码
driver.FindElement(By.XPath("//*[@id=\"password\"]")).SendKeys(Password);
//账号名
driver.FindElement(By.XPath("//*[@id=\"originId\"]")).SendKeys(name);
driver.FindElement(By.XPath("//*[@id=\"basicInfoNextBtn\"]")).Click();
//wait.Until(ExpectedConditions.ElementToBeClickable(By.XPath(("//*[@id=\"home_children_button\"]"))));
//driver.FindElement(By.XPath("//*[@id=\"home_children_button\"]")).Click();
//图片验证结束//*[@id="victoryScreen"]
//wait.Until(ExpectedConditions.ElementToBeClickable(By.XPath(("//*[@id=\"securityQuestion\"]"))));
//driver.FindElement(By.XPath("//*[@id=\"basicInfoNextBtn\"]")).Click();
//安全问题
wait.Until(ExpectedConditions.ElementToBeClickable(By.XPath(("//*[@id=\"securityQuestion\"]/option[5]"))));
optionclick(driver, "//*[@id=\"securityQuestion\"]", random.Next(1, 8).ToString());
driver.FindElement(By.XPath("//*[@id=\"securityAnswer\"]")).SendKeys(name);
driver.FindElement(By.XPath("//*[@id=\"submitBtn\"]")).Click();
wait.Until(ExpectedConditions.ElementToBeClickable(By.XPath(("//*[@id=\"continueDoneBtn\"]"))));
Sqlite.InsertValues("EATable", new string[] { dgv_EA.Rows.Count.ToString(), email, name, Password, Untils.GetNetworkTime().ToString() });//插入数据到数据库中
Sqlite.DeleteValuesOR("OutTable", new string[] { "Email", "Name" }, new string[] { email, name });
ReFreshAll();
driver.Quit();
driver.Close();
}
catch (Exception ex)
{
driver.Quit();
//MessageBox.Show(ex.Message);
xlog(ex.Message);
}
}
private async Task QueryDetail(string id)
{
UserContentProvider user = new UserContentProvider();
NoteDetail = await user.QueryNoteDetail(id, GlobalValue.CurrentUserContext.UserId, GlobalValue.CurrentUserContext.MobileToken);
Untils.WriteNoteDetial(NoteDetail);
}
public RequestFRUSMTStoreForm()
{
InitializeComponent();
this.dateTextBox.Text = DateTime.Now.ToString("yyyy/MM/dd");
requesterTextBox.Text = LoginForm.currentUser;
if (Untils.isTimeError(this.dateTextBox.Text.Trim()))
{
this.requestbutton.Enabled = false;
}
}
private void Form1_Load(object sender, EventArgs e)
{
Sqlite.Sqlinit();
timer1.Start();
metroLabel1.Text = "版本：" + System.Reflection.Assembly.GetExecutingAssembly().GetName().Version.ToString();
Sqlite.CreateTable("OutTable", new string[] { "ID", "Email", "Name", "Password", "CreatTime" }, new string[] { "integer", "text", "text", "text", "text" });
Untils.Filldgv("OutTable", dgv_OL);
Sqlite.CreateTable("EATable", new string[] { "ID", "Email", "Name", "Password", "CreatTime" }, new string[] { "integer", "text", "text", "text", "text" });
Untils.Filldgv("EATable", dgv_EA);
Sqlite.CreateTable("ProtonTable", new string[] { "ID", "Email", "Name", "Password", "CreatTime" }, new string[] { "integer", "text", "text", "text", "text" });
Untils.Filldgv("ProtonTable", dgv_pro);
}
public ViewModelAutoMapperConfig()
{
CreateMap<UserViewPost, User>().ForMember(dto => dto.Gender, source =>
{
source.MapFrom(m => m.Gender == "男" ? 1 : 0);
})
.AfterMap((dto, ent) => ent.Created = DateTime.Now)
.AfterMap((dto, ent) => ent.Password = Untils.MD5(ent.Password));
CreateMap<User, UsersView>().ForMember(dto => dto.Gender, source =>
{
source.MapFrom(m => m.Gender == 1 ? "男" : "女");
});
}
public void addWorkListHeads(List <TrackNoCustomRelation> TrackNoCustomRelationList)
{
foreach (TrackNoCustomRelation trackTemp in TrackNoCustomRelationList)
{
WorkOrderHead init1 = new WorkOrderHead();
init1.wo_no = trackTemp.trackno;
init1.wo_date = Untils.getCustomDate(trackTemp.date);
init1.goods_nature = "E";
init1.cop_g_no = trackTemp.custom_materialNo;
init1.qty = "1";
init1.unit = Untils.getCustomCode(trackTemp.declare_unit);
init1.emo_no = ems_no;
workOrderHeadList.Add(init1);
}
}
private async void QueryDetail(string id)
{
var temp = Untils.ReadNoteDetial(id);
if (temp == null)
{
UserContentProvider user = new UserContentProvider();
NoteDetail = await user.QueryNoteDetail(id, GlobalValue.CurrentUserContext.UserId, GlobalValue.CurrentUserContext.MobileToken);
Untils.WriteNoteDetial(NoteDetail);
}
else
{
NoteDetail = temp;
}
}
public void ProtonMail(object i)
{
IWebDriver driver = Untils.FireFoxDriver();
driver.Manage().Cookies.DeleteAllCookies();
try
{
string Accountmail = Untils.getRandString(12);
string recovermail = Untils.getRandString(12) + "@163.com";
string Accountname = Untils.getRandStringAll(8);
string Password = Untils.ranpass();
driver.Manage().Window.Size = new Size(1000, 1200);
driver.Navigate().GoToUrl("https://mail.protonmail.com/create/new?language=en");
WebDriverWait wait = new WebDriverWait(driver, new TimeSpan(0, 0, 8000));
wait.Until(ExpectedConditions.ElementToBeClickable(By.Id("password")));
//密码和确认密码
driver.FindElement(By.Id("password")).SendKeys(Password);
driver.FindElement(By.Id("passwordc")).SendKeys(Password);
driver.SwitchTo().Frame(1);
wait.Until(ExpectedConditions.ElementToBeClickable(By.Id("username")));
//用户名
driver.FindElement(By.Id("username")).SendKeys(Accountmail);
driver.SwitchTo().DefaultContent();
driver.SwitchTo().Frame(0);
//恢复邮箱
driver.FindElement(By.Id("notificationEmail")).SendKeys(recovermail);
driver.FindElement(By.Name("submitBtn")).Click();
//wait.Until(ExpectedConditions.ElementIsVisible(By.Id("pm_loading")));//*[@id="id-signup-radio-email"]
//Thread.Sleep(2000);
//MessageBox.Show("1");
//driver.FindElement(By.XPath("//*[@id=\"id-signup-radio-email\"]")).Click();
wait.Until(ExpectedConditions.ElementToBeClickable(By.Id("pm_loading")));
Sqlite.InsertValues("ProtonTable", new string[] { dgv_pro.Rows.Count.ToString(), Accountmail, Accountname, Password, DateTime.Now.ToString() });
ReFreshAll();
driver.Quit();
}
catch (Exception ex)
{
driver.Quit();
MessageBox.Show(ex.Message);
xlog(ex.Message);
}
}
/// <summary>
/// Get Http Request
/// </summary>
/// <param name="url">URL</param>
/// <returns>String</returns>
public async Task <string> HttpGetRequest(string url)
{
string result = string.Empty;
try
{
Untils.ChangeStatus(StatusType.Busy);
result = await httpClient.GetStringAsync(url);
}
catch (HttpRequestException ex)
{
throw ex;
}
finally
{
Untils.ChangeStatus(StatusType.Idle);
}
return(result);
}
private async void WeiboShare(string content)
{
string text = string.Format(App.Current.Resources["ShareArticle"].ToString(), content, this.NoteDetail.Title);
if (await Untils.WeiboShareImage(NoteDetail.ImageUrl, text))
{
GalaSoft.MvvmLight.Messaging.Messenger.Default.Send(new ShowMessage()
{
MessageContent = App.Current.Resources["ShareSuccess"].ToString()
});
}
else
{
GalaSoft.MvvmLight.Messaging.Messenger.Default.Send(new ShowMessage()
{
MessageContent = App.Current.Resources["ShareFail"].ToString()
});
}
}
public void doGenerate()
{
workListHead.seq_no = seq_no;
workListHead.boxtype = boxtype;
workListHead.flowstateg = flowstateg;
workListHead.trade_code = trade_code;
workListHead.ems_no = ems_no;
workListHead.status = status;
workListHead.workOrderHeadList = workOrderHeadList;
if (workOrderHeadList.Count > 0)
{
Untils.createWorkListHeadXML(workListHead, "D:\\WO_HEAD" + seq_no + ".xml");
MessageBox.Show(currentDay.ToString("yyyyMMdd") + "工单表头信息产生成功！");
}
else
{
MessageBox.Show(currentDay.ToString("yyyyMMdd") + "没有工单表头信息产生！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public ActionResult Login(UserModel model)
{
using (ANDONEntities entities = new ANDONEntities())
{
string pwd = Untils.MD5Encrypt(model.PWD);
user_log user = entities.user_log.Where(t => t.UID == model.UID && t.PWD == pwd).FirstOrDefault();
if (user != null)
{
user.LogInTime = DateTime.Now;
entities.SaveChanges();
Mapper.CreateMap <user_log, UserModel>(); // 配置
model = Mapper.Map <user_log, UserModel>(user); // 使用AutoMapper自动映射
SessionHelper.Add("adminInfo", model, 120);
return(Json(true));
}
else
{
return(Json(false));
}
}
}
public void doGenerate()
{
workListBody.seq_no = seq_no;
workListBody.boxtype = boxtype;
workListBody.flowstateg = flowstateg;
workListBody.trade_code = trade_code;
workListBody.ems_no = ems_no;
workListBody.status = status;
workListBody.workOrderList = workOrderList;
if (workOrderList.Count > 0)
{
Untils.createWorkListBodyXML(workListBody, "D:\\WO_ITEM" + seq_no + ".xml");
MessageBox.Show(startTime + "工单表体信息产生成功！");
}
else
{
MessageBox.Show(startTime + "工单表体信息不存在！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void generateExcelToCheck(List <DpkStruct> StockCheckList, string startTime, string endTime)
{
List <string> titleList = new List <string>();
List <Object> contentList = new List <object>();
titleList.Add("DPK类别");
titleList.Add("KEYPN");
titleList.Add("KEYID");
titleList.Add("KEYSERIAL");
titleList.Add("状态");
titleList.Add("烧录日期");
titleList.Add("客户序号");
// dpk_type NVARCHAR(128) NOT NULL, /*DPK类别*/
//KEYPN NVARCHAR(128) NOT NULL, /*KEYPN*/
//KEYID NVARCHAR(128) NOT NULL, /*KEYID*/
//KEYSERIAL NVARCHAR(128) NOT NULL, /*KEYSERIAL*/
//_status NVARCHAR(128) NOT NULL, /*状态*/
//burn_date date,/*烧录日期*/
//custom_serial_no NVARCHAR(128) /*客户序号*/
foreach (DpkStruct stockcheck in StockCheckList)
{
ExportExcelContent ctest1 = new ExportExcelContent();
List <string> ct1 = new List <string>();
ct1.Add(stockcheck.dpk_type);
ct1.Add(stockcheck.KEYPN);
ct1.Add(stockcheck.KEYID);
ct1.Add(stockcheck.KEYSERIAL);
ct1.Add(stockcheck._status);
ct1.Add(stockcheck.burn_date);
ct1.Add(stockcheck.custom_serial_no);
ctest1.contentArray = ct1;
contentList.Add(ctest1);
}
Untils.createExcel("D:\\DPK信息" + startTime.Replace('/', '-') + "-" + endTime.Replace('/', '-') + ".xlsx", titleList, contentList);
}
private void button2_Click(object sender, EventArgs e)
{
if (KEYID == "" || KEYSERIAL == "")
{
MessageBox.Show("序列号还没有下载，请检查操作！");
return;
}
//SET MBID=RIBM160907010247 跟踪条码
//SET SN=1021948402900 厂商序号
//SET SKU=45101201065 MPN
//SET MAC=28D24475FE86 MAC
//SET UUID=11111111111111111111111111111111 UUID
//SET MB11S=8SSB20A29572L1HF4440062 客户序号
//SET OA3KEY=N/A KEYID
//SET OA3PID=N/A KEYSERIAL
//SET FRUPN=04X5152 客户料号
//SET MODELID=VIUX2 MB简称
string totalStr = "SET MBID=" + track_serial_no + "\r\n"
+ "SET SN=" + vendor_serail_no + "\r\n"
+ "SET SKU=" + mpn + "\r\n"
+ "SET MAC=" + mac + "\r\n"
+ "SET UUID=" + uuid + "\r\n"
+ "SET MB11S=" + custom_serial_no + "\r\n"
+ "SET OA3KEY=" + KEYSERIAL + "\r\n"
+ "SET OA3PID=" + KEYID + "\r\n"
+ "SET FRUPN=" + customMaterialNo + "\r\n"
+ "SET MODELID=" + mb_brief + "\r\n"
+ "SET DPK=" + dpk_type;
Untils.createFile("D:\\fru\\", "BOM.bat", totalStr);
Untils.createFile("D:\\fru\\", "BOM.NSH", totalStr);
Untils.createFile("C:\\CHKCPU\\", "BOM.bat", totalStr);
//清空变量
KEYID = ""; this.keyidtextBox.Text = "";
KEYSERIAL = ""; this.KEYSERIALtextBox.Text = "";
}
private void receive(object obj)
{
CAN_OBJ vco1 = new CAN_OBJ();
while (receiveRunning)
{
//CAN_OBJ vco1 = new CAN_OBJ();
uint result = ECANDLL.Receive(4, 0, 0, out vco1, 1, 10000);
//Console.WriteLine("GetReceiveNum result : " + result);
Console.WriteLine("GetReceiveNum result data: " + Untils.ToHexString(vco1.data));
if (result != 0xFFFFFFFF && result != 0)
{
CanDataWithInfo can = new CanDataWithInfo(vco1.ID, vco1.data, "");
queueReceiveBuffer.Enqueue(can);
}
else
{
//Console.WriteLine("receive fault");
}
Thread.Sleep(10);
}
}
private void getmail(object j)
{
IWebDriver driver = Untils.FireFoxDriver();
WebDriverWait wait = new WebDriverWait(driver, new TimeSpan(0, 0, 8000));
try
{
driver.Manage().Cookies.DeleteAllCookies();
driver.Manage().Window.Size = new Size(1300, 800);
//driver.Navigate().GoToUrl("https://temp-mail.io/");
for (int i = 1; i <= 10; i++)
{
driver.ExecuteJavaScript("window.open('https://temp-mail.io')");
}
for (int i = 1; i <= 10; i++)
{
driver.SwitchTo().Window(driver.WindowHandles[i]);
//Thread.Sleep(2000);
wait.Until(ExpectedConditions.ElementToBeClickable(By.Id("email")));
var ma = driver.FindElement(By.Id("email"));
driver.FindElement(By.CssSelector("button.header-btn:nth-child(3)")).Click();
Thread.Sleep(1000);
wait.Until(ExpectedConditions.VisibilityOfAllElementsLocatedBy(By.Id("email")));
var em = driver.FindElement(By.Id("email"));
//MessageBox.Show(em.GetAttribute("value"));
metroTextBox2.Text += em.GetAttribute("value") + "\r\n";
}
}
catch {
driver.Quit();
}
}
private void tracker_bar_textBox_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == System.Convert.ToChar(13))
{
if (this.tracker_bar_textBox.Text.Trim() == "")
{
this.tracker_bar_textBox.Focus();
MessageBox.Show("追踪条码的内容为空，请检查！");
return;
}
try
{
if (Untils.isTimeError(testdatetextBox.Text.Trim()))
{
this.bomdownload.Enabled = false;
}
Untils.deleteFile("D:\\fru\\", "BOM.bat");
Untils.deleteFile("D:\\fru\\", "BOM.NSH");
Untils.deleteFile("D:\\fru\\", "DPK.TXT");
SqlConnection mConn = new SqlConnection(Constlist.ConStr);
mConn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = mConn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select station from stationInformation where track_serial_no='" + this.tracker_bar_textBox.Text.Trim() + "'";
SqlDataReader querySdr = cmd.ExecuteReader();
string station = "";
while (querySdr.Read())
{
station = querySdr[0].ToString();
}
querySdr.Close();
if (station != "维修" && station != "BGA")
{
MessageBox.Show("板子已经经过站别" + station);
mConn.Close();
this.tracker_bar_textBox.Focus();
this.tracker_bar_textBox.SelectAll();
return;
}
cmd.CommandText = "select track_serial_no,product from repair_record_table where track_serial_no='" + this.tracker_bar_textBox.Text.Trim() + "'";
querySdr = cmd.ExecuteReader();
track_serial_no = ""; product = "";
this.bomdownload.Enabled = false; this.buffertest.Enabled = false; this.isburn.Enabled = false;
if (querySdr.HasRows == false)
{
querySdr.Close();
MessageBox.Show("本条形码不在维修表中，现在检查buffer表！");
cmd.CommandText = "select track_serial_no,product from mb_out_stock where track_serial_no='" + this.tracker_bar_textBox.Text.Trim() + "'";
querySdr = cmd.ExecuteReader();
if (querySdr.HasRows == false)
{
MessageBox.Show("本条形码不在buffer出库表中，请检查！");
querySdr.Close();
mConn.Close();
return;
}
else
{
while (querySdr.Read())
{
track_serial_no = querySdr[0].ToString();
product = querySdr[1].ToString();
}
querySdr.Close();
existBuffer = true;
this.buffertest.Enabled = true;
this.isburn.Enabled = true;
}
}
else
{
while (querySdr.Read())
{
track_serial_no = querySdr[0].ToString();
product = querySdr[1].ToString();
}
querySdr.Close();
this.bomdownload.Enabled = true;
existRepair = true;
}
if (existRepair)
{
cmd.CommandText = "select top 1 _status from bga_wait_record_table where track_serial_no='" + this.tracker_bar_textBox.Text.Trim() + "' order by Id desc";
querySdr = cmd.ExecuteReader();
string bgastatus = "";
while (querySdr.Read())
{
bgastatus = querySdr[0].ToString();
}
querySdr.Close();
if (bgastatus == "BGA不良")
{
MessageBox.Show("BGA的维修记录不对，请检查！");
querySdr.Close();
mConn.Close();
return;
}
}
if (product != "" && product != "LBG")//TBG, DT, AIO
{
if (track_serial_no != "")
{
customMaterialNo = ""; vendor_serail_no = ""; mac = ""; uuid = ""; custom_serial_no = ""; mb_brief = "";
if (existRepair)
{
cmd.CommandText = "select custommaterialNo, vendor_serail_no,mac,uuid,custom_serial_no,mb_brief from DeliveredTable where track_serial_no='" + this.tracker_bar_textBox.Text.Trim() + "'";
querySdr = cmd.ExecuteReader();
while (querySdr.Read())
{
customMaterialNo = querySdr[0].ToString();
vendor_serail_no = querySdr[1].ToString();
mac = querySdr[2].ToString();
uuid = querySdr[3].ToString();
custom_serial_no = querySdr[4].ToString();
mb_brief = querySdr[5].ToString();
}
querySdr.Close();
}
else if (existBuffer)
{
cmd.CommandText = "select custommaterialNo, vendor_serial_no,custom_serial_no,mb_brief from mb_out_stock where track_serial_no='" + this.tracker_bar_textBox.Text.Trim() + "'";
querySdr = cmd.ExecuteReader();
while (querySdr.Read())
{
customMaterialNo = querySdr[0].ToString();
vendor_serail_no = querySdr[1].ToString();
custom_serial_no = querySdr[2].ToString();
mb_brief = querySdr[3].ToString();
}
querySdr.Close();
}
if (customMaterialNo != "")
{
cpu_type = ""; cpu_freq = ""; dpk_type = ""; dpkpn = ""; mpn = "";
cmd.CommandText = "select cpu_type,cpu_freq,dpk_type,dpkpn, mpn from MBMaterialCompare where custommaterialNo='" + customMaterialNo + "'";
querySdr = cmd.ExecuteReader();
while (querySdr.Read())
{
cpu_type = querySdr[0].ToString();
cpu_freq = querySdr[1].ToString();
dpk_type = querySdr[2].ToString();
dpkpn = querySdr[3].ToString();
mpn = querySdr[4].ToString();
}
querySdr.Close();
this.cpuTypetextBox.Text = cpu_type;
this.cpuFreqtextBox.Text = cpu_freq;
this.testerTextBox.Text = LoginForm.currentUser;
this.testdatetextBox.Text = DateTime.Now.ToString("yyyy/MM/dd");
KEYID = ""; KEYSERIAL = "";
if (dpk_type != "NOK" && dpkpn != "")//此时需要查找导入的dpk表格，查找对应的KEYI KEYSERIAL
{
//首先判断这个板子有没有来过，若来过则重新拿号给他，否则去新的
cmd.CommandText = "select burn_date,KEYID,KEYSERIAL from DPK_table where custom_serial_no='" + custom_serial_no + "'";
querySdr = cmd.ExecuteReader();
string burn_date = "";
while (querySdr.Read())
{
burn_date = querySdr[0].ToString();
KEYID = querySdr[1].ToString();
KEYSERIAL = querySdr[2].ToString();
}
querySdr.Close();
if (burn_date != "" && Untils.in90Days(burn_date)) //不为空且在90天内
{
//KEYID,KEYSERIAL按之前的序列号，其他内容不变
}
else//不存在或超过90天，则分配新的东西
{
cmd.CommandText = "select KEYID,KEYSERIAL,Id from DPK_table where KEYPN='" + dpkpn + "' and _status ='未使用' order by Id asc";
querySdr = cmd.ExecuteReader();
bool exist = false;
string id = "";
while (querySdr.Read())
{
exist = true;
KEYID = querySdr[0].ToString();
KEYSERIAL = querySdr[1].ToString();
id = querySdr[2].ToString();
break;
}
querySdr.Close();
if (exist == false)
{
MessageBox.Show("此DPKPN" + dpkpn + "的序列号已经使用完毕或不存在！");
mConn.Close();
return;
}
else
{
//更新烧录日期与custom_serial_no与使用状态
cmd.CommandText = "update DPK_table set _status = '已使用', burn_date = '" + DateTime.Now.ToString("yyyy/MM/dd") + "',custom_serial_no = '" + custom_serial_no + "' where Id = '" + id + "'";
cmd.ExecuteNonQuery();
}
}
}
else
{
KEYID = "NOK";
KEYSERIAL = "NOK";
}
this.keyidtextBox.Text = KEYID;
tempKeySerial = KEYSERIAL;
this.KEYSERIALtextBox.Text = KEYSERIAL;
if (KEYID != "NOK")
{
int lastEm = tempKeySerial.LastIndexOf('-');
this.KEYSERIALtextBox.Text = "XXXXX-XXXXX-XXXXX-XXXXX-" + tempKeySerial.Substring(lastEm + 1, 5);
}
}
else
{
this.tracker_bar_textBox.Focus();
this.tracker_bar_textBox.SelectAll();
MessageBox.Show("追踪条码的内容不在收货表中，请检查！");
mConn.Close();
return;
}
}
else
{
MessageBox.Show("此追踪条码没有维修记录！");
mConn.Close();
return;
}
}
else
{
if (product == "")
{
MessageBox.Show("此追踪条码没有维修记录！");
mConn.Close();
return;
}
else
{
MessageBox.Show("此追踪条码对应的客户别不是TBG, DT, AIO ！");
mConn.Close();
return;
}
}
mConn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}