protected void BtnAddDeliveryMethod_Click(object sender, EventArgs e)
{
UpdateRow update;
bool IsDelivewry;
string Dir;
string CCom;
string CReg;
if (HdnTypeDeliverySelected.Value == "despacho")
{
IsDelivewry = true;
Dir = TxtMdlDeliveryDir.Text;
CCom = DDLMdlDeliveryCom.SelectedValue;
CReg = DDLMdlDeliveryReg.SelectedValue;
}
else if (HdnTypeDeliverySelected.Value == "retiro")
{
IsDelivewry = false;
Dir = " ";
CCom = " ";
CReg = " ";
}
else
{
IsDelivewry = false;
Dir = " ";
CCom = " ";
CReg = " ";
}
DateTime fecha;
if (DateTime.TryParse(HdnDateSelected.Value, out fecha))
{
object[] Param = new object[] { IsDelivewry, Pedido.ID, Dir, CCom, CReg, fecha };
string[] ParamName = new string[] { "ESDESPACHO", "IDPEDIDO", "DIRENTREGA", "COD_COMUNA", "COD_REGION", "F_ENTREGA" };
update = new UpdateRow("PLABAL", "ECOM_PEDIDOS",
"ESDESPACHO=@ESDESPACHO,DIRENTREGA=@DIRENTREGA,COD_COMUNA=@COD_COMUNA,COD_REGION=@COD_REGION,F_ENTREGA=@F_ENTREGA",
"ID=@IDPEDIDO", Param, ParamName);
if (update.Actualizado)
{
PedidoEcom.UpdateMontos updateMontos = new PedidoEcom.UpdateMontos(Pedido, true, Cliente);
if (updateMontos.IsSuccess)
{
Response.Redirect("~/View/Cliente/IngresoPedidos/Termopanel.aspx?RUT=" + rut + "&ID=" + ID + "&TOKEN=" + TOKEN);
}
}
}
else
{
IsDelivewry = false;
}
}
protected void MdlItemBtnDelete_Click(object sender, EventArgs e)
{
PedidoEcom.Get getP = new PedidoEcom.Get(HdnOrderSelected.Value);
string Anulacion = " (Pedido Anulado por " + User.Identity.Name + " el " + DateTime.Now.ToLongDateString() + " a las " + DateTime.Now.ToShortTimeString() + " )";
object[] Param = new object[] { getP.Pedido.Observa + Anulacion, HdnOrderSelected.Value };
string[] ParamName = new string[] { "OBSERVA", "ID" };
UpdateRow update = new UpdateRow("PLABAL", "UPDATE ECOM_PEDIDOS SET ESTADO='NUL',OBSERVA=@OBSERVA WHERE ID=@ID", Param, ParamName);
DoFiltering();
//Response.Redirect("~/View/Cliente/MisPedidos/Default.aspx?RUT=" + rut);
}
public UpdateRow AddUpdateRow(string Description, string Url, string Version, string MD5)
{
UpdateRow rowUpdateRow = ((UpdateRow)(this.NewRow()));
object[] columnValuesArray = new object[] {
Description,
Url,
Version,
MD5
};
rowUpdateRow.ItemArray = columnValuesArray;
this.Rows.Add(rowUpdateRow);
return(rowUpdateRow);
}
protected void BtnCargaMasiva_Click(object sender, EventArgs e)
{
string folio = DateTime.Now.ToLongTimeString().Replace(":", "");
string path = Path.Combine(Server.MapPath("~/CargaMasiva/"));
if (!string.IsNullOrEmpty(FileUpXls.FileName.ToString()))
{
string Filename = folio + FileUpXls.FileName.ToString();
path = path + Filename;
FileUpXls.SaveAs(path);
object[] Param = new object[] { true, Filename, ID };
string[] ParamName = new string[] { "HASFILE", "FILEXLS", "ID" };
UpdateRow update = new UpdateRow("PLABAL", "ECOM_PEDIDOS", " HASFILE=@HASFILE , FILEXLS=@FILEXLS ", "ID=@ID", Param, ParamName);
if (update.Actualizado)
{
LecturaxlsTP lecturaxls = new LecturaxlsTP(Filename, Cliente.TipoXlsDvh);
if (lecturaxls.Lista.Count > 0)
{
bool[] Ingresados = new bool[200];
PedidoEcom.AddItemDVH addItem;
int cont = 0;
foreach (LecturaxlsTP.Valores valor in lecturaxls.Lista)
{
addItem = new PedidoEcom.AddItemDVH(true, valor.Terminologia, valor.Referencia, valor.Cantidad, valor.Ancho, valor.Alto, Pedido);
Ingresados[cont] = addItem.IsSuccess;
cont++;
}
int x = Ingresados.Where(it => it).Count();
string Msg;
if (x < lecturaxls.Lista.Count)
{
Msg = "La lectura fue exitosa, pero el sistema solo pudo identificar en el diccionario " + x + " items. Los items que no han sido identifcado quedaron destacados en rojo.";
}
else
{
Msg = "La lectura del archivo fue exitosa.";
}
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "myalert", "alert('" + Msg + "'); window.location='" +
Page.ResolveUrl("~/View/Cliente/IngresoPedidos/Termopanel.aspx?RUT=" + rut + "&ID=" + ID + "&TOKEN=" + TOKEN) + "';", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "myalert", "alert('El sistema no pudo reconocer ningún item ingresado en el archivo, por favor intentelo nuevamente.'); window.location='" +
Page.ResolveUrl("~/View/Cliente/IngresoPedidos/Termopanel.aspx?RUT=" + rut + "&ID=" + ID + "&TOKEN=" + TOKEN) + "';", true);
}
}
}
}
private wcf.UpdateRow convertToWcfRow(UpdateRow row)
{
var svcRow = new wcf.UpdateRow();
svcRow.ID = row.ID;
svcRow.Mode = (wcf.UpdateMode)Enum.Parse(typeof(wcf.UpdateMode), row.Mode.ToString(), true);
// svcRow.Values = new List<GrinGlobal.Business.SearchSvc.FieldValue>();
svcRow.Values = new List <GrinGlobal.Search.Engine.Service.SearchSvc.FieldValue>();
if (row.Values != null)
{
foreach (var fv in row.Values)
{
svcRow.Values.Add(convertToWcfFieldValue(fv));
}
}
return(svcRow);
}
public static void AddCalcGridColumn(GridView Grid, GridColumn Column, string[] FieldNames, UpdateRow Func)
{
Grid.CellValueChanged += delegate(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
try
{
GridView grid = (GridView)sender;
DataRow row = grid.GetDataRow(grid.FocusedRowHandle);
if (e.Column.FieldName.Equals(Column.FieldName))
{
Func(row);
}
}
catch (Exception ex)
{
PLException.AddException(ex);
}
};
}
public UpdateRowChangeEvent(UpdateRow row, global::System.Data.DataRowAction action)
{
this.eventRow = row;
this.eventAction = action;
}
public void RemoveUpdateRow(UpdateRow row)
{
this.Rows.Remove(row);
}
public void AddUpdateRow(UpdateRow row)
{
this.Rows.Add(row);
}
public UpdateRowChangeEvent(UpdateRow row, global::System.Data.DataRowAction action) {
this.eventRow = row;
this.eventAction = action;
}
public void RemoveUpdateRow(UpdateRow row) {
this.Rows.Remove(row);
}
public void AddUpdateRow(UpdateRow row) {
this.Rows.Add(row);
}
protected virtual int Execute(DataRowState rowState, T entity)
{
Dictionary <string, object> columnValueMap = new Dictionary <string, object>();
if (this.autoMapping)
{
foreach (var property in typeof(T).GetProperties())
{
if (!property.CanRead)
{
continue;
}
DbType?dbType = dagentKernel.GetDbType(property.PropertyType);
string columnName;
if (dbType.HasValue && columnNamePropertyMap.TryGetColumnName <T>(property, out columnName))
{
columnValueMap[columnName] = DynamicMethodBuilder <T> .CreateGetMethod(property)(entity);
}
}
}
UpdateRow updateRow = new UpdateRow(columnValueMap);
this.mapAction(updateRow, entity);
List <Parameter> valueParameters = new List <Parameter>();
foreach (string columnName in updateRow.ColumnNames)
{
object value = updateRow[columnName];
if (value == null)
{
value = DBNull.Value;
}
valueParameters.Add(new Parameter(columnName, value));
}
if (parameters != null)
{
foreach (Parameter parameter in parameters)
{
valueParameters.Add(parameter);
}
}
string sql = "";
if (rowState == DataRowState.Added)
{
sql = dagentKernel.GetInsertSql(tableName, this.primaryKeys, updateRow.ColumnNames);
}
else if (rowState == DataRowState.Modified)
{
sql = dagentKernel.GetUpdateSql(tableName, this.primaryKeys, updateRow.ColumnNames)
+ (string.IsNullOrEmpty(this.where) ? string.Empty : string.Format(" and ({0}) ", where));
}
else if (rowState == DataRowState.Deleted)
{
sql = dagentKernel.GetDeleteSql(tableName, this.primaryKeys)
+ (string.IsNullOrEmpty(this.where) ? string.Empty : string.Format(" and ({0}) ", where));
}
using (TransactionScope tarnsactionScope = new TransactionScope(dagentKernel))
{
DbCommand command = dagentKernel.CreateDbCommand(sql);
ParameterConverter.SetParamters(command, valueParameters.ToArray(), dagentKernel.CreateDbParameter);
int rtn = command.ExecuteNonQuery();
tarnsactionScope.Complete();
return(rtn);
}
}
protected void BtnEditItemGo_Click(object sender, EventArgs e)
{
double Alto;
double Ancho;
int Cant;
bool DoUpdate = true;
if (!double.TryParse(TxtEditAlto.Text, out Alto))
{
DoUpdate = false;
}
if (!double.TryParse(TxtEditAncho.Text, out Ancho))
{
DoUpdate = false;
}
if (!int.TryParse(TxtEditCant.Text, out Cant))
{
DoUpdate = false;
}
if (DoUpdate)
{
object[] Param;
string[] ParamName;
Getm2yPerim getm2 = new Getm2yPerim(Ancho, Alto);
Param = new object[] { TxtEditRef.Text, Cant, Ancho, Alto, HdnIdItemSelected.Value, true, getm2.M2, getm2.M2 *Cant, getm2.Perimetro, getm2.Perimetro *Cant };
ParamName = new string[] { "REFERENCIA", "CANT", "ANCHO", "ALTO", "IDPEDDET", "ESTADO", "M2UN", "M2ITM", "PERIMUN", "PERIMITM" };
UpdateRow update = new UpdateRow("PLABAL", "ECOM_PEDDET", "REFERENCIA=@REFERENCIA,CANT=@CANT,ANCHO=@ANCHO,ALTO=@ALTO,M2UN=@M2UN,M2ITM=@M2ITM,PERIMUN=@PERIMUN,PERIMITM=@PERIMITM", "IDPEDDET=@IDPEDDET AND ESTADO=@ESTADO", Param, ParamName);
if (update.Actualizado)
{
PedDet.GetItem getItem = new PedDet.GetItem(ID, HdnIdItemSelected.Value, true);
if (!string.IsNullOrEmpty(HdnAddTerminologia.Value))
{
string[] Codigos = new string[] { DDLEditCREX.SelectedValue, DDLEditSEP.SelectedValue, DDLEditCRIN.SelectedValue, "909" };
if (ChkAddTerminologia.Checked)
{
/*Agregar al diccionario*/
PedDet.AddDiccionario addDiccionario = new PedDet.AddDiccionario(HdnAddTerminologia.Value, Page.User.Identity.Name, rut, Codigos);
}
/*Ingreso de uno del diccionario*/
PedSubDet.InsertSub insertSub = new PedSubDet.InsertSub(getItem.Item, Codigos, Pedido, Cliente.Margen);
if (insertSub.Insertados)
{
UpdatePLABALRow updatePLABALRow = new UpdatePLABALRow("ECOM_PEDDET", "IDPEDDET", HdnIdItemSelected.Value, "GOTFDICC", true);
}
}
else
{
/*Actualizacion*/
PedSubDet Sub;
bool IsChanged = false;
if (HdnCREXDET.Value != "")
{
IsChanged = true;
PedSubDet.CalcCostos costos = new PedSubDet.CalcCostos(DDLEditCREX.SelectedValue, getItem.Item);
Sub = costos.Subdets.First();
Param = new object[] { Sub.CNETOUN, Sub.CMERMAUN, Sub.CPROCUN, Sub.KGUN, Sub.ALFAKCODE, Sub.STL_PRODART, Sub.STL_PRODGRP, Sub.STL_WGR, HdnIDSUBDETCREEX.Value, Sub.DESCRIPCION };
ParamName = new string[] { "CNETOUN", "CMERMAUN", "CPROCUN", "KGUN", "ALFAKCODE", "STL_PRODART", "STL_PRODGRP", "STL_WGR", "IDPEDSUBDET", "DESCRIPCION" };
update = new UpdateRow("PLABAL", "ECOM_PEDSUBDET", "CNETOUN=@CNETOUN,CMERMAUN=@CMERMAUN,CPROCUN=@CPROCUN,KGUN=@KGUN,ALFAKCODE=@ALFAKCODE,STL_PRODART=@STL_PRODART,STL_PRODGRP=@STL_PRODGRP,STL_WGR=@STL_WGR,DESCRIPCION=@DESCRIPCION", "IDPEDSUBDET=@IDPEDSUBDET", Param, ParamName);
}
if (HdnCRINDET.Value != "")
{
IsChanged = true;
PedSubDet.CalcCostos costos = new PedSubDet.CalcCostos(DDLEditCRIN.SelectedValue, getItem.Item);
Sub = costos.Subdets.First();
Param = new object[] { Sub.CNETOUN, Sub.CMERMAUN, Sub.CPROCUN, Sub.KGUN, Sub.ALFAKCODE, Sub.STL_PRODART, Sub.STL_PRODGRP, Sub.STL_WGR, HdnIDSUBDETCRIN.Value, Sub.DESCRIPCION };
ParamName = new string[] { "CNETOUN", "CMERMAUN", "CPROCUN", "KGUN", "ALFAKCODE", "STL_PRODART", "STL_PRODGRP", "STL_WGR", "IDPEDSUBDET", "DESCRIPCION" };
update = new UpdateRow("PLABAL", "ECOM_PEDSUBDET", "CNETOUN=@CNETOUN,CMERMAUN=@CMERMAUN,CPROCUN=@CPROCUN,KGUN=@KGUN,ALFAKCODE=@ALFAKCODE,STL_PRODART=@STL_PRODART,STL_PRODGRP=@STL_PRODGRP,STL_WGR=@STL_WGR,DESCRIPCION=@DESCRIPCION", "IDPEDSUBDET=@IDPEDSUBDET", Param, ParamName);
}
if (HdnSEPDET.Value != "")
{
IsChanged = true;
PedSubDet.CalcCostos costos = new PedSubDet.CalcCostos(DDLEditSEP.SelectedValue, getItem.Item);
Sub = costos.Subdets.First();
Param = new object[] { Sub.CNETOUN, Sub.CMERMAUN, Sub.CPROCUN, Sub.KGUN, Sub.ALFAKCODE, Sub.STL_PRODART, Sub.STL_PRODGRP, Sub.STL_WGR, HdnIDSUBDETSEP.Value, Sub.DESCRIPCION };
ParamName = new string[] { "CNETOUN", "CMERMAUN", "CPROCUN", "KGUN", "ALFAKCODE", "STL_PRODART", "STL_PRODGRP", "STL_WGR", "IDPEDSUBDET", "DESCRIPCION" };
update = new UpdateRow("PLABAL", "ECOM_PEDSUBDET", "CNETOUN=@CNETOUN,CMERMAUN=@CMERMAUN,CPROCUN=@CPROCUN,KGUN=@KGUN,ALFAKCODE=@ALFAKCODE,STL_PRODART=@STL_PRODART,STL_PRODGRP=@STL_PRODGRP,STL_WGR=@STL_WGR,DESCRIPCION=@DESCRIPCION", "IDPEDSUBDET=@IDPEDSUBDET", Param, ParamName);
}
if (IsChanged)
{
Param = new object[] { HdnIdItemSelected.Value, ID, true };
ParamName = new string[] { "IDPEDDET", "IDPEDIDO", "ESTADO" };
SelectRows select = new SelectRows("PLABAL", "ECOM_PEDSUBDET", "DESCRIPCION", "IDPEDDET=@IDPEDDET AND IDPEDIDO=@IDPEDIDO AND ESTADO=@ESTADO", Param, ParamName);
string[] Descrip = new string[select.Datos.Rows.Count];
for (int i = 0; i < 3; i++)
{
Descrip[i] = select.Datos.Rows[i][0].ToString();
}
UpdatePLABALRow updateP = new UpdatePLABALRow("ECOM_PEDDET", "IDPEDDET", HdnIdItemSelected.Value, "DESCRIPCION", string.Join(" || ", Descrip));
}
PedDet.Calculos calculos = new PedDet.Calculos(getItem.Item, Pedido, Cliente.Margen);
}
Response.Redirect("~/View/Cliente/IngresoPedidos/Termopanel.aspx?RUT=" + rut + "&ID=" + ID + "&TOKEN=" + TOKEN);
}
}
}
public static UpdateRow CreateUpdateRow(JObject row, DataRowState rowState)
{
//主键可修改功能
var updateRow = new UpdateRow()
{
RowState = rowState,
NewValues = new Dictionary<string, object>(),
OldValues = new Dictionary<string, object>()
};
foreach (var property in row.Properties())
{
if (rowState != DataRowState.Added)
{
if (row[string.Format("{0}{1}", KEY_PREFIX, property.Name)] != null)
{
updateRow.OldValues.Add(property.Name, (row[string.Format("{0}{1}", KEY_PREFIX, property.Name)] as JValue).Value);
}
else
{
updateRow.OldValues.Add(property.Name, (row[property.Name] as JValue).Value);
}
}
if (rowState != DataRowState.Deleted)
{
updateRow.NewValues.Add(property.Name, (row[property.Name] as JValue).Value);
}
}
return updateRow;
}
