private void LoadPlantcode() { try { SqlDataReader dr = null; ddl_Plantcode.Items.Clear(); ddl_Plantname.Items.Clear(); dr = Bllusers.LoadPlantcode(ccode.ToString()); if (dr.HasRows) { while (dr.Read()) { ddl_Plantcode.Items.Add(dr["Plant_Code"].ToString()); ddl_Plantname.Items.Add(dr["Plant_Code"].ToString() + "_" + dr["Plant_Name"].ToString()); } } else { ddl_Plantcode.Items.Add("--Select PlantName--"); ddl_Plantname.Items.Add("--Select Plantcode--"); } } catch (Exception EE) { string message; message = EE.ToString(); string script = "window.onload = function(){ alert('"; script += message; script += "')};"; ClientScript.RegisterStartupScript(this.GetType(), "SuccessMessage", script, true); } }
protected void Button5_Click(object sender, EventArgs e) { try { getgridviewrows(); } catch (Exception EE) { string message; message = EE.ToString(); string script = "window.onload = function(){ alert('"; script += message; script += "')};"; ClientScript.RegisterStartupScript(this.GetType(), "SuccessMessage", script, true); } }
//打包主流程 private void copyDecompileFile(string game, string channel, ProgressBar pro, Label lb) { // 拷贝游戏 copyFolder(fromPath, envConfig.targetPath + @game + @"\" + channel + @"\", pro, lb, game); // 保存参数文件--assets string propertiesFile = envConfig.gameConfig + game + @"\" + channel + envConfig.configExt; if (!Directory.Exists(envConfig.targetPath + @game + @"\" + channel + @"\assets\")) { Directory.CreateDirectory(envConfig.targetPath + @game + @"\" + channel + @"\assets\"); } if (getNum == fileNum) { File.Copy(propertiesFile, envConfig.targetPath + @game + @"\" + channel + @"\assets\" + game + envConfig.configExt, true); curEvent.Text = "copy " + channel + " 完成."; pbT.Value = 20; } //合并文件 string apkBase = envConfig.channelPath + channel + @"\apkBase\"; if (!Directory.Exists(apkBase)) { MessageBox.Show("不存在sdk母包文件"); return; } File.Delete(apkBase + @"AndroidManifest.xml"); File.Delete(apkBase + @"apktool.yml"); mergeFolder(envConfig.targetPath + @game + @"\" + channel + @"\", apkBase, pro, lb, channel); // propertiesFile = envConfig.gameConfig + game + @"\" + channel + envConfig.configExt; File.Copy(propertiesFile, envConfig.targetPath + @game + @"\" + channel + @"\assets\" + game + envConfig.configExt, true); //检测游戏母包是否还有其他文件操作 delArmeabi(game, envConfig.targetPath + @game + @"\" + channel + @"\lib"); fileNum = 0; //todo merge xml string gameXml = envConfig.targetPath + @game + @"\" + channel + @"\AndroidManifest.xml"; string xxxPath = envConfig.targetPath + @game + @"\" + channel + @"\res\drawable-xxxhdpi\"; if (Directory.Exists(xxxPath)) { FileUtil.deleteFolder(xxxPath); } curEvent.Text = "合并" + gameXml; this.mergeXml(gameXml, channel); curEvent.Text = "xml合并完成"; pro.Value = 60; pbT.Value = 60; lb.Text = "60%"; //todo replace packageName string oldName = getPackName(gameXml); PpHelper pt = new PpHelper(propertiesFile); string packageName = pt.GetPropertiesText("package"); this.replaceSpecGameXml(game, gameXml, packageName, oldName); //todo 特殊游戏包名 if (packageName.Length > 0) { XmlHelper.XmlAttributeEdit(gameXml, "manifest", "package", packageName); } string tmpXml1 = FileUtil.setXmlColon(FileUtil.getContent(gameXml)); string xmlTmpFile1 = gameXml + @".tmp"; FileUtil.writeContent(xmlTmpFile1, tmpXml1); XmlDocument dDoc = new XmlDocument(); dDoc.Load(xmlTmpFile1); XmlNode dpath = dDoc.SelectSingleNode(@"//manifest/application"); XmlElement dXe = (XmlElement)dpath; // dXe.GetAttribute("android" + FileUtil.colon + "debuggable"); dXe.SetAttribute("android" + FileUtil.colon + "debuggable", "false"); dDoc.Save(xmlTmpFile1); tmpXml1 = FileUtil.replaceXmlColon(FileUtil.getContent(xmlTmpFile1)); tmpXml1 = FileUtil.xmlRestore(tmpXml1); FileUtil.writeContent(gameXml, tmpXml1); File.Delete(xmlTmpFile1); // string tmpXml = FileUtil.setXmlColon(FileUtil.getContent(gameXml)); pbT.Value = 61; pro.Value = 61; lb.Text = "61%"; curEvent.Text = "包名替换完成"; //todo copy ico if (picString.Length > 0) { string tmpXml = FileUtil.setXmlColon(FileUtil.getContent(gameXml)); string xmlTmpFile = gameXml + @".tmp"; FileUtil.writeContent(xmlTmpFile, tmpXml); XmlDocument xmlDoc = new XmlDocument(); xmlDoc.Load(xmlTmpFile); XmlNode basePath = xmlDoc.SelectSingleNode(@"//manifest/application"); XmlElement baseXe = (XmlElement)basePath; string icoName = baseXe.GetAttribute("android" + FileUtil.colon + "icon"); icoName = icoName.Substring(icoName.IndexOf('/') + 1); copyIco(picString, envConfig.targetPath + @game + @"\" + channel + @"\res\", icoName + ".png", channel); tmpXml = FileUtil.replaceXmlColon(FileUtil.getContent(xmlTmpFile)); tmpXml = FileUtil.xmlRestore(tmpXml); FileUtil.writeContent(gameXml, tmpXml); File.Delete(xmlTmpFile); } //todo 检测渠道XML是否有特殊操作 try { updateChannelXml(game, channel, gameXml, propertiesFile); } catch (Exception EE) { MessageBox.Show(EE.ToString()); } curEvent.Text = "特殊渠道xml处理完成"; //todo merge res *.xml this.mergeRes(channel, game); pbT.Value = 65; pro.Value = 65; lb.Text = "65%"; curEvent.Text = "res xml 合并完成"; //todo make R.java //todo compile class file //todo make dex //todo make smali //todo merge smali string targetPath = envConfig.targetPath + game + @"\" + channel + @"\"; string resPath = targetPath + "res"; string tmpFolder = envConfig.upPath + @"temp\"; string tmpCls = tmpFolder + @"class\"; string tmpR = tmpFolder + @"R\"; if (Directory.Exists(tmpR)) { FileUtil.deleteFolder(tmpR); } Directory.CreateDirectory(tmpR); if (Directory.Exists(tmpCls)) { FileUtil.deleteFolder(tmpCls); } Directory.CreateDirectory(tmpCls); string packagePath = packageName.Replace(".", @"\"); string javaFilePath = tmpR + packagePath; // MessageBox.Show("java file:"+javaFilePath); curEvent.Text = "开始生成R文件"; Process makeR = new Process(); if (this.isDebug() == false) { makeR.StartInfo.UseShellExecute = false; makeR.StartInfo.CreateNoWindow = true; makeR.StartInfo.FileName = envConfig.toolPath + @"\makeR.bat"; makeR.StartInfo.RedirectStandardInput = true; makeR.StartInfo.RedirectStandardOutput = true; makeR.StartInfo.RedirectStandardError = true; } else { makeR.StartInfo.FileName = envConfig.toolPath + @"\makeR-debug.bat"; } makeR.StartInfo.Arguments = " " + resPath + " " + targetPath + "AndroidManifest.xml" + " " + tmpR + " " + tmpCls + " " + javaFilePath + " " + envConfig.targetPath + @game + @"\" + channel + @"\assets\"; makeR.Start(); string line = "\r\n"; StreamReader reader = null; if (this.isDebug() == false) { reader = makeR.StandardOutput; //截取输出流 line = reader.ReadLine(); //每次读取一行 while (!reader.EndOfStream) { line = reader.ReadLine(); line += "\r\n" + line; richTxtInfo.AppendText(line); richTxtInfo.SelectionStart = richTxtInfo.Text.Length; richTxtInfo.ScrollToCaret(); } } makeR.WaitForExit(); pbT.Value = 70; pro.Value = 70; lb.Text = "70%"; curEvent.Text = "R文件生成完成"; richTxtInfo.AppendText("\r\n R文件生成完成\r\n"); if (makeRYes.Checked == true) { string channelXml = envConfig.channelPath + channel + @"\channel.xml"; string chanelPackage = XmlHelper.getChannelAtrr(channelXml, "chanelPackage"); MessageBox.Show(chanelPackage); makeChannelRes(channel, pro, lb); } curEvent.Text = "生成class文件"; Process makeDex = new Process(); if (this.isDebug() == false) { makeDex.StartInfo.UseShellExecute = false; makeDex.StartInfo.CreateNoWindow = true; makeDex.StartInfo.FileName = envConfig.toolPath + @"\dx.bat"; makeDex.StartInfo.RedirectStandardInput = true; makeDex.StartInfo.RedirectStandardOutput = true; makeDex.StartInfo.RedirectStandardError = true; } else { makeDex.StartInfo.FileName = envConfig.toolPath + @"\dx.bat"; } makeDex.StartInfo.Arguments = " --dex --output=" + tmpFolder + "temp.dex " + tmpCls; makeDex.Start(); line = "\r\n"; if (this.isDebug() == false) { reader = makeDex.StandardOutput; //截取输出流 line = reader.ReadLine(); //每次读取一行 while (!reader.EndOfStream) { line = reader.ReadLine(); line += "\r\n" + line; richTxtInfo.AppendText(line); richTxtInfo.SelectionStart = richTxtInfo.Text.Length; richTxtInfo.ScrollToCaret(); } } makeDex.WaitForExit(); richTxtInfo.AppendText("\r\n class文件生成完成\r\n"); curEvent.Text = "生成smali"; Process makeSmali = new Process(); if (this.isDebug() == false) { makeSmali.StartInfo.UseShellExecute = false; makeSmali.StartInfo.CreateNoWindow = true; makeSmali.StartInfo.FileName = envConfig.toolPath + @"\getSmali.bat"; makeSmali.StartInfo.RedirectStandardInput = true; makeSmali.StartInfo.RedirectStandardOutput = true; makeSmali.StartInfo.RedirectStandardError = true; } else { makeSmali.StartInfo.FileName = envConfig.toolPath + @"\getSmali-debug.bat"; MessageBox.Show("begin"); } makeSmali.StartInfo.Arguments = targetPath + @"smali\ " + tmpFolder + "temp.dex "; makeSmali.Start(); line = "\r\n"; if (this.isDebug() == false) { reader = makeSmali.StandardOutput; //截取输出流 line = reader.ReadLine(); //每次读取一行 while (!reader.EndOfStream) { line = reader.ReadLine(); line += "\r\n" + line; richTxtInfo.AppendText(line); richTxtInfo.SelectionStart = richTxtInfo.Text.Length; richTxtInfo.ScrollToCaret(); } } makeSmali.WaitForExit(); pbT.Value = 75; pro.Value = 75; lb.Text = "75%"; curEvent.Text = "smali 合并完成"; richTxtInfo.AppendText("\r\n" + "smali 合并完成\r\n"); FileUtil.deleteFolder(tmpR); FileUtil.deleteFolder(tmpCls); File.Delete(tmpFolder + "temp.dex"); string packageFolder = envConfig.targetPath + @game + @"\" + channel + @"\"; string compileFolder = envConfig.compileFolder + game + @"\"; string mkTime = DateTime.Now.ToString("yyyyMMddHHmmss"); string compileApkName = channel + "_" + mkTime + ".apk"; Process p = new Process(); if (this.isDebug() == false) { p.StartInfo.UseShellExecute = false; p.StartInfo.CreateNoWindow = true; p.StartInfo.FileName = envConfig.apkToolCommand; p.StartInfo.RedirectStandardInput = true; p.StartInfo.RedirectStandardOutput = true; p.StartInfo.RedirectStandardError = true; } else { p.StartInfo.FileName = envConfig.currenPath + @"\apktool\apktool-debug.bat"; } string compileApk = compileFolder + compileApkName; p.StartInfo.Arguments = " b " + packageFolder + " -o " + compileApk; p.Start(); line = "\r\n"; if (this.isDebug() == false) { reader = p.StandardOutput; //截取输出流 line = reader.ReadLine(); //每次读取一行 while (!reader.EndOfStream) { line = reader.ReadLine(); line += "\r\n" + line; richTxtInfo.AppendText(line); richTxtInfo.SelectionStart = richTxtInfo.Text.Length; richTxtInfo.ScrollToCaret(); } } p.WaitForExit(); pbT.Value = 80; pro.Value = 80; lb.Text = "80%"; curEvent.Text = channel + " 打包完成"; richTxtInfo.AppendText("\r\n" + curEvent.Text + "\r\n"); Process makeSign = new Process(); // 签名-调用命令行输出 //makeSign.StartInfo.UseShellExecute = false; //makeSign.StartInfo.CreateNoWindow = true; //makeSign.StartInfo.RedirectStandardInput = true; //makeSign.StartInfo.RedirectStandardOutput = true; //makeSign.StartInfo.RedirectStandardError = true; string signPwd = txtSignPwd.Text.ToString(); string keyStrorePwd = txtKeyPwd.Text.ToString(); string keyStore = lbPwdFile.Text.ToString(); string alias = txtAlias.Text.ToString(); string releasePath = envConfig.releasePkg + game + @"\"; if (!Directory.Exists(releasePath)) { Directory.CreateDirectory(releasePath); } string releaseApk = releasePath + game + "_" + compileApkName; // makeSign.StartInfo.FileName = envConfig.signPath + "jarsigner"; makeSign.StartInfo.FileName = "jarsigner"; // compileApk = @"C:\Users\win8\Desktop\123.apk"; makeSign.StartInfo.Arguments = " -digestalg SHA1 -sigalg MD5withRSA -verbose -keystore " + keyStore + " -storepass " + keyStrorePwd + " -keypass " + signPwd + " -signedjar " + releaseApk + " " + compileApk + " " + alias; Clipboard.SetText(makeSign.StartInfo.FileName + " " + makeSign.StartInfo.Arguments); // MessageBox.Show("beginSign"); makeSign.Start(); //reader = makeSign.StandardOutput;//截取输出流 //line = "\r\n"; //line = reader.ReadLine();//每次读取一行 //while (!reader.EndOfStream) //{ // line = reader.ReadLine(); // line += "\r\n" + line; // richTxtInfo.AppendText(line); // richTxtInfo.SelectionStart = richTxtInfo.Text.Length; // richTxtInfo.ScrollToCaret(); //} makeSign.WaitForExit(); pbT.Value = 100; pro.Value = 100; lb.Text = "100%"; curEvent.Text = channel + "签名完成"; richTxtInfo.AppendText("\r\n" + curEvent.Text + "\r\n"); //todo 加固 }
protected void Button5_Click(object sender, EventArgs e) { checkcodition(); if (datacheck == 0) { gettingprocurementimportdata(); foreach (DataRow importprodata in DTG.Tables[0].Rows) { Getagentid = importprodata[1].ToString(); // prdate = importprodata[2].ToString(); string Convedate = importprodata[2].ToString(); string[] arrdate = Convedate.Split('-'); string dd = arrdate[0]; string MM = arrdate[1]; string yy = arrdate[2]; prdate = MM + "/" + dd + "/" + yy; GET = prdate.Split(' '); prdate = GET[0].ToString(); Sessions = importprodata[3].ToString(); FAT = Convert.ToDouble(importprodata[5]); SNF = Convert.ToDouble(importprodata[6]); PlantCode = importprodata[7].ToString(); Route_id = importprodata[8].ToString(); NoofCans = Convert.ToInt16(importprodata[9]); Milk_kg = Convert.ToDouble(importprodata[4]); string tempkg = Milk_kg.ToString("f2"); Milk_kg = Convert.ToDouble(tempkg); tmilkltr = (Milk_kg / 1.03).ToString("f2"); milkltr = Convert.ToDouble(tmilkltr); if (Milk_kg < 0) { Milk_kg = 0; milkltr = 0; } // @Clr=(((@Snf - 0.36) - (@Fat * 0.21)) * 4) Clr = Convert.ToDouble((((SNF - 0.36) - (FAT * 0.21)) * 4)); tclr = Clr.ToString("f2"); Clr = Convert.ToDouble(tclr); // Clr = importprodata[11].ToString(); Company_Code = importprodata[12].ToString(); Milk_Nature = importprodata[13].ToString(); if (Milk_Nature == "1") { MilkNature = "Cow"; } else { MilkNature = "Buffalo"; } SampleId = importprodata[14].ToString(); Sampleno = importprodata[15].ToString(); milk_tip_st_time = importprodata[16].ToString(); milk_tip_end_time = importprodata[17].ToString(); usr_weigher = importprodata[18].ToString(); usr_analizer = importprodata[19].ToString(); fat_kg = ((Milk_kg / 100) * FAT).ToString("f2"); snf_kg = ((Milk_kg / 100) * SNF).ToString("f2"); Truck_id = importprodata[22].ToString(); Status = importprodata[23].ToString(); ViewState["Getagentid"] = Getagentid.ToString(); ViewState["FAT"] = FAT.ToString(); ViewState["SNF"] = SNF.ToString(); getroutedetails(); if (countroute == 1) { } else { string insertroute; con = DB.GetConnection(); insertroute = "INSERT INTO route_Master(route_Id,route_Name,tot_Distance,added_date,status,Company_Code,Plant_Code,Lstatus) values ('" + Route_id + "' ,'" + "ROUTE-" + Route_id + "','" + 1 + "','" + System.DateTime.Now + "','" + 1 + "','" + ccode + "' ,'" + pcode + "','" + 1 + "')"; SqlCommand cmd = new SqlCommand(insertroute, con); } getagentdetails(); if (countagent == 1) { } else { string insertagnet; con = DB.GetConnection(); insertagnet = " INSERT INTO Agent_Master(Agent_Id,Agent_Name,Type,Cartage_Amt,Company_code,Plant_code,Route_id,Bank_Id,Payment_mode,Agent_AccountNo,AddedDate,phone_Number,Milk_Nature,Ifsc_code,SplBonus_Amt,agentratechartmode) values ('" + Getagentid + "','" + Getagentid + "','" + 0 + "','" + 0 + "','" + ccode + "','" + pcode + "','" + Route_id + "','" + 0 + "','CASH','" + 0 + "','" + 0 + "','" + Milk_Nature + "','" + 0 + "','" + 0 + ",'" + 0 + "')"; SqlCommand cmd = new SqlCommand(insertagnet, con); } gettingdatafromagentmaster(); COUNTI = COUNTI + 1; foreach (DataRow agentmaster in DTG.Tables[COUNTI].Rows) { cart = Convert.ToDouble(agentmaster[0]); nature = agentmaster[1].ToString(); splbonus = Convert.ToDouble(agentmaster[2]); //int agentchartmode = Convert.ToInt16(agentmaster[3]); //int dpuagent; //try //{ // // dpuagent = Convert.ToInt16(agentmaster[4]); //} //catch //{ // dpuagent = 0; //} cchartname = (agentmaster[5]).ToString(); //going to add filed chartname bchartname = (agentmaster[6]).ToString(); ViewState["cart"] = cart; ViewState["spbonus"] = splbonus; ViewState["nature"] = nature; ViewState["cowchartname"] = cchartname.ToString(); ViewState["buffchartname"] = bchartname.ToString(); } if ((MilkNature == "1") || (MilkNature == "Cow")) { gettingchartmaster(); } else { gettingchartmasterforbuff(); } charttype = DTG.Tables[COUNTI].Rows[rows][1].ToString(); minfat = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][2]); maxfat = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][3]); if ((MilkNature == "1") || (MilkNature == "Cow")) { bufftocowrate = 0; SnfCutting = 0; } else { bufftocowrate = Convert.ToDouble(DTG.Tables[COUNTI].Rows[1][4]); SnfCutting = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][5]); } NATURE = ViewState["nature"].ToString(); if (NATURE == "Cow") { if (charttype == "TS") { gettingTSratechart(); try { COUNTI = COUNTI + 1; RATE = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][0]); commission = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][1]); bonus = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][2]); RATE = RATE * (FAT + SNF); RATEE = RATE.ToString("F2"); RATE = Convert.ToDouble(RATEE); tempamount = (RATE * milkltr).ToString("F2"); if (RATE > 0) { amount = Convert.ToDouble(tempamount); } else { amount = 0; } } catch (Exception EE) { string GET45 = EE.ToString(); } } if (charttype == "SNF") { COUNTI = COUNTI + 1; gettingSNFratechart(); double TEMPRATE = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][0]); commission = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][1]); bonus = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][2]); double TEMPFAT = Convert.ToDouble(ViewState["FAT"]); double TEMPSNF = Convert.ToDouble(ViewState["SNF"]); RATE = TEMPRATE * (TEMPFAT + TEMPSNF); RATEE = RATE.ToString("F2"); RATE = Convert.ToDouble(RATEE); tempamount = (RATE * milkltr).ToString("F2"); if (RATE > 0) { amount = Convert.ToDouble(tempamount); } else { amount = 0; } } if (charttype == "FATSNF") { COUNTI = COUNTI + 1; gettingFATSNFratechart(); commission = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][1]); bonus = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][2]); double FRATE = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][0]); gettingFATSNFratechartrate(); COUNTI = COUNTI + 1; double SRATE = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][0]); double TEMPFATRATE = (FAT * FRATE); double TEMPSNFRATE = (SNF * SRATE); RATE = (TEMPFATRATE + TEMPSNFRATE); RATEE = RATE.ToString("F2"); RATE = Convert.ToDouble(RATEE); tempamount = (RATE * milkltr).ToString("F2"); if (RATE > 0) { amount = Convert.ToDouble(tempamount); } else { amount = 0; } } if (charttype == "FATSNFMIXED") { COUNTI = COUNTI + 1; gettingFATSNFMIXINGFAT(); COUNTI = COUNTI + 1; ViewState["FATSTATUS"] = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][0]); gettingFATSNFMIXINGSNF(); COUNTI = COUNTI + 1; RATE = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][0]); commission = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][1]); bonus = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][2]); commission = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][1]); bonus = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][2]); double TEMPRATE = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][0]); double TEMPFAT = Convert.ToDouble(ViewState["FAT"]); double TEMPSNF = Convert.ToDouble(ViewState["SNF"]); RATE = TEMPRATE * (TEMPFAT + TEMPSNF); tempamount = (RATE * milkltr).ToString("F2"); if (RATE > 0) { amount = Convert.ToDouble(tempamount); } else { amount = 0; } } CHARTID = ViewState["cowchartname"].ToString(); } if (NATURE == "Buffalo") { if (charttype == "FAT") { COUNTI = COUNTI + 1; gettingfatratechart(); RATE = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][0]); commission = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][1]); bonus = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][2]); CHARTID = ViewState["buffchartname"].ToString(); if (SnfCutting == 1) { snfcuttingplant(); COUNTI = COUNTI + 1; double tempcut = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][5]); RATE = RATE - tempcut; } else { RATE = (FAT * RATE); tempamount = (RATE * Milk_kg).ToString("F2"); amount = Convert.ToDouble(tempamount); } } if (FAT < bufftocowrate) { COUNTI = COUNTI + 1; gettingdatafromagentmasterBUFFTOCOW(); foreach (DataRow agentmaster in DTG.Tables[COUNTI].Rows) { cart = Convert.ToDouble(agentmaster[0]); nature = agentmaster[1].ToString(); splbonus = Convert.ToDouble(agentmaster[2]); //int agentchartmode = Convert.ToInt16(agentmaster[3]); //int dpuagent; //try //{ // // dpuagent = Convert.ToInt16(agentmaster[4]); //} //catch //{ // dpuagent = 0; //} cchartname = (agentmaster[5]).ToString(); //going to add filed chartname bchartname = (agentmaster[6]).ToString(); ViewState["cart"] = cart; ViewState["spbonus"] = splbonus; ViewState["nature"] = nature; ViewState["cowchartname"] = cchartname.ToString(); ViewState["buffchartname"] = bchartname.ToString(); } gettingchartmasterBUFFTOCOW(); charttype = DTG.Tables[COUNTI].Rows[0][1].ToString(); minfat = Convert.ToDouble(DTG.Tables[COUNTI].Rows[0][2]); maxfat = Convert.ToDouble(DTG.Tables[COUNTI].Rows[0][3]); NATURE = ViewState["nature"].ToString(); if (charttype == "TS") { gettingTSratechartCOWBUFF(); COUNTI = COUNTI + 1; RATE = Convert.ToDouble(DTG.Tables[COUNTI].Rows[0][0]); commission = Convert.ToDouble(DTG.Tables[COUNTI].Rows[0][1]); bonus = Convert.ToDouble(DTG.Tables[COUNTI].Rows[0][2]); RATE = RATE * (FAT + SNF); RATEE = RATE.ToString("F2"); RATE = Convert.ToDouble(RATEE); tempamount = (RATE * Milk_kg).ToString("F2"); amount = Convert.ToDouble(tempamount); } if (charttype == "SNF") { COUNTI = COUNTI + 1; gettingSNFratechart(); double TEMPRATE = Convert.ToDouble(DTG.Tables[COUNTI].Rows[0][0]); commission = Convert.ToDouble(DTG.Tables[COUNTI].Rows[0][1]); bonus = Convert.ToDouble(DTG.Tables[COUNTI].Rows[0][2]); double TEMPFAT = Convert.ToDouble(ViewState["FAT"]); double TEMPSNF = Convert.ToDouble(ViewState["SNF"]); RATE = TEMPRATE * (TEMPFAT + TEMPSNF); RATEE = RATE.ToString("F2"); RATE = Convert.ToDouble(RATEE); tempamount = (RATE * Milk_kg).ToString("F2"); amount = Convert.ToDouble(tempamount); } if (charttype == "FATSNF") { COUNTI = COUNTI + 1; gettingFATSNFratechart(); gettingFATSNFratechartrate(); commission = Convert.ToDouble(DTG.Tables[COUNTI].Rows[0][1]); bonus = Convert.ToDouble(DTG.Tables[COUNTI].Rows[0][2]); double FRATE = Convert.ToDouble(DTG.Tables[COUNTI].Rows[0][0]); COUNTI = COUNTI + 1; double SRATE = Convert.ToDouble(DTG.Tables[COUNTI].Rows[0][0]); double TEMPFATRATE = (FAT * FRATE); double TEMPSNFRATE = (SNF * SRATE); RATE = (TEMPFATRATE + TEMPSNFRATE); RATEE = RATE.ToString("F2"); RATE = Convert.ToDouble(RATEE); tempamount = (RATE * Milk_kg).ToString("F2"); amount = Convert.ToDouble(tempamount); } if (charttype == "FATSNFMIXED") { COUNTI = COUNTI + 1; gettingFATSNFMIXINGFAT(); ViewState["FATSTATUS"] = Convert.ToDouble(DTG.Tables[COUNTI].Rows[0][0]); gettingFATSNFMIXINGSNF(); COUNTI = COUNTI + 1; RATE = Convert.ToDouble(DTG.Tables[COUNTI].Rows[0][0]); commission = Convert.ToDouble(DTG.Tables[COUNTI].Rows[0][1]); bonus = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][2]); commission = Convert.ToDouble(DTG.Tables[COUNTI].Rows[0][1]); bonus = Convert.ToDouble(DTG.Tables[COUNTI].Rows[rows][2]); double TEMPRATE = Convert.ToDouble(DTG.Tables[COUNTI].Rows[0][0]); double TEMPFAT = Convert.ToDouble(ViewState["FAT"]); double TEMPSNF = Convert.ToDouble(ViewState["SNF"]); RATE = TEMPRATE * (TEMPFAT + TEMPSNF); tempamount = (RATE * Milk_kg).ToString("F2"); amount = Convert.ToDouble(tempamount); } CHARTID = ViewState["cowchartname"].ToString(); } //if (NATURE == "Buffalo") //{ // if (charttype == "FAT") // { // COUNTI = COUNTI + 1; // gettingfatratechart(); // RATE = Convert.ToDouble(DTG.Tables[9].Rows[rows][0]); // commission = Convert.ToDouble(DTG.Tables[9].Rows[rows][1]); // bonus = Convert.ToDouble(DTG.Tables[9].Rows[rows][2]); // CHARTID = ViewState["buffchartname"].ToString(); // tempamount = (RATE * Milk_kg).ToString("F2"); // amount = Convert.ToDouble(tempamount); // } //} } if (NATURE == "Cow") { if ((commission < 0.20) && (commission > 0)) { double TEMPFAT = Convert.ToDouble(ViewState["FAT"]); templtr = milkltr; double mkg = templtr * 1.03; calcommission = (RATE * commission) * templtr; } if ((commission >= 0.20) && (commission > 0)) { double TEMPFAT = Convert.ToDouble(ViewState["FAT"]); templtr = milkltr;; double mkg = templtr * 1.03; calcommission = (commission * templtr); } calbonus = bonus * templtr; } else { if ((commission < 0.20) && (commission > 0)) { double TEMPFAT = Convert.ToDouble(ViewState["FAT"]); templtr = milkltr; double mkg = templtr * 1.03; calcommission = (TEMPFAT * commission) * mkg; } if ((commission >= 0.20) && (commission > 0)) { double TEMPFAT = Convert.ToDouble(ViewState["FAT"]); templtr = milkltr; double mkg = templtr * 1.03; calcommission = (commission * mkg); } calbonus = bonus * templtr; } string TEMPCOMM; double getcart; double spbonus; string temprate; if (FAT >= minfat && SNF >= maxfat) { TEMPCOMM = calcommission.ToString("F2"); calcommission = Convert.ToDouble(TEMPCOMM); getcart = Convert.ToDouble(ViewState["cart"]); spbonus = Convert.ToDouble(ViewState["spbonus"]); calcart = getcart * milkltr; calspl = spbonus * milkltr; temprate = (RATE).ToString("f2"); RATE = Convert.ToDouble(temprate); if (RATE > 0) { amount = Convert.ToDouble(tempamount); } else { amount = 0; } } else { TEMPCOMM = "0"; calcommission = 0; getcart = 0; spbonus = 0; calcart = 0; calspl = 0; temprate = "0"; RATE = 0; amount = Convert.ToDouble(tempamount); } string finalinserting = " insert into procurement([Agent_id], [Prdate], [Sessions], [Milk_ltr], [Fat], [Snf], [Rate], [Amount], [Plant_Code], [Route_id], [NoofCans], [Milk_kg], [Clr], [Company_Code], [Ratechart_Id], [Milk_Nature], [ComRate], [SampleId], [Sampleno], [milk_tip_st_time], [milk_tip_end_time], [usr_weigher], [usr_analizer], [fat_kg], [snf_kg], [Truck_id],[Status],[CartageAmount],[SplBonusAmount],[RateStatus])values('" + Getagentid + "','" + prdate + "','" + Sessions + "','" + milkltr + "','" + FAT + "','" + SNF + "' ,'" + RATE + "','" + amount + "','" + pcode + "','" + Route_id + "','" + NoofCans + "','" + Milk_kg + "','" + Clr + "','" + ccode + "','" + CHARTID + "','" + Milk_Nature + "','" + calcommission + "','" + SampleId + "','" + SampleId + "','" + milk_tip_st_time + "','" + milk_tip_end_time + "','" + usr_weigher + "','" + usr_analizer + "','" + fat_kg + "','" + snf_kg + "','" + Truck_id + "','" + 0 + "','" + calcart + "','" + calspl + "',' " + ' ' + "')"; SqlCommand cmd143 = new SqlCommand(finalinserting, con); cmd143.ExecuteNonQuery(); COUNTI = 0; // rows = rows + 1; calcommission = 0; DTG.Tables.Clear(); } procurementimport(); if (procimport == procurement) { Response.Write("<script language='javascript'>alert('" + Server.HtmlEncode(MESS.save) + "')</script>"); } else { DateTime dt1 = new DateTime(); dt1 = DateTime.ParseExact(txt_FromDate.Text, "dd/MM/yyyy", null); //dt2 = DateTime.ParseExact(txt_ToDate.Text, "dd/MM/yyyy", null); string d1 = dt1.ToString("MM/dd/yyyy"); string delete; delete = "delete from procurement where plant_code='" + pcode + "' and prdate='" + d1 + "' AND Sessions='" + ddl_shift.SelectedItem.Text + "' "; con = DB.GetConnection(); SqlCommand cmd = new SqlCommand(delete, con); cmd.ExecuteNonQuery(); Response.Write("<script language='javascript'>alert('" + Server.HtmlEncode(MESS.Check) + "')</script>"); } } else { Response.Write("<script language='javascript'>alert('" + Server.HtmlEncode(MESS.Check) + "')</script>"); } }