// ======================================================================================
void InsertRecord(object sender, GridRecordEventArgs e)
{
string RabDat;
RabDat = Convert.ToString(e.Record["AMBDAT"]);
if (string.IsNullOrEmpty(RabDat))
{
AmbDat = DateTime.Now;
}
else
{
AmbDat = DateTime.Parse(RabDat);
}
RabDat = Convert.ToString(e.Record["AMBBEG"]);
if (string.IsNullOrEmpty(RabDat))
{
AmbBeg = DateTime.Now.ToString("dd.MM.yyyy HH:mm:ss");
}
else
{
AmbBeg = RabDat;
}
AmbDat = Convert.ToDateTime(e.Record["AMBDAT"]);
AmbPth = Convert.ToString(e.Record["AMBPTH"]);
AmbTel = Convert.ToString(e.Record["AMBTEL"]);
AmbUsl = Convert.ToInt32(e.Record["AMBUSL"]);
AmbZen = Convert.ToInt32(e.Record["AMBZEN"]);
AmbKod = Convert.ToInt32(e.Record["AMBKOD"]);
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.AmbCrdTabAdd(MdbNam, BuxSid, BuxFrm, AmbKod, AmbDat, AmbBeg, AmbPth, AmbTel, AmbUsl, AmbZen);
getGrid();
}
void DeleteRecord(object sender, GridRecordEventArgs e)
{
OrgKod = Convert.ToInt32(e.Record["ORGKOD"]);
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.ComSprOrgDel(MdbNam, BuxSid, OrgKod);
getGrid();
}
// ============================ чтение таблицы а оп ==============================================
void getGrid()
{
/*
* // создание DataSet.
* DataSet ds = new DataSet();
* string connectionString = WebConfigurationManager.ConnectionStrings[MdbNam].ConnectionString;
* // создание соединение Connection
* SqlConnection con = new SqlConnection(connectionString);
* con.Open();
*
* // создание команды
* SqlCommand cmd = new SqlCommand("SELECT * FROM SPRORG ORDER BY ORGNAM", con);
* // создание DataAdapter
* SqlDataAdapter da = new SqlDataAdapter(cmd);
* // заполняем DataSet из хран.процедуры.
* da.Fill(ds, "ComSprOrg");
* GridOrg.DataSource = ds;
* GridOrg.DataBind();
*
* // -----------закрыть соединение --------------------------
* ds.Dispose();
* con.Close();
*/
localhost.Service1Soap ws = new localhost.Service1SoapClient();
DataSet ds = new DataSet("SprOrg");
ds.Merge(ws.ComSprOrg(MdbNam, BuxSid, BuxFrm));
GridOrg.DataSource = ds;
GridOrg.DataBind();
}
//------------------------------------------------------------------------
private string getBox003()
{
DataSet ds = new DataSet("Menu");
localhost.Service1Soap ws = new localhost.Service1SoapClient();
if (BoxDoc003.SelectedValue == "")
{
GrfDlg = 0;
}
else
{
GrfDlg = Convert.ToInt32(BoxDoc003.SelectedValue);
}
if (BoxFio003.SelectedValue == "")
{
GrfKod = 0;
}
else
{
GrfKod = Convert.ToInt32(BoxFio003.SelectedValue);
}
ds.Merge(ws.RefGlvScr(MdbNam, BuxSid, BuxFrm, GrfDlg, GrfKod, GlvBegDat, GlvEndDat));
grid03.DataSource = ds;
grid03.DataBind();
return("");
}
void DeleteRecord2(object sender, GridRecordEventArgs e)
{
NgrIdn = Convert.ToInt32(e.Record["NGRIDN"]);
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.ComSprKdrNgrDel(MdbNam, BuxSid, NgrIdn);
getGrid2();
}
// ============================ одобрение для записи документа в базу ==============================================
protected void btnOK_click(object sender, EventArgs e)
{
int NodLvl;
int NodVal;
NodVal = Convert.ToInt32(OboutTree.SelectedNode.Value);
NodLvl = OboutTree.SelectedNode.Level;
ConfirmDialog.Visible = false;
ConfirmDialog.VisibleOnLoad = false;
// GlvBegDat = (DateTime)Session["GlvBegDat"];
// GlvEndDat = (DateTime)Session["GlvEndDat"];
Session["GlvBegDat"] = DateTime.Parse(txtDate1.Text);
Session["GlvEndDat"] = DateTime.Parse(txtDate2.Text);
GlvBegDat = DateTime.Parse(txtDate1.Text);
GlvEndDat = DateTime.Parse(txtDate2.Text);
if (NodLvl == 1)
{
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.ComSprGrfDocCmpAll(MdbNam, BuxSid, BuxFrm, NodVal, GlvBegDat, GlvEndDat);
}
// getPostBackControlName();
}
void DeleteRecord(object sender, GridRecordEventArgs e)
{
IdnSpr = Convert.ToInt32(e.Record["SPRIDN"]);
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.ComSpr000Del(MdbNam, BuxSid, NumSpr, IdnSpr);
getGrid();
}
//============= удаление записи после опроса ===========================================================================================
void DeleteRecord(object sender, GridRecordEventArgs e)
{
AmbIdn = Convert.ToInt32(e.Record["AMBIDN"]);
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.AmbCrdTabDel(MdbNam, BuxSid, AmbIdn);
getGrid();
}
// ============================ одобрение для записи документа в базу ==============================================
protected void btnOK_click(object sender, EventArgs e)
{
GlvDocIdn = Convert.ToInt32(Session["GLVDOCIDN"]);
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.AptPrxDocAddRep(MdbNam, BuxSid, BuxFrm, GlvDocTyp, GlvDocIdn, DOCNUM.Text, DOCDAT.Text, BoxOrg.SelectedValue, BuxKod);
Response.Redirect("~/Prof/BuxDoc.aspx?NumSpr=ПРФ&TxtSpr=ПРОФОСМОТР");
}
void DeleteRecord(object sender, GridRecordEventArgs e)
{
MolIdn = Convert.ToInt32(e.Record["MolIdn"]);
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.ComSprMolDel(MdbNam, BuxSid, MolIdn);
getGrid();
}
//============= удаление записи после опроса ===========================================================================================
void DeleteRecord(object sender, GridRecordEventArgs e)
{
int GlvDocIdn;
GlvDocIdn = Convert.ToInt32(e.Record["DOCIDN"]);
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.ComDocDel(MdbNam, BuxSid, GlvDocIdn);
getGrid();
}
// ============================ чтение таблицы а оп ==============================================
void getGrid()
{
localhost.Service1Soap ws = new localhost.Service1SoapClient();
DataSet ds = new DataSet("Spr000");
ds.Merge(ws.ComSpr000(MdbNam, BuxSid, NumSpr));
GridSpr.DataSource = ds;
GridSpr.DataBind();
}
// ======================================================================================
void InsertRecord(object sender, GridRecordEventArgs e)
{
KodSpr = Convert.ToInt32(e.Record["SPRKOD"]);
NamSpr = Convert.ToString(e.Record["SPRNAM"]);
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.ComSpr000Add(MdbNam, BuxSid, NumSpr, KodSpr, NamSpr);
getGrid();
}
// ============================ чтение таблицы а оп ==============================================
void getGrid()
{
localhost.Service1Soap ws = new localhost.Service1SoapClient();
DataSet ds = new DataSet("Spr000");
ds.Merge(ws.AmbCrdTab(MdbNam, BuxSid, BuxFrm, GlvBegDat, GlvEndDat));
Grid1.DataSource = ds;
Grid1.DataBind();
}
// ============================ чтение таблицы а оп ==============================================
void getGrid()
{
localhost.Service1Soap ws = new localhost.Service1SoapClient();
DataSet ds = new DataSet("SprMol");
ds.Merge(ws.ComSprMol(MdbNam, BuxSid, BuxFrm));
GridMol.DataSource = ds;
GridMol.DataBind();
}
void InsertRecord(object sender, GridRecordEventArgs e)
{
MolTab = Convert.ToInt32(e.Record["MolTab"]);
MolOtd = Convert.ToInt32(e.Record["MolOtd"]);
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.ComSprMolAdd(MdbNam, BuxSid, BuxFrm, MolTab, MolOtd);
getGrid();
}
// ======================================================================================
void UpdateRecord(object sender, GridRecordEventArgs e)
{
ParNum = Convert.ToInt32(e.Record["PARNUM"]);
ParVal = Convert.ToString(e.Record["PARVAL"]);
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.ComSprParRep(MdbNam, BuxFrm, BuxSid, ParNum, ParVal);
getGrid();
}
// ============================ чтение таблицы а оп ==============================================
void getGrid()
{
localhost.Service1Soap ws = new localhost.Service1SoapClient();
DataSet ds = new DataSet("SprPar");
ds.Merge(ws.ComSprPar(MdbNam, BuxFrm, BuxSid));
grid1.DataSource = ds;
grid1.DataBind();
}
protected void PushButton_Click(object sender, EventArgs e)
{
string GlvBegDatTxt;
string GlvEndDatTxt;
string TekDocTyp;
Session["GlvBegDat"] = DateTime.Parse(txtDate1.Text);
Session["GlvEndDat"] = DateTime.Parse(txtDate2.Text);
if (GlvDocTyp == "ЛБР")
{
TekDocTyp = "ЛАБ";
}
else
{
TekDocTyp = GlvDocTyp;
}
GlvBegDat = (DateTime)Session["GlvBegDat"];
GlvEndDat = (DateTime)Session["GlvEndDat"];
GlvBegDatTxt = Convert.ToDateTime(Session["GlvBegDat"]).ToString("dd.MM.yyyy");
GlvEndDatTxt = Convert.ToDateTime(Session["GlvEndDat"]).ToString("dd.MM.yyyy");
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.ComGlvBegEndDat(MdbNam, BuxSid, GlvBegDat, GlvEndDat);
/*
* // ============================ посуммировать ==============================================
* string connectionString = WebConfigurationManager.ConnectionStrings[MdbNam].ConnectionString;
* // создание соединение Connection
* SqlConnection con = new SqlConnection(connectionString);
* // создание команды
* SqlCommand cmd = new SqlCommand("HspDocAppLstSum", con);
* // указать тип команды
* cmd.CommandType = CommandType.StoredProcedure;
* // передать параметр
* cmd.Parameters.Add("@BUXFRM", SqlDbType.VarChar).Value = BuxFrm;
* cmd.Parameters.Add("@BUXKOD", SqlDbType.VarChar).Value = BoxDoc.SelectedIndex;
* cmd.Parameters.Add("@GLVDOCTYP", SqlDbType.VarChar).Value = TekDocTyp;
* cmd.Parameters.Add("@GLVBEGDAT", SqlDbType.VarChar).Value = GlvBegDatTxt;
* cmd.Parameters.Add("@GLVENDDAT", SqlDbType.VarChar).Value = GlvEndDatTxt;
* // Выполнить команду
* con.Open();
*
* cmd.ExecuteNonQuery();
*
* con.Close();
* // ============================ посуммировать ==============================================
*/
getGrid();
}
// ============================ чтение таблицы а оп ==============================================
void getGrid()
{
GlvBegDat = (DateTime)Session["GlvBegDat"];
GlvEndDat = (DateTime)Session["GlvEndDat"];
localhost.Service1Soap ws = new localhost.Service1SoapClient();
DataSet ds = new DataSet("Spr000");
ds.Merge(ws.ComDocGet(MdbNam, BuxSid, BuxFrm, GlvDocTyp, GlvBegDat, GlvEndDat));
GridDoc.DataSource = ds;
GridDoc.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
//=====================================================================================
OrgNam = Convert.ToString(Request.QueryString["OrgNam"]);
LogNam = Convert.ToString(Request.QueryString["LogNam"]);
PswNam = Convert.ToString(Request.QueryString["PswNam"]);
//============= начало ===========================================================================================
if (IsPostBack)
{
if (parOtmBut.Value == "OkBut" || parOtmBut.Value == "OtmBut")
{
HttpContext.Current.Response.Redirect("/Default.aspx");
}
if (txtPswNamNew001.Text == txtPswNamNew002.Text && txtPswNamNew001.Text.Length > 0)
{
PswNamNew = txtPswNamNew002.Text;
localhost.Service1Soap ws = new localhost.Service1SoapClient();
DataSet ds = new DataSet("Login");
ds.Merge(ws.ComUpdUsrPsw(MdbNam, OrgNam, LogNam, PswNam, PswNamNew));
try
{
loginDialog.Visible = true;
succeedNotice.Visible = true;
// HttpContext.Current.Response.Redirect("/Default.aspx");
}
catch
{
//Wrong password
txtPswNamNew001.Text = "";
txtPswNamNew002.Text = "";
loginDialog.Visible = true;
failNotice.Visible = true;
}
}
else
{
//Wrong password
txtPswNamNew001.Text = "";
txtPswNamNew002.Text = "";
loginDialog.Visible = true;
failNotice.Visible = true;
}
}
else
{
txtPswNamNew001.Text = "";
txtPswNamNew002.Text = "";
}
}
void UpdateRecord(object sender, GridRecordEventArgs e)
{
MolIdn = Convert.ToInt32(e.Record["MolIdn"]);
MolTab = Convert.ToInt32(e.Record["MolTab"]);
MolOtd = Convert.ToInt32(e.Record["MolOtd"]);
MolUbl = Convert.ToBoolean(e.Record["MolUbl"]);
// MolLog = Convert.ToString(e.Record["MolLog"]);
// MolPsw = Convert.ToString(e.Record["MolPsw"]);
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.ComSprMolRep(MdbNam, BuxSid, MolIdn, MolTab, MolOtd, MolUbl);
getGrid();
}
protected void PushButton_Click(object sender, EventArgs e)
{
Session["GlvBegDat"] = DateTime.Parse(txtDate1.Text);
Session["GlvEndDat"] = DateTime.Parse(txtDate2.Text);
GlvBegDat = (DateTime)Session["GlvBegDat"];
GlvEndDat = (DateTime)Session["GlvEndDat"];
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.ComGlvBegEndDat(MdbNam, BuxSid, GlvBegDat, GlvEndDat);
getGrid();
}
protected void PushButton_Click(object sender, EventArgs e)
{
string GlvBegDatTxt;
string GlvEndDatTxt;
Session["GlvBegDat"] = DateTime.Parse(txtDate1.Text);
Session["GlvEndDat"] = DateTime.Parse(txtDate2.Text);
GlvBegDat = (DateTime)Session["GlvBegDat"];
GlvEndDat = (DateTime)Session["GlvEndDat"];
GlvBegDatTxt = Convert.ToDateTime(Session["GlvBegDat"]).ToString("dd.MM.yyyy");
GlvEndDatTxt = Convert.ToDateTime(Session["GlvEndDat"]).ToString("dd.MM.yyyy");
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.ComGlvBegEndDat(MdbNam, BuxSid, GlvBegDat, GlvEndDat);
getGrid();
}
void UpdateRecord(object sender, GridRecordEventArgs e)
{
string RabDat;
RabDat = Convert.ToString(e.Record["AMBDAT"]);
if (string.IsNullOrEmpty(RabDat))
{
AmbDat = DateTime.Now;
}
else
{
AmbDat = DateTime.Parse(RabDat);
}
RabDat = Convert.ToString(e.Record["AMBBEG"]);
if (string.IsNullOrEmpty(RabDat))
{
AmbBeg = DateTime.Now.ToString("dd.MM.yyyy HH:mm:ss");
}
else
{
AmbBeg = RabDat;
}
// AmbUslTxt = Convert.ToString(USLNAMHID.Value);
// int Index = AmbUslTxt.IndexOf(@">");
// if (Index == -1) AmbUsl = 0;
// else AmbUsl = Convert.ToInt32(AmbUslTxt.Substring(0, Index));
AmbIdn = Convert.ToInt32(e.Record["AMBIDN"]);
AmbDat = Convert.ToDateTime(e.Record["AMBDAT"]);
AmbPth = Convert.ToString(e.Record["AMBPTH"]);
AmbTel = Convert.ToString(e.Record["AMBTEL"]);
AmbUsl = Convert.ToInt32(e.Record["AMBUSL"]);
AmbZen = Convert.ToInt32(e.Record["AMBZEN"]);
AmbKod = Convert.ToInt32(e.Record["AMBKOD"]);
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.AmbCrdTabRep(MdbNam, BuxSid, AmbIdn, AmbKod, AmbDat, AmbBeg, AmbPth, AmbTel, AmbUsl, AmbZen);
getGrid();
}
void UpdateRecord2(object sender, GridRecordEventArgs e)
{
string NgrDatTxt;
NgrIdn = Convert.ToInt32(e.Record["NGRIDN"]);
NgrNam = Convert.ToString(e.Record["NGRNAM"]);
NgrDatTxt = Convert.ToString(e.Record["NGRDAT"]);
if (string.IsNullOrEmpty(NgrDatTxt))
{
NgrDatTxt = DateTime.Now.ToString("dd.MM.yyyy");
}
else
{
NgrDatTxt = Convert.ToDateTime(e.Record["NGRDAT"]).ToString("dd.MM.yyyy");
}
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.ComSprKdrNgrRep(MdbNam, BuxSid, NgrIdn, NgrNam, NgrDatTxt);
getGrid2();
}
void UpdateRecord2(object sender, GridRecordEventArgs e)
{
string EduDatTxt;
EduIdn = Convert.ToInt32(e.Record["EDUIDN"]);
EduNam = Convert.ToString(e.Record["EDUNAM"]);
EduDatTxt = Convert.ToString(e.Record["EDUDIPDAT"]);
if (string.IsNullOrEmpty(EduDatTxt))
{
EduDatTxt = DateTime.Now.ToString("dd.MM.yyyy");
}
else
{
EduDatTxt = Convert.ToDateTime(e.Record["EDUDIPDAT"]).ToString("dd.MM.yyyy");
}
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.ComSprKdrEduRep(MdbNam, BuxSid, EduIdn, EduNam, EduDatTxt);
getGrid2();
}
// ======================================================================================
void InsertRecord(object sender, GridRecordEventArgs e)
{
// OrgKod = Convert.ToInt32(e.Record["ORGKOD"]);
OrgNam = Convert.ToString(e.Record["ORGNAM"]);
OrgNamShr = Convert.ToString(e.Record["ORGNAMSHR"]);
OrgAdr = Convert.ToString(e.Record["ORGADR"]);
OrgBin = Convert.ToString(e.Record["ORGBIN"]);
OrgBik = Convert.ToString(e.Record["ORGBIK"]);
OrgIik = Convert.ToString(e.Record["ORGIIK"]);
OrgNdc = Convert.ToString(e.Record["ORGNDC"]);
OrgKnp = Convert.ToString(e.Record["ORGKNP"]);
OrgLat = "";
OrgLng = "";
OrgDogNum = Convert.ToString(e.Record["ORGDOGNUM"]);
OrgDogPnt = Convert.ToString(e.Record["ORGDOGPNT"]);
OrgRukFio = Convert.ToString(e.Record["ORGRUKFIO"]);
OrgBuxFio = Convert.ToString(e.Record["ORGBUXFIO"]);
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.ComSprOrgAdd(MdbNam, BuxSid, BuxFrm, OrgNam, OrgNamShr, OrgAdr, OrgBin, OrgBik, OrgIik, OrgNdc, OrgKnp, OrgLat, OrgLng, OrgDogNum, OrgDogPnt, OrgRukFio, OrgBuxFio);
getGrid();
}
// ======================================================================================
//------------------------------------------------------------------------KLTADR
void UpdateRecordXX(object sender, GridRecordEventArgs e)
{
int GrfIdn;
Boolean GrfBus;
int GrfKolZap;
GrfIdn = Convert.ToInt32(e.Record["GRFIDN"]);
GrfBus = Convert.ToBoolean(e.Record["GRFBUS"]);
// if (parKol.Value == "0" || parKol.Value == "") GrfKolZap = 1;
// else GrfKolZap = Convert.ToInt32(parKol.Value);
GrfKolZap = 1;
localhost.Service1Soap ws = new localhost.Service1SoapClient();
if (parUpd.Value == "0")
{
ws.RefGlvScrRep(MdbNam, BuxSid, BuxFrm, GrfIdn, GrfBus, FndFio.Text, "", FndTel.Text, "", GrfKolZap);
}
else
{
ws.RefGlvScrRepBus(MdbNam, BuxSid, BuxFrm, GrfIdn);
}
if (parPnl.Value == "1")
{
getBox001();
}
if (parPnl.Value == "2")
{
getBox002();
}
if (parPnl.Value == "3")
{
getBox003();
}
}
// ============================ проводить записи документа в базу ==============================================
protected void btnPrvOK_click(object sender, EventArgs e)
{
localhost.Service1Soap ws = new localhost.Service1SoapClient();
ws.AptPrxDocPrv(MdbNam, BuxSid, BuxFrm, GlvDocIdn, BuxKod);
Response.Redirect("~/Priem/DocAppLabUpl.aspx?NumSpr=Л01&TxtSpr=БИОХИМЧЕСКИЙ АНАЛИЗАТОР");
}
