public void Fill()
{
VodomerDO vdo = new VodomerDO();
VodomerTypeDO vtdo = new VodomerTypeDO();
UniversalEntity ue = new UniversalEntity();
ue = vdo.RetrieveVodomerById(VodomerID);
if (ue.Count > 0)
{
_SN = ((Vodomer)ue[0]).FactoryNumber;
}
else
{
_SN = "";
}
ue = vtdo.RetrieveVodomerTypeByVodomerId(VodomerID);
if (ue.Count > 0)
{
_Diametr = ((VodomerType)ue[0]).Diameter;
}
else
{
_Diametr = 0;
}
}
protected void gvJournal_SelectedIndexChanged(object sender, EventArgs e)
{
VodomerType vt = new VodomerType();
VodomerTypeDO vtDO = new VodomerTypeDO();
UniversalEntity ue = new UniversalEntity();
ue = vtDO.RetrieveVodomerById(Utilities.ConvertToInt(gvJournal.SelectedDataKey.Value.ToString()));
if (ue.Count > 0)
{
vt = (VodomerType)ue[0];
}
ddlDiameter1.SelectedValue = vt.Diameter.ToString();
ddlSeller.SelectedValue = vt.SellerID.ToString();
BindModels(vt.SellerID);
ddlModel.SelectedValue = vt.ID.ToString();
tbVodomerSearch.Text = "";
gvJournal.DataBind();
panVodomerSearch.Visible = false;
Step2.CssClass = "";
}
//Привязка моделей водомеров
void BindModels(int id)
{
if (id > 0)
{
ddlModel.Items.Clear();
VodomerType v = new VodomerType();
VodomerTypeDO vdo = new VodomerTypeDO();
UniversalEntity ue = new UniversalEntity();
int diameter = Convert.ToInt32(ddlDiameter1.SelectedValue);
ue = vdo.RetrieveVodomerTypeBySellerIdAndDiameter(id, diameter);
ddlModel.Items.Add(new ListItem("Модель", "0"));
for (int i = 0; i < ue.Count; i++)
{
v = (VodomerType)ue[i];
ddlModel.Items.Add(new ListItem(v.ConventionalSignth + " " + v.Description + " " + v.Diameter.ToString(), v.ID.ToString()));
}
}
else
{
ddlModel.Items.Clear();
}
}
protected void lbSave_Click(object sender, EventArgs e)
{
VodomerType vt;
VodomerTypeDO vtDO = new VodomerTypeDO();
int rez = 0;
vt = Collect();
if (Validate())
{
rez = vtDO.CreateVodomerType(vt);
if (rez > 0)
{
SetMessege("Уведомление", "Тип водомера успешно добавлен.");
// nlTypeAdd.SetCleanNotification("Тип водомера успешно добавлен.");
}
else
{
SetMessege("Уведомление", "Произошла ошибка при добавлении типа водомера.");
//nlTypeAdd.SetDirtyNotification("");
}
}
}
//Генерация договора
protected void btContract_Click(object sender, EventArgs e)
{
UniversalEntity ue = new UniversalEntity();
UniversalEntity uev = new UniversalEntity();
int id = Convert.ToInt32(hfODID.Value);
UAbonent ua = new UAbonent();
UAbonentDO uado = new UAbonentDO();
ue = uado.RetrieveByOrderID(id);
UOrderDetailsDO uoddo = new UOrderDetailsDO();
VodomerTypeDO vtdo = new VodomerTypeDO();
VodomerType vt;
UOrderDetails uod;
if (ue.Count > 0)
{
double sum = 0;
double sumvat = 0;
string vodomer = string.Empty;
ua = (UAbonent)ue[0];
ue = uoddo.RetrieveUOrderDetailsByOrderID(id);
if (ue.Count > 0)
{
for (int i = 0; i < ue.Count; i++)
{
uod = (UOrderDetails)ue[i];
sum += uod.GetPriceWithVAT();
sumvat += uod.GetPriceVAT();
uev = vtdo.RetrieveVodomerTypeByVodomerId(uod.VodomerID);
if (uev.Count > 0)
{
for (int j = 0; j < uev.Count; j++)
{
vt = (VodomerType)uev[j];
vodomer += "Поверить " + vt.Description + " Ø " + vt.Diameter.ToString() + " мм в количестве 1 шт., ";
}
}
}
}
UOrder uo = new UOrder();
UOrderDO uoDO = new UOrderDO();
ue = uoDO.RetrieveUOrderById(id);
if (ue.Count > 0)
{
uo = (UOrder)ue[0];
}
if (ua.IsBudget)
{
//Для бюджетных организаций
using (DocX document = DocX.Load(Request.MapPath("~\\Templates/noncommerce.docx")))
{
//DocXExtender.ReplaceFormatedText(document, "DDD", "дата");
document.ReplaceText("NNN", uo.ID.ToString(), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("DATE", RuDateAndMoneyConverter.DateToTextLong(uo.DateIn) + " г.", false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("TITLE", ua.Title, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("VODOMER", vodomer, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("SUM", RuDateAndMoneyConverter.CurrencyToTxt(sum, true), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("NDS", RuDateAndMoneyConverter.CurrencyToTxt(sumvat, true), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("SSS", (sum).ToString("0.00") + " грн", false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("RS", ua.RS, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("BANK", ua.Bank, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("MFO", ua.MFO, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("OKPO", ua.OKPO, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("ADDRESS", ua.Address, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("FACE", ua.ContactFace, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("CAUSE", ua.Cause, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("PHONE", ua.Phone, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
//TAXTYPE
document.ReplaceText("TAXTYPE", ua.TaxType, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
//VODOMER
document.SaveAs(Request.MapPath("~\\Templates/outnoncommerce.docx"));
litScript.Text = "<iframe style=\"display:none;\" src=\"../GetDocument.ashx?Commerce=1\"></iframe>";
}
}
else
{
//для небюджетных организаций
using (DocX document = DocX.Load(Request.MapPath("~\\Templates/commerce.docx")))
{
//DocXExtender.ReplaceFormatedText(document, "DDD", "дата");
document.ReplaceText("NNN", uo.ID.ToString(), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("DATE", RuDateAndMoneyConverter.DateToTextLong(uo.DateIn) + " г.", false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("TITLE", ua.Title, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("VODOMER", vodomer, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("SUM", RuDateAndMoneyConverter.CurrencyToTxt(sum, true), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("NDS", RuDateAndMoneyConverter.CurrencyToTxt(sumvat, true), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("RS", ua.RS, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("BANK", ua.Bank, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("MFO", ua.MFO, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("OKPO", ua.OKPO, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("ADDRESS", ua.Address, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("FACE", ua.ContactFace, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("CAUSE", ua.Cause, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("PHONE", ua.Phone, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("TAXTYPE", ua.TaxType, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
//VODOMER
document.SaveAs(Request.MapPath("~\\Templates/outcommerce.docx"));
litScript.Text = "<iframe style=\"display:none;\" src=\"../GetDocument.ashx?Commerce=0\"></iframe>";
}
}
}
}
