void gridViewOperation_BeforeInsert(object render, ObjectOperationEventArgs<BD_SBTZ> e)
{
e.Cancel = true;
try
{
frmSBTZ frm = gridViewOperation.EditForm as frmSBTZ;
PS_Image image = null;
if (frm.GetImage() != null)
{
image = new PS_Image();
image.ImageName = "变电设备照片";
image.ImageType = "sdsb";
image.ImageData = (byte[])frm.GetImage();
e.Value.c3 = image.ImageID;
Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(new object[] { e.Value, image }, null, null);
}
else
{
Client.ClientHelper.PlatformSqlMap.Create<BD_SBTZ>(e.Value);
}
gridViewOperation.BindingList.Add(e.Value);
}
catch (Exception err) { throw err; }
}
void gridViewOperation_BeforeUpdate(object render, ObjectOperationEventArgs<PS_gt> e) {
e.Cancel = true;
try {
PS_gt gt =e.Value;
frmgtEdit frm = gridViewOperation.EditForm as frmgtEdit;
PS_Image image = frm.GetPS_Image();
if (frm.GetImage() != null ) {
if (gt.ImageID == "" || image==null) {
image = new PS_Image();
image.ImageName = "杆塔照片";
image.ImageType = "gt";
image.ImageData = (byte[])frm.GetImage();
gt.ImageID = image.ImageID;
Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(image, gt, null);
} else {
Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(null,new object[] { gt, image }, null);
}
} else {
Client.ClientHelper.PlatformSqlMap.Update<PS_gt>(e.Value);
}
Ebada.Core.ConvertHelper.CopyTo(gt, e.ValueOld);
} catch (Exception err) { throw err; }
}
public string UpdateGtImage3(string id, string data, string type) {
string msg = "";
PS_Image image = new PS_Image() { ImageID = id, ImageType = "bd" };
image.ImageData = Convert.FromBase64String(data);
PS_Image image2 = new PS_Image() { ImageID = id };
sd_gt gt = Client.ClientHelper.PlatformSqlMap.GetOneByKey<sd_gt>(id);
object update = null;
object delete = image2;
if (gt != null && gt.ImageID != id) {
if (gt.ImageID != "") {
delete = new PS_Image() { ImageID = gt.ImageID };
delete = new object[] { image2, delete };
}
gt.ImageID = id;
update = gt;
}
Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(image, update, delete);
return msg;
}
public string UpdateGtImage3(string id, byte[] data, string type) {
string msg = "";
PS_Image image = new PS_Image() { ImageID = id, ImageType = "bd" };
image.ImageData = data;
PS_Image image2 = new PS_Image() { ImageID = id };
BD_SBTZ gt = Client.ClientHelper.PlatformSqlMap.GetOneByKey<BD_SBTZ>(id);
object update = null;
object delete = image2;
Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(image, update, delete);
return msg;
}
public string UpdateGtImage(List<ps_image> list) {
ps_image data = list[0];
string msg = "";
PS_Image image = new PS_Image() { ImageID = data.id, ImageType = "bd" };
image.ImageData = Convert.FromBase64String(data.data);
PS_Image image2 = new PS_Image() { ImageID = data.id };
Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(image, null, image2);
return msg;
}
private void gettemp() {
if (temp35Image != null) return;
sd_gt gt = Client.ClientHelper.PlatformSqlMap.GetOneByKey<sd_gt>(temp35gtid);
if (gt != null)
temp35Image = Client.ClientHelper.PlatformSqlMap.GetOneByKey<PS_Image>(gt.ImageID);
if (temp35Image != null) tempID = temp35Image.ImageID;
}
private void btAddM_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) {
if (parentID == null)
return;
PS_gt gt = new PS_gt();
gt.gth = getGgh();
gt.gtCode = ParentObj.LineCode + gt.gth;
gt.gtSpan = 50;
gt.gtMs = 1.7m;
gt.gtHeight = 10m;
gt.gtNode = "否";
gt.gtModle = "直线杆";
gt.gtType = "混凝土拔梢杆";
frmgtEdit frm = new frmgtEdit();
frm.RowData = gt;
frm.MultipleAdd = true;//批量增加
if (frm.ShowDialog() == DialogResult.OK) {
gt = frm.RowData as PS_gt;
int num = frm.MultipleNum;//批量增加杆塔数
int gh = int.Parse(gt.gth);
int count = num;
PS_Image image = null;
if (frm.GetImage() != null) {
count++;
image = new PS_Image();
image.ImageName = "杆塔照片";
image.ImageType = "gt";
image.ImageData = (byte[])frm.GetImage();
gt.ImageID = image.ImageID;
}
object[] gts = new object[count];
if (image != null)
gts[count - 1] = image;
gt.LineCode = ParentObj.LineCode;
string id = DateTime.Now.ToString("yyyyMMddHHmmss");
for (int i = 0; i < num; i++) {
PS_gt newgt = new PS_gt();
Ebada.Core.ConvertHelper.CopyTo(gt, newgt);
string gth = (gh + 10 * i).ToString("0000");
newgt.gth = gth;
newgt.gtID=newgt.gtCode = newgt.LineCode + gth;
newgt.gtID+= mRandom.Next(10, 99);
gts[i] = newgt;
}
Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(gts, null, null);
gridViewOperation.BindingList.Add(gts);
}
}
public void ShowDialogSD(GMapMarker marker) {
frmsdgtEdit frm = new frmsdgtEdit();
sd_gt gt0 = marker.Tag as sd_gt;
GMapMarkerVector pm = (marker as GMapMarkerVector).ParentMarker;
if (pm != null) {
gt0.gtSpan = (decimal)Math.Round(control.Manager.GetDistance(pm.Position, marker.Position) * 1000, 1);
}
sd_gt gt2 = new sd_gt();
Ebada.Core.ConvertHelper.CopyTo(gt0, gt2);
frm.RowData = gt2;
frm.ShowTab2 = true;
if (frm.ShowDialog() == System.Windows.Forms.DialogResult.OK && allowEdit) {
Ebada.Core.ConvertHelper.CopyTo(frm.RowData, gt0);
sd_gt gt = gt0;
PS_Image image = frm.GetPS_Image();
if (frm.GetImage() != null) {
if (gt.ImageID == "" || image == null) {
image = new PS_Image();
image.ImageName = "杆塔照片";
image.ImageType = "gt";
image.ImageData = (byte[])frm.GetImage();
gt.ImageID = image.ImageID;
Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(image, gt, null);
} else {
Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(null, new object[] { gt, image }, null);
}
} else {
Client.ClientHelper.PlatformSqlMap.Update<sd_gt>(gt);
}
marker.Position = new PointLatLng((double)gt.gtLat, (double)gt.gtLon);
OnMarkerChanged(marker as GMapMarkerVector);
}
}
private bool savefile(string filename, PS_Image pic) {
string filepath = buttonEdit1.Text + "\\" + filename+".jpg";
MemoryStream ms = new MemoryStream(pic.ImageData);
bool flag = true;
try {
FileStream fs = new FileStream(filepath, FileMode.OpenOrCreate);
fs.Write(pic.ImageData, 0, pic.ImageData.Length);
} catch (Exception err) { flag = false; writeLine(filename+".jpg,写入异常："+err.Message); }
return flag;
}
void pictureEdit1_EditValueChanged(object sender, EventArgs e)
{
imageData = pictureEdit1.EditValue;
if (imageData == null) {
imageData = new byte[] { 0 };
if (image != null)
ClientHelper.PlatformSqlMap.DeleteByKey<PS_Image>(image.ImageID);
rowData.c3 = "";
image = null;
} else {
if (image == null)
image = new PS_Image();
image.ImageData = (byte[])imageData;
}
}
void gridViewOperation_BeforeUpdate(object render, ObjectOperationEventArgs<BD_SBTZ> e)
{
e.Cancel = true;
try
{
BD_SBTZ sdsb = e.Value;
frmSBTZ frm = gridViewOperation.EditForm as frmSBTZ;
PS_Image image = frm.GetPS_Image();
if (frm.GetImage() != null)
{
if (sdsb.c3 == "" || image == null || sdsb.c3!=image.ImageID)
{
image = new PS_Image();
image.ImageName = "变电设备照片";
image.ImageType = "bd";
image.ImageData = (byte[])frm.GetImage();
sdsb.c3 = image.ImageID;
Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(image, sdsb, null);
}
else
{
Client.ClientHelper.PlatformSqlMap.ExecuteTransationUpdate(null, new object[] { sdsb, image }, null);
}
}
else {
Client.ClientHelper.PlatformSqlMap.Update<BD_SBTZ>(e.Value);
}
Ebada.Core.ConvertHelper.CopyTo(sdsb, e.ValueOld);
//RefreshData();
}
catch (Exception err) { throw err; }
}
