public static void CleanTest(string vid)
{
var sql = "delete from VTestVM where VID = '<VID>'";
sql = sql.Replace("<VID>", vid);
DBUtility.ExeLocalSqlNoRes(sql);
}
public static void AddBuyRequest(AssetBuyInfoVM buy)
{
var now = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
var sql = @"insert into AssetBuyInfo (EngName, ChName, UnitPrice,
Brand, Model, OriginCountry, Picture, Purpose, Functions,
WorkPrinciple, CorporatePurposes, Status, CreateAt, UpdateAt)
values (@EngName, @ChName, @UnitPrice,
@Brand, @Model, @OriginCountry, @Picture, @Purpose, @Functions,
@WorkPrinciple, @CorporatePurposes, @Status, @CreateAt, @UpdateAt)";
var param = new Dictionary <string, string>();
param.Add("@EngName", buy.EngName);
param.Add("@ChName", buy.ChName);
param.Add("@UnitPrice", buy.UnitPrice);
param.Add("@Brand", buy.Brand);
param.Add("@Model", buy.Model);
param.Add("@OriginCountry", buy.OriginCountry);
param.Add("@Picture", buy.Picture);
param.Add("@Purpose", buy.Purpose);
param.Add("@Functions", buy.Functions);
param.Add("@WorkPrinciple", buy.WorkPrinciple);
param.Add("@CorporatePurposes", buy.CorporatePurposes);
param.Add("@Status", BuyStatus.Request.ToString());
param.Add("@CreateAt", now);
param.Add("@UpdateAt", now);
DBUtility.ExeLocalSqlNoRes(sql, param);
}
public static void WriteLog2(string uName, string machine, string url,
string oModule, string op, string vId, int lType, VLog4NetLevel lLevel, string msg)
{
var ret = GetVideoLog(vId, "", uName);
if (ret.Count > 0)
{
return;
}
var sql = "INSERT INTO [NPITrace].[dbo].[VideoLog] ([UserName],[Machine],[Url],[OperateModule],[Operate],[VideoID],[LogType],[LogLevel],[Message],[CreateAt]) VALUES (@uname, @machine, @url, @module, @operate, @vid, @ltype, @llevel, @msg, @date)";
var dic = new Dictionary <string, string>();
dic.Add("@uname", uName);
dic.Add("@machine", machine);
dic.Add("@url", url);
dic.Add("@module", oModule);
dic.Add("@operate", op);
dic.Add("@vid", vId);
dic.Add("@ltype", lType.ToString());
dic.Add("@llevel", "INFO");
dic.Add("@msg", msg);
dic.Add("@date", DateTime.Now.ToString());
DBUtility.ExeLocalSqlNoRes(sql, dic);
}
public static void StoreUserScore(string ma, string iname, string vid, string cans, string uans, string usc)
{
var uname = iname.Split(new string[] { "@" }, StringSplitOptions.RemoveEmptyEntries)[0].ToUpper().Trim();
MachineUserMap.TryAddMachineUserMap(ma, uname);
if (ScoreExist(uname, vid).Count == 0)
{
var videos = TechVideoVM.RetrieveVideoByID(vid);
if (videos.Count > 0)
{
UpdateUserRank(uname, usc);
var sql = @"insert into VTestScore(MACHINE,UserName,VID,VSubject,CorrectiveAnswer,UserAnswer,UserScore,UpdateTime)
values(@MACHINE,@UserName,@VID,@VSubject,@CorrectiveAnswer,@UserAnswer,@UserScore,@UpdateTime)";
var param = new Dictionary <string, string>();
param.Add("@MACHINE", ma);
param.Add("@UserName", uname);
param.Add("@VID", vid);
param.Add("@VSubject", videos[0].VSubject);
param.Add("@CorrectiveAnswer", cans);
param.Add("@UserAnswer", uans);
param.Add("@UserScore", usc);
param.Add("@UpdateTime", DateTime.Now.ToString());
DBUtility.ExeLocalSqlNoRes(sql, param);
}
}
}
public static void NewBorrow(List <AssetBorrowHistoryVM> borrow)
{
var now = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
var sql = @"insert into AssetBorrowHistory (RequestID, AssetID, BorrowUser, ProjectNo,
IsLong, StartDate, EndDate, AdminConfirm, BorrowComment, IsReturn, ReturnComment,
ReturnAt, CreateAt, UpdateAt) values ";
var param = new Dictionary <string, string>();
var idx = 0;
foreach (var item in borrow)
{
sql += "( @RequestID_" + idx + ", @AssetID_" + idx + ", @BorrowUser_" + idx + ", @ProjectNo_" + idx + ", @IsLong_" + idx
+ ", @StartDate_" + idx + ", @EndDate_" + idx + ", @AdminConfirm_" + idx + ", @BorrowComment_"
+ idx + ", @IsReturn_" + idx + ", @ReturnComment_" + idx + ", @ReturnAt_" + idx + ", @CreateAt_" + idx + ", @UpdateAt_" + idx + "),";
param.Add("@RequestID_" + idx, item.RequestID);
param.Add("@AssetID_" + idx, item.AssetID);
param.Add("@BorrowUser_" + idx, item.BorrowUser.ToUpper());
param.Add("@ProjectNo_" + idx, item.ProjectNo);
param.Add("@IsLong_" + idx, item.IsLong);
param.Add("@StartDate_" + idx, item.StartDate);
param.Add("@EndDate_" + idx, item.EndDate);
param.Add("@AdminConfirm_" + idx, item.AdminConfirm);
param.Add("@BorrowComment_" + idx, item.BorrowComment);
param.Add("@IsReturn_" + idx, item.IsReturn);
param.Add("@ReturnComment_" + idx, item.ReturnComment);
param.Add("@ReturnAt_" + idx, item.ReturnAt);
param.Add("@CreateAt_" + idx, now);
param.Add("@UpdateAt_" + idx, now);
idx++;
}
sql = sql.Substring(0, sql.Length - 1);
DBUtility.ExeLocalSqlNoRes(sql, param);
}
public static void UpdateUserRank(string UserName, string UserRank)
{
var sql = "select UserRank from VTestRank where UserName = '******'";
sql = sql.Replace("<UserName>", UserName);
var dbret = DBUtility.ExeLocalSqlWithRes(sql);
if (dbret.Count == 0)
{
sql = "insert into VTestRank(UserName,UserRank,UpdateTime) values(@UserName,@UserRank,@UpdateTime)";
var param = new Dictionary <string, string>();
param.Add("@UserName", UserName);
param.Add("@UserRank", UserRank);
param.Add("@UpdateTime", DateTime.Now.ToString());
DBUtility.ExeLocalSqlNoRes(sql, param);
}
else
{
var rank = Convert.ToInt32(dbret[0][0]);
var urank = Convert.ToInt32(UserRank);
var totalrank = rank + urank;
if (totalrank < 0)
{
totalrank = 0;
}
sql = "update VTestRank set UserRank = @UserRank,UpdateTime = @UpdateTime where UserName = @UserName";
var param = new Dictionary <string, string>();
param.Add("@UserName", UserName);
param.Add("@UserRank", totalrank.ToString());
param.Add("@UpdateTime", DateTime.Now.ToString());
DBUtility.ExeLocalSqlNoRes(sql, param);
}
}
public static void BindMesTab(string PNKey, string whichtest)
{
var sql = "update PnMESVM set Bind = 'TRUE' where PNKey = @PNKey and WhichTest = @WhichTest";
var param = new Dictionary <string, string>();
param.Add("@PNKey", PNKey);
param.Add("@WhichTest", whichtest);
DBUtility.ExeLocalSqlNoRes(sql, param);
}
public static void UpdataProductLineTestData(string DMRProdLine, Dictionary <string, DateTime> snstoredatedict)
{
var snlist = snstoredatedict.Keys.ToList();
var sncond = "('" + string.Join("','", snlist) + "')";
var sql = @"select distinct ModuleSerialNum,WhichTest,ErrAbbr,TestTimeStamp FROM [NPITrace].[dbo].[ProjectTestData] where ModuleSerialNum in <sncond> order by ModuleSerialNum,TestTimeStamp desc";
sql = sql.Replace("<sncond>", sncond);
var sntestdict = new Dictionary <string, bool>();
var ret = new List <DMRSNTestData>();
var dbret = DBUtility.ExeLocalSqlWithRes(sql);
foreach (var line in dbret)
{
var tempvm = new DMRSNTestData();
tempvm.SN = O2S(line[0]).ToUpper().Trim();
tempvm.WhichTest = O2S(line[1]);
tempvm.Failure = O2S(line[2]);
tempvm.TestTime = O2T(line[3]);
var sntestkey = tempvm.SN + ":" + tempvm.WhichTest;
if (sntestdict.ContainsKey(sntestkey))
{
continue;
}
else
{
sntestdict.Add(sntestkey, true);
}
if (!string.IsNullOrEmpty(tempvm.TestTime) &&
DateTime.Parse(tempvm.TestTime) > snstoredatedict[tempvm.SN])
{
ret.Add(tempvm);
}
}
if (ret.Count > 0)
{
var dict = new Dictionary <string, string>();
dict.Add("@DMRProdLine", DMRProdLine);
sql = "delete from DMRSNTestData where DMRProdLine = @DMRProdLine";
DBUtility.ExeLocalSqlNoRes(sql, dict);
sql = "insert into DMRSNTestData(DMRProdLine,SN,WhichTest,Failure,TestTime) values(@DMRProdLine,@SN,@WhichTest,@Failure,@TestTime)";
foreach (var item in ret)
{
dict = new Dictionary <string, string>();
dict.Add("@DMRProdLine", DMRProdLine);
dict.Add("@SN", item.SN);
dict.Add("@WhichTest", item.WhichTest);
dict.Add("@Failure", item.Failure);
dict.Add("@TestTime", item.TestTime);
DBUtility.ExeLocalSqlNoRes(sql, dict);
}
}
}
public static void CleanData(string w)
{
if (HasData(w))
{
var sql = "delete from ProbeTestData where Wafer = @Wafer";
var dict = new Dictionary <string, string>();
dict.Add("@Wafer", w);
DBUtility.ExeLocalSqlNoRes(sql, dict);
}
}
public static void NeverShowIE8Modal(string machine)
{
var sql = "delete from MachineLink where LinkName='' and ReqMachine = '<ReqMachine>' and Appv_1 <> ''";
sql = sql.Replace("<ReqMachine>", machine);
DBUtility.ExeLocalSqlNoRes(sql);
sql = "insert into MachineLink(ReqMachine,Appv_1) values(N'<ReqMachine>','nevershow')";
sql = sql.Replace("<ReqMachine>", machine);
DBUtility.ExeLocalSqlNoRes(sql);
}
private static void UpdateReviewTimes(string id, string shareto, int times)
{
var sql = "update SnapFileVM set ReviewTimes=@ReviewTimes where DocID=@DocID and ShareTo=@ShareTo";
var dict = new Dictionary <string, string>();
dict.Add("@DocID", id);
dict.Add("@ShareTo", shareto);
dict.Add("@ReviewTimes", times.ToString());
DBUtility.ExeLocalSqlNoRes(sql, dict);
}
public static void UpdatePNPJ(string pnkey, string pn, string pnpj, string defres)
{
var sql = "update PnMainVM set PN=@PN,PNPJ=@PNPJ,DefaultResult=@DefaultResult where PNKey = @PNKey";
var param = new Dictionary <string, string>();
param.Add("@PNKey", pnkey);
param.Add("@PN", pn);
param.Add("@PNPJ", pnpj);
param.Add("@DefaultResult", defres);
DBUtility.ExeLocalSqlNoRes(sql, param);
}
public static void StoreNewPN(string pn, string pnpj, string defres)
{
var sql = "insert into PnMainVM(PNKey,PN,PNPJ,DefaultResult) values(@PNKey,@PN,@PNPJ,@DefaultResult)";
var param = new Dictionary <string, string>();
param.Add("@PNKey", GetUniqKey());
param.Add("@PN", pn);
param.Add("@PNPJ", pnpj);
param.Add("@DefaultResult", defres);
DBUtility.ExeLocalSqlNoRes(sql, param);
}
public static void UpdateSmartLinkLog(string user, string machine, string link)
{
var sql = "insert SmartLinkLog(UserName,Machine,Link,UpdateTime) values(@UserName,@Machine,@Link,@UpdateTime)";
var dict = new Dictionary <string, string>();
dict.Add("@UserName", user);
dict.Add("@Machine", machine);
dict.Add("@Link", link);
dict.Add("@UpdateTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
DBUtility.ExeLocalSqlNoRes(sql, dict);
}
public static void RemoveBaseLink(string linkname)
{
var sql = "delete from LinkVM where LinkName = '<LinkName>'";
sql = sql.Replace("<LinkName>", linkname);
DBUtility.ExeLocalSqlNoRes(sql);
sql = "delete from MachineLink where LinkName = '<LinkName>'";
sql = sql.Replace("<LinkName>", linkname);
DBUtility.ExeLocalSqlNoRes(sql);
}
public static void StoreLink(string linkname, string link, string logo, string comment, string machine)
{
var sql = "delete from MachineLink where LinkName = '<LinkName>' and ReqMachine='<ReqMachine>'";
sql = sql.Replace("<LinkName>", linkname).Replace("<ReqMachine>", machine);
DBUtility.ExeLocalSqlNoRes(sql);
sql = "insert into MachineLink(LinkName,Link,Logo,Comment,ReqMachine,Freqence) values(N'<LinkName>',N'<Link>',N'<Logo>',N'<Comment>',N'<ReqMachine>',0)";
sql = sql.Replace("<LinkName>", linkname).Replace("<Link>", link).Replace("<Logo>", logo)
.Replace("<Comment>", comment).Replace("<ReqMachine>", machine);
DBUtility.ExeLocalSqlNoRes(sql);
}
public static void StoreLink(string linkname, string link, string logo, string comment)
{
var sql = "delete from LinkVM where LinkName = N'<LinkName>'";
sql = sql.Replace("<LinkName>", linkname);
DBUtility.ExeLocalSqlNoRes(sql);
sql = "insert into LinkVM(LinkName,Link,Logo,UpdateTime,Comment) values(N'<LinkName>',N'<Link>',N'<Logo>',N'<UpdateTime>',N'<Comment>')";
sql = sql.Replace("<LinkName>", linkname).Replace("<Link>", link).Replace("<Logo>", logo)
.Replace("<UpdateTime>", DateTime.Now.ToString()).Replace("<Comment>", comment);
DBUtility.ExeLocalSqlNoRes(sql);
}
public static void UpdateNGWafer(List <string> waferlist)
{
var sql = "delete from NGWafer";
DBUtility.ExeLocalSqlNoRes(sql);
foreach (var item in waferlist)
{
sql = "insert into NGWafer(WaferNo) values(N'<WaferNo>')";
sql = sql.Replace("<WaferNo>", item.Replace("'", "").Trim());
DBUtility.ExeLocalSqlNoRes(sql);
}
}
public static void UpdateQueryHistory(string wafer, string x, string y, string machine, string rest)
{
var sql = "update ProbeTestData set APVal7=@machine,APVal8=@rest,APVal9=@updatetime where Wafer=@wafer and X=@x and Y=@y";
var dict = new Dictionary <string, string>();
dict.Add("@machine", machine);
dict.Add("@rest", rest);
dict.Add("@updatetime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
dict.Add("@wafer", wafer);
dict.Add("@x", x);
dict.Add("@y", y);
DBUtility.ExeLocalSqlNoRes(sql, dict);
}
public static void RemoveFileByID(string id)
{
var sql = "delete from SnapFileVM where DocID=@DocID and ReviewTimes = 0";
var dict = new Dictionary <string, string>();
dict.Add("@DocID", id);
DBUtility.ExeLocalSqlNoRes(sql, dict);
sql = "update SnapFileVM set APVal1 = 'DELETE' where DocID=@DocID ";
dict = new Dictionary <string, string>();
dict.Add("@DocID", id);
DBUtility.ExeLocalSqlNoRes(sql, dict);
}
public static void StoreData(string id, string owner, string shareto, string url, string tag, string now)
{
var sql = "insert into SnapFileVM(DocID,Owner,ShareTo,FileAddr,UpdateTime,APVal2) values(@DocID,@Owner,@ShareTo,@FileAddr,@UpdateTime,@Tag)";
var dict = new Dictionary <string, string>();
dict.Add("@DocID", id);
dict.Add("@Owner", owner);
dict.Add("@ShareTo", shareto);
dict.Add("@FileAddr", url);
dict.Add("@UpdateTime", now);
dict.Add("@Tag", tag);
DBUtility.ExeLocalSqlNoRes(sql, dict);
}
public static void StoreVideo(string sub, string des, string path, string uper)
{
var sql = "insert into TechVideoVM(VID,VSubject,VDescription,VPath,UpdateTime,Updater) values(@VID,@VSubject,@VDescription,@VPath,@UpdateTime,@Updater)";
var param = new Dictionary <string, string>();
param.Add("@VID", GetUniqKey());
param.Add("@VSubject", sub);
param.Add("@VDescription", des);
param.Add("@VPath", path);
param.Add("@UpdateTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
param.Add("@Updater", uper);
DBUtility.ExeLocalSqlNoRes(sql, param);
}
public void StoreData()
{
var sql = "insert into ProbeTestData(Wafer,Famy,X,Y,Bin,ApSize,APVal1) values(@Wafer,@Famy,@X,@Y,@Bin,@ApSize,@APVal1)";
var dict = new Dictionary <string, string>();
dict.Add("@Wafer", Wafer);
dict.Add("@Famy", Famy);
dict.Add("@X", X);
dict.Add("@Y", Y);
dict.Add("@Bin", Bin);
dict.Add("@ApSize", ApSize);
dict.Add("@APVal1", APVal1);
DBUtility.ExeLocalSqlNoRes(sql, dict);
}
public static void TryAddMachineUserMap(string machine, string username)
{
var exist = RetrieveUserMap(machine);
if (exist.Count == 0)
{
var tempname = username.Split(new string[] { "@" }, StringSplitOptions.RemoveEmptyEntries)[0].ToUpper().Trim();
var sql = "insert into machineusermap(machine,username) values(@machine,@username)";
var param = new Dictionary <string, string>();
param.Add("@machine", machine.ToUpper().Trim());
param.Add("@username", tempname.ToUpper().Trim());
DBUtility.ExeLocalSqlNoRes(sql, param);
}
}
private static void UpdateArrayInfo()
{
var wflist = WaferList();
foreach (var wf in wflist)
{
var arraysize = GetWaferArray(wf);
var sql = "update ProbeTestData set APVal1 = @APVal1 where Wafer = @Wafer";
var dict = new Dictionary <string, string>();
dict.Add("@Wafer", wf);
dict.Add("@APVal1", arraysize);
DBUtility.ExeLocalSqlNoRes(sql, dict);
}
}
public static void StoreNote(string doorcode, string note)
{
var notekey = GetUniqKey();
var notedate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
var dict = new Dictionary <string, string>();
dict.Add("@notekey", notekey);
dict.Add("@doorcode", doorcode);
dict.Add("@note", note);
dict.Add("@notedate", notedate);
var sql = "insert into SimpleNoteVM(notekey,doorcode,note,notedate) values(@notekey,@doorcode,@note,@notedate)";
DBUtility.ExeLocalSqlNoRes(sql, dict);
}
public static void RemovePN(string pnkey)
{
var param = new Dictionary <string, string>();
param.Add("@PNKey", pnkey);
var sql = "delete from PnMainVM where PNKey = @PNKey";
DBUtility.ExeLocalSqlNoRes(sql, param);
sql = "delete from PnMESVM where PNKey = @PNKey";
DBUtility.ExeLocalSqlNoRes(sql, param);
sql = "delete from PnRulesVM where PnKey = @PNKey";
DBUtility.ExeLocalSqlNoRes(sql, param);
}
public static void RemoveCustomLink(string linkname, string link, string logo, string comment, string machine)
{
var sql = "select Freqence from MachineLink where ReqMachine = '<ReqMachine>' and LinkName = '<LinkName>'";
sql = sql.Replace("<ReqMachine>", machine).Replace("<LinkName>", linkname);
var dbret = DBUtility.ExeLocalSqlWithRes(sql);
if (dbret.Count == 0)
{
StoreLink(linkname, link, logo, comment, machine);
}
sql = "update MachineLink set Action = N'<Action>' where ReqMachine = '<ReqMachine>' and LinkName = '<LinkName>'";
sql = sql.Replace("<ReqMachine>", machine).Replace("<LinkName>", linkname).Replace("<Action>", LINKACTION.DELETE);
DBUtility.ExeLocalSqlNoRes(sql);
}
public static void AddMachineUserMap(string machine, string username)
{
var sql = "delete from machineusermap where machine = '<machine>'";
sql = sql.Replace("<machine>", machine);
DBUtility.ExeLocalSqlNoRes(sql);
var tempname = username.Split(new string[] { "@" }, StringSplitOptions.RemoveEmptyEntries)[0].ToUpper().Trim();
sql = "insert into machineusermap(machine,username) values(@machine,@username)";
var param = new Dictionary <string, string>();
param.Add("@machine", machine.ToUpper().Trim());
param.Add("@username", tempname.ToUpper().Trim());
DBUtility.ExeLocalSqlNoRes(sql, param);
}
public static void EditRule(string pnkey, string ruleid, string wt, string err, string para, string low, string high, string ruleres, string tc)
{
var sql = "update PnRulesVM set WhichTest=@WhichTest,ErrAbbr=@ErrAbbr,Param=@Param,LowLimit=@LowLimit,HighLimit=@HighLimit,RuleRes= @RuleRes,TestCase= @TestCase where RuleID = @RuleID";
var pa = new Dictionary <string, string>();
pa.Add("@RuleID", ruleid);
pa.Add("@WhichTest", wt);
pa.Add("@ErrAbbr", err);
pa.Add("@Param", para);
pa.Add("@LowLimit", low);
pa.Add("@HighLimit", high);
pa.Add("@RuleRes", ruleres);
pa.Add("@TestCase", tc);
DBUtility.ExeLocalSqlNoRes(sql, pa);
PnMESVM.BindMesTab(pnkey, wt);
}
