private void AutoID() { DateTime TglKontrak = Convert.ToDateTime(tglKontrak.Text); string[] j = (Cf.DaySlash1(tglKontrak.Text)).ToString().Split('/'); string Tahunkontrak = j[2]; string Tower = Db.SingleString("select Lokasi from ms_unit where nostock = '" + NoStock + "'"); int c = Db.SingleInteger("SELECT COUNT(NoKontrak) FROM MS_KONTRAK"); bool hasfound = false; while (!hasfound) { if (!Response.IsClientConnected) { break; } c++; nokontrak.Text = "SPU/" + Tower + "/" + Tahunkontrak + "/" + Cf.Roman(Convert.ToDateTime(tglKontrak.Text).Month) + "/" + c.ToString().PadLeft(5, '0'); if (isUnique()) { hasfound = true; } } }
private void Fill() { string strSql = "SELECT * FROM MS_BAST A INNER JOIN MS_KONTRAK B ON A.NoKontrak = B.NoKontrak " + "INNER JOIN MS_CUSTOMER C ON B.NoCustomer = C.NoCustomer" + " WHERE A.NoKontrak = '" + nomor + "'"; DataTable rs = Db.Rs(strSql); if (rs.Rows.Count != 0) { string[] SplitDate = Cf.DaySlash1(rs.Rows[0]["TglST"]).ToString().Split('/'); string Thns = SplitDate[2]; string Blns = SplitDate[1]; nomorl.Text = "BAST-" + Thns + Blns + rs.Rows[0]["NoST"].ToString(); //tgl.Text = Cf.Day(rs.Rows[0]["TglST"]); harist.Text = Cf.IndoWeek(Convert.ToDateTime(rs.Rows[0]["TglST"])); tglst.Text = Cf.Day(rs.Rows[0]["TglST"]); string[] Times = Cf.Time(rs.Rows[0]["TglST"]).ToString().Split(':'); string Jam = Times[0]; string Menit = Times[1]; jamst.Text = Jam + ":" + Menit; Namacs.Text = rs.Rows[0]["Nama"].ToString(); Alamatcs.Text = rs.Rows[0]["KTP1"].ToString(); ktpcs.Text = rs.Rows[0]["NoKTP"].ToString(); DataTable r = Db.Rs("SELECT * FROM MS_UNIT WHERE NoUnit = '" + rs.Rows[0]["NoUnit"].ToString() + "'"); if (r.Rows.Count != 0) { nounit1.Text = r.Rows[0]["NoUnit"].ToString(); lantai1.Text = r.Rows[0]["Lantai"].ToString(); nounit1.Text = r.Rows[0]["Nomor"].ToString(); tipe1.Text = r.Rows[0]["Jenis"].ToString(); luas1.Text = Cf.Num(r.Rows[0]["LuasSG"]).ToString(); semigross1.Text = Cf.Num(r.Rows[0]["LuasNett"]).ToString(); } } }