public void BindDataToOwnControl(int Code)
{
Atend.Base.Design.DRemark Rem = Atend.Base.Design.DRemark.SelectByCode(Code);
//Atend.Base.Base.BProduct product = Atend.Base.Base.BProduct.Select_ByCode(breaker.ProductCode);
SelectedRemarkCode = Code;
//Atend.Control.Common.selectedProductCode = Rem.ProductCode;
//SelectProduct();
txtName.Text = Rem.Name;
if (Rem.File.Length > 0)
{
//MessageBox.Show("file exist");
file = Rem.File;
Stream st = new MemoryStream();
//MessageBox.Show(fileName);
File.Delete(fileName);
st = File.Create(fileName);
BinaryWriter binWriter = new BinaryWriter(st);
binWriter.Write((byte[])Rem.File);
binWriter.Close();
}
remarkCode = Rem.Code;
LoadTemplate();
//txtText.Text = Rem.Text;
Code = Rem.Code;
}
private void btnShow_Click(object sender, EventArgs e)
{
Atend.Base.Design.DRemark remark = Atend.Base.Design.DRemark.AccessSelectByCode(1);
if (remark.Code != -1)
{
//MessageBox.Show("record exist in db");
//load file
if (remark.File.Length > 0)
{
//MessageBox.Show("file exist");
file = remark.File;
Stream st = new MemoryStream();
//MessageBox.Show(fileName);
st = File.Create(fileName);
BinaryWriter binWriter = new BinaryWriter(st);
binWriter.Write((byte[])remark.File);
binWriter.Close();
}
remarkCode = remark.Code;
LoadTemplate();
}
else
{
//MessageBox.Show("no record");
}
}
public Atend.Report.dsSagAndTension FillRemark()
{
Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
Atend.Report.dsSagAndTension dsloadbranch = new Atend.Report.dsSagAndTension();
Atend.Base.Design.DRemark remark = Atend.Base.Design.DRemark.AccessSelectByCode(1);
if (remark.Code != -1)
{
DataRow drRemark = dsloadbranch.Tables["Remark"].NewRow();
drRemark["File"] = (byte[])remark.File;
dsloadbranch.Tables["Remark"].Rows.Add(drRemark);
//crRemark Remark = new crRemark();
//Remark.SetDataSource(dsloadbranch);
//crViewerRemark.ReportSource = Remark;
}
else
{
ed.WriteMessage("در Remark مقداری وجود ندارد\n");
}
DataRow dr1 = dsloadbranch.Tables["Title"].NewRow();
Atend.Base.Design.DDesignProfile designProfile = Atend.Base.Design.DDesignProfile.AccessSelect();
if (designProfile.Id != 0)
{
Atend.Base.Base.BRegion b12 = Atend.Base.Base.BRegion.SelectByCode(designProfile.Zone);
dr1["Area"] = b12.SecondCode;
System.Globalization.PersianCalendar p = new System.Globalization.PersianCalendar();
string _date = ChangeToShamsi(designProfile.DesignDate);
dr1["Date"] = _date; //desProfile.DesignDate.ToString();
dr1["Designer"] = designProfile.Designer;
dr1["ProjectName"] = designProfile.DesignName; //Atend.Control.Common.DesignName;
dr1["Credit"] = designProfile.Validate;
//dr1["SectionCount"] = arrSection.Count.ToString();
//dr1["PoleCount"] = CountPole.ToString();
if (System.IO.File.Exists(Atend.Control.ConnectionString.LogoPath))
{
System.IO.FileStream FS = new System.IO.FileStream(Atend.Control.ConnectionString.LogoPath, System.IO.FileMode.Open);
byte[] reader = new byte[FS.Length];
FS.Read(reader, 0, Convert.ToInt32(FS.Length));
dr1["Logo"] = reader;
FS.Close();
}
dr1["LogoName"] = Atend.Control.ConnectionString.LogoName;
dsloadbranch.Tables["Title"].Rows.Add(dr1);
}
else
{
MessageBox.Show("لطفا ابتدا مشخصات طرح را تکمیل نمایید", "اخطار");
return(null);
}
return(dsloadbranch);
}
//dsSagAndTension ds = new dsSagAndTension();
//public void SetDataset(dsSagAndTension Data)
//{
// ds = Data;
//}
private void frmRemarkReport_Load(object sender, EventArgs e)
{
Atend.Report.dsSagAndTension dsloadbranch = new Atend.Report.dsSagAndTension();
Atend.Base.Design.DRemark remark = Atend.Base.Design.DRemark.AccessSelectByCode(1);
if (remark.Code != -1)
{
DataRow drRemark = dsloadbranch.Tables["Remark"].NewRow();
drRemark["Name"] = remark.Name.ToString();
//MessageBox.Show(drRemark["Name"].ToString());
dsloadbranch.Tables["Remark"].Rows.Add(drRemark);
Atend.Base.Design.DDesignProfile designProfile = Atend.Base.Design.DDesignProfile.AccessSelect();
DataRow drDesign = dsloadbranch.Tables["Title"].NewRow();
drDesign["ProjectName"] = designProfile.DesignName;
drDesign["Designer"] = designProfile.Designer;
drDesign["Area"] = designProfile.Zone;
drDesign["Credit"] = designProfile.Validate;
System.Globalization.PersianCalendar p = new System.Globalization.PersianCalendar();
string _date = string.Format("{0}/{1}/{2}", p.GetYear(designProfile.DesignDate).ToString(), p.GetMonth(designProfile.DesignDate).ToString(), p.GetDayOfMonth(designProfile.DesignDate).ToString());
drDesign["Date"] = _date;
dsloadbranch.Tables["Title"].Rows.Add(drDesign);
crRemark02 Remark = new crRemark02();
Remark.SetDataSource(dsloadbranch);
crViewerRemark.ReportSource = Remark;
}
else
{
ed.WriteMessage("در Remark مقداری وجود ندارد\n");
}
}
private void Save()
{
//btnInsert.Focus();
ArrayList EPackageProduct = new ArrayList();
//Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
Atend.Base.Design.DRemark remark = new Atend.Base.Design.DRemark();
remark.File = null;
remark.Name = txtName.Text;
FileStream fs;
if (File.Exists(fileName))
{
string tempAddress = fileName.Replace("RemarkTemplate1.doc", "temp.doc");
File.Copy(fileName, tempAddress, true);
fs = new FileStream(tempAddress, FileMode.Open);
BinaryReader br = new BinaryReader(fs);
remark.File = br.ReadBytes((Int32)br.BaseStream.Length);
fs.Close();
fs.Dispose();
File.Delete(fileName);
}
else
{
remark.File = file;
}
if (SelectedRemarkCode == 0)
{
if (remark.Insert())
{
Reset();
}
else
{
MessageBox.Show("امکان ثبت اطلاعات نمی باشد", "خطا");
}
}
else
{
remark.Code = SelectedRemarkCode;
if (remark.Update())
{
Reset();
}
else
{
MessageBox.Show("امکان به روز رسانی اطلاعات نمی باشد", "خطا");
}
}
}
private void Save()
{
Atend.Base.Design.DRemark remark = new Atend.Base.Design.DRemark();
remark.Code = 1;
remark.File = null;
FileStream fs;
if (File.Exists(fileName))
{
string tempAddress = fileName.Replace("RemarkTemplate1.doc", "temp.doc");
File.Copy(fileName, tempAddress, true);
fs = new FileStream(tempAddress, FileMode.Open);
BinaryReader br = new BinaryReader(fs);
remark.File = br.ReadBytes((Int32)br.BaseStream.Length);
fs.Dispose();
}
else
{
remark.File = file;
}
if (remarkCode == -1)
{
if (remark.AccessInsert())
{
Reset();
}
else
{
MessageBox.Show("امکان ثبت اطلاعات نمی باشد", "خطا");
}
}
else
{
if (remark.AccessUpdate())
{
Reset();
}
else
{
MessageBox.Show("امکان به روز رسانی اطلاعات نمی باشد", "خطا");
}
}
}
