public bool Agregar(Producto obj)
{
SQLParameter[] parameters = new SQLParameter[9];
parameters[0] = new SQLParameter("@Categoria", obj.Categoria, SqlDbType.Int);
parameters[1] = new SQLParameter("@SubCategoria", obj.SubCategoria, SqlDbType.Int);
parameters[2] = new SQLParameter("@Codigo", obj.Codigo, SqlDbType.VarChar);
parameters[3] = new SQLParameter("@Nombre", obj.Nombre, SqlDbType.VarChar);
parameters[4] = new SQLParameter("@Imagen", obj.Imagen, SqlDbType.VarChar);
parameters[5] = new SQLParameter("@TipoExistencia", obj.TipoExistencia, SqlDbType.VarChar);
parameters[6] = new SQLParameter("@UnidadMedida", obj.UnidadMedida, SqlDbType.VarChar);
parameters[7] = new SQLParameter("@Marca", obj.Marca, SqlDbType.Int);
parameters[8] = new SQLParameter("@Estado", obj.Estado, SqlDbType.Int);
Response = Conexion.ExecuteProcedureB("USP_I_AgregarProducto", parameters);
if (Response == true)
{
Inventario beIventario = new Inventario
{
Producto = obj.Codigo,
ValorUnitario = 0,
Existencias = 0,
ValorInventario = 0
};
DInventario boInventario = new DInventario();
boInventario.Agregar(beIventario);
}
return(Response);
}
public Cliente Seleccionar(string NumeroDocumento)
{
try
{
SQLParameter[] parameters = new SQLParameter[1];
parameters[0] = new SQLParameter("@NumeroDocumento", NumeroDocumento, SqlDbType.VarChar);
DataRow row = Conexion.ExecuteProcedureD("USP_S_SeleccionarCliente", parameters).Tables[0].Rows[0];
Cliente be = new Cliente
{
ID = Convert.ToInt32(row[0]),
TipoDocumento = row[1].ToString(),
NumeroDocumento = row[2].ToString(),
Nombre = row[3].ToString(),
Apellido = row[4].ToString(),
FechaNacimiento = row[5] == DBNull.Value ? (DateTime?)null : Convert.ToDateTime(row[5]),
Pais = row[6].ToString(),
Ciudad = row[7].ToString(),
Direccion = row[8].ToString(),
Email = row[9].ToString(),
Telefono = row[10].ToString(),
Estado = Convert.ToInt32(row[11].ToString())
};
return(be);
}
catch
{
Cliente be = new Cliente();
return(be);
}
}
public SearchResult <OrderingDTO> Execute()
{
int totalCount = 0;
var items = new List <OrderingDTO>();
ADO.ExecuteDataReader(CommandType.Text, BuildQuery(), dataReader =>
{
using (var reader = new SafeDataReader(dataReader))
{
if (!reader.Read())
{
return;
}
totalCount = reader.GetInt32(0);
reader.NextResult();
while (reader.Read())
{
items.Add(GetDto(reader));
}
}
},
SQLParameter.CreateParameter("PageSize", DbType.Int32, _pageSize),
SQLParameter.CreateParameter("PageIndex", DbType.Int32, _pageIndex)
);
return(new SearchResult <OrderingDTO>(items, totalCount));
}
public string deleteCalendar(string ID)
{
sqlParameter = new SQLParameter();
sqlParameter.WhereCondition.Add("ID", ID);
calendarDB = new TB_Calendar_DB();
return(calendarDB.deleteDate(sqlParameter));
}
public string editCalendar(string MainFunctionName)
{
sqlParameter = new SQLParameter();
sqlParameter.SetActionValue.Add("MainFunctionName", MainFunctionName);
calendarDB = new TB_Calendar_DB();
return(calendarDB.editData(sqlParameter));
}
public ParameterBinding(SQLRepository repository, SQLParameter eaParameter)
{
this.Name = eaParameter.Name;
this.Repository = repository;
this.Parameter = eaParameter;
this.ParameterGuid = eaParameter.ParameterGUID;
this.ParameterType = eaParameter.Type;
}
public ParameterExpression(SQLRepository repository, SQLParameter parameter)
{
this.Repository = repository;
this.Parameter = parameter;
this.ParameterGUID = parameter.ParameterGUID;
this.ParameterName = parameter.Name;
this.Type = DESCRIPTION;
}
public bool Agregar(SubCategoria obj)
{
SQLParameter[] parameters = new SQLParameter[2];
parameters[0] = new SQLParameter("@Categoria", obj.Categoria, SqlDbType.Int);
parameters[1] = new SQLParameter("@Nombre", obj.Nombre, SqlDbType.VarChar);
Response = Conexion.ExecuteProcedureB("USP_I_AgregarSubCategoria", parameters);
return(Response);
}
public bool Modificar(Cargo obj)
{
SQLParameter[] parameters = new SQLParameter[2];
parameters[0] = new SQLParameter("@ID", obj.ID, SqlDbType.Int);
parameters[1] = new SQLParameter("@Descripcion", obj.Descripcion, SqlDbType.VarChar);
Response = Conexion.ExecuteProcedureB("USP_U_ModificarCargo", parameters);
return(Response);
}
public static SQLParameter AddParameter(this List <SQLParameter> parameters, object value)
{
int c = parameters.Count + 1;
SQLParameter param = new SQLParameter($"{DialectProvider.PARAM_PREFIX}{c}", value);
parameters.Add(param);
return(param);
}
public bool Modificar(Marca obj)
{
SQLParameter[] parameters = new SQLParameter[2];
parameters[0] = new SQLParameter("@ID", obj.ID, SqlDbType.Int);
parameters[1] = new SQLParameter("@Nombre", obj.Nombre, SqlDbType.VarChar);
Response = Conexion.ExecuteProcedureB("USP_U_ModificarMarca", parameters);
return(Response);
}
public bool Agregar(Usuario obj)
{
SQLParameter[] parameters = new SQLParameter[3];
parameters[0] = new SQLParameter("@Username", obj.Username, SqlDbType.VarChar);
parameters[1] = new SQLParameter("@Password", obj.Password, SqlDbType.VarChar);
parameters[2] = new SQLParameter("@Estado", obj.Estado, SqlDbType.Int);
Response = Conexion.ExecuteProcedureB("USP_I_AgregarUsuario", parameters);
return(Response);
}
public bool Modificar(Inventario obj)
{
SQLParameter[] parameters = new SQLParameter[4];
parameters[0] = new SQLParameter("@Producto", obj.Producto, SqlDbType.VarChar);
parameters[1] = new SQLParameter("@ValorUnitario", obj.ValorUnitario, SqlDbType.Decimal);
parameters[2] = new SQLParameter("@Existencias", obj.Existencias, SqlDbType.Int);
parameters[3] = new SQLParameter("@ValorInventario", obj.ValorInventario, SqlDbType.Decimal);
Response = Conexion.ExecuteProcedureB("USP_U_ModificarInventario", parameters);
return(Response);
}
public List <Admin> GetAdminsByUsername(string username)
{
string query = "SELECT * FROM dbo.Administrators WHERE Username = @un";
SQLParameter un = new SQLParameter();
un.name = "@un";
un.value = username;
return(AdminQuery(query, new SQLParameter[] { un }));
}
public bool Modificar(Proveedor obj)
{
SQLParameter[] parameters = new SQLParameter[6];
parameters[0] = new SQLParameter("@Ruc", obj.Ruc, SqlDbType.VarChar);
parameters[1] = new SQLParameter("@RazonSocial", obj.RazonSocial, SqlDbType.VarChar);
parameters[2] = new SQLParameter("@Ciudad", obj.Ciudad, SqlDbType.VarChar);
parameters[3] = new SQLParameter("@Direccion", obj.Direccion, SqlDbType.VarChar);
parameters[4] = new SQLParameter("@Email", obj.Email, SqlDbType.VarChar);
parameters[5] = new SQLParameter("@Telefono", obj.Telefono, SqlDbType.VarChar);
Response = Conexion.ExecuteProcedureB("USP_U_ModificarProveedor", parameters);
return(Response);
}
public string addCalendar()
{
DateTime Now = DateTime.Now;
sqlParameter = new SQLParameter();
sqlParameter.SetActionValue.Add("EventName", this.EventName);
sqlParameter.SetActionValue.Add("Description", this.Description);
sqlParameter.SetActionValue.Add("EventTime", this.EventTime);
sqlParameter.SetActionValue.Add("CreateDate", Now);
calendarDB = new TB_Calendar_DB();
return(calendarDB.addData(sqlParameter));
}
public bool Agregar(DetalleVenta obj)
{
SQLParameter[] parameters = new SQLParameter[6];
parameters[0] = new SQLParameter("@Serie", obj.Serie, SqlDbType.VarChar);
parameters[1] = new SQLParameter("@Numero", obj.Numero, SqlDbType.VarChar);
parameters[2] = new SQLParameter("@Producto", obj.Producto, SqlDbType.VarChar);
parameters[3] = new SQLParameter("@Precio", obj.Precio, SqlDbType.Decimal);
parameters[4] = new SQLParameter("@Cantidad", obj.Cantidad, SqlDbType.Int);
parameters[5] = new SQLParameter("@Importe", obj.Importe, SqlDbType.Decimal);
Response = Conexion.ExecuteProcedureB("USP_I_AgregarDetalleVenta", parameters);
return(Response);
}
public override void deserializeFromMocaTree(Serialization.MocaTree.MocaNode actNode)
{
this.ParameterGUID = actNode.getAttributeOrCreate("parameterGuid").Value;
this.ParameterNameOld = actNode.getAttributeOrCreate("parameterName").Value;
this.ParameterName = this.ParameterNameOld;
SQLParameter param = Repository.GetParameterByGuid(this.ParameterGUID);
if (param != null)
{
this.ParameterName = param.Name;
}
}
private Expression computeExpression()
{
Expression expression = null;
try
{
//output will be computed as the name of the stopNode
//AttributeValueExpression with target(cmbTarget) and attribute(cmbSources)
if (selectedExpressionString == "AttributeValueExpression" && secondObjects.Count > selectedSecondObjectIndex && firstObjects.Count > selectedFirstObjectIndex && selectedSecondObjectIndex != -1 && selectedFirstObjectIndex != -1)
{
//get OV and Attribute
SQLAttribute attribute = this.secondObjects[selectedSecondObjectIndex].EaObject as SQLAttribute;
SQLElement targetObjectVariable = this.firstObjects[selectedFirstObjectIndex].EaObject as SQLElement;
AttributeValueExpression avExp = new AttributeValueExpression(repository, attribute, targetObjectVariable);
expression = avExp;
}
//MethodCallExpression with target(cmbTarget) and Method(cmbSources)
else if (selectedExpressionString == "MethodCallExpression" && secondObjects.Count > selectedSecondObjectIndex && firstObjects.Count > selectedFirstObjectIndex && selectedSecondObjectIndex != -1 && selectedFirstObjectIndex != -1)
{
SQLMethod method = this.secondObjects[selectedSecondObjectIndex].EaObject as SQLMethod;
String name = method.Name;
Object target = this.firstObjects[selectedFirstObjectIndex].EaObject;
MethodCallExpression methodCallExpression = EditorMethodCallExpression.generateMethodCallExpression(repository, target, method);
expression = methodCallExpression;
}
//parameterExpression
else if (selectedExpressionString == "ParameterExpression" && firstObjects.Count > selectedFirstObjectIndex && selectedFirstObjectIndex != -1)
{
SQLParameter parameter = this.firstObjects[selectedFirstObjectIndex].EaObject as SQLParameter;
ParameterExpression pExp = new ParameterExpression(repository, parameter);
expression = pExp;
}
//literalExpression
else if (selectedExpressionString == "LiteralExpression")
{
LiteralExpression literalExpression = new LiteralExpression("null");
expression = literalExpression;
}
//objectVariableExpression
else if (selectedExpressionString == "ObjectVariableExpression" && firstObjects.Count > selectedFirstObjectIndex)
{
SQLElement sdmObject = this.firstObjects[selectedFirstObjectIndex].EaObject as SQLElement;
ObjectVariableExpression ovExp = new ObjectVariableExpression(sdmObject, repository);
expression = ovExp;
}
}
catch (Exception)
{
}
return(expression);
}
public JsonResult GetRunningWoSegments(string code, string strDate)
{
DataSet ds = new DataSet();
SQLParameter dataPara = new SQLParameter();
dataPara.DbType = DbType.String;
dataPara.Name = "@QueryDate";
dataPara.Value = strDate;
paras.Add(dataPara);
SrvProxy.CreateServices <ISqlCommandConfigService>().Query(code, paras, out ds);
return(JsonSMES(ds.Tables[0]));
}
public bool Modificar(Producto obj)
{
SQLParameter[] parameters = new SQLParameter[8];
parameters[0] = new SQLParameter("@Categoria", obj.Categoria, SqlDbType.Int);
parameters[1] = new SQLParameter("@SubCategoria", obj.SubCategoria, SqlDbType.Int);
parameters[2] = new SQLParameter("@Codigo", obj.Codigo, SqlDbType.VarChar);
parameters[3] = new SQLParameter("@Nombre", obj.Nombre, SqlDbType.VarChar);
parameters[4] = new SQLParameter("@Imagen", obj.Imagen, SqlDbType.VarChar);
parameters[5] = new SQLParameter("@TipoExistencia", obj.TipoExistencia, SqlDbType.VarChar);
parameters[6] = new SQLParameter("@UnidadMedida", obj.UnidadMedida, SqlDbType.VarChar);
parameters[7] = new SQLParameter("@Marca", obj.Marca, SqlDbType.Int);
Response = Conexion.ExecuteProcedureB("USP_U_ModificarProducto", parameters);
return(Response);
}
public int ObtenerID(string NumeroDocumento)
{
try
{
SQLParameter[] parameters = new SQLParameter[1];
parameters[0] = new SQLParameter("@NumeroDocumento", NumeroDocumento, SqlDbType.VarChar);
DataRow row = Conexion.ExecuteProcedureD("USP_S_ObtenerIDEmpleado", parameters).Tables[0].Rows[0];
return(Convert.ToInt32(row[0]));
}
catch
{
return(0);
}
}
public List <User> SearchUserByName(string name)
{
string query = "SELECT * FROM dbo.Users " +
"WHERE LOWER(LastName) LIKE LOWER(@ss) "
+ "OR LOWER(FirstName) LIKE LOWER(@ss) "
+ "ORDER BY LastName";
SQLParameter ss = new SQLParameter();
ss.name = "@ss";
ss.value = "%" + name + "%";
return(this.UserQuery(query, new SQLParameter[] { ss }));
}
public string getMainFunction()
{
sqlParameter = new SQLParameter();
sqlParameter.OrderByValue = "MainFunctionID";
DataTable dt = mainfunctionDB.getData(sqlParameter);
if (CheckDataTableExist(dt) == false)
{
return("查無資料!");
}
MainFunctionList = (DataTableConvertToList.ToList <MainFunctionModel>(dt));
sqlParameter = null;
return(null);
}
private static bool checkParameterExpression(SQLElement containingElement, ParameterExpression pExp, SQLRepository sqlRepository)
{
SQLParameter referencedParameter = sqlRepository.GetParameterByGuid(pExp.ParameterGUID);
if (referencedParameter == null)
{
return(false);
}
if (pExp.ParameterNameOld != pExp.ParameterName)
{
return(false);
}
return(checkParameterCanBeReferenced(referencedParameter, containingElement, sqlRepository));
}
public DataRow ObtenerSerieCorrelativo(string tipo)
{
try
{
SQLParameter[] parameters = new SQLParameter[1];
parameters[0] = new SQLParameter("@Tipo", tipo, SqlDbType.VarChar);
DataRow row = Conexion.ExecuteProcedureD("USP_S_SerieCorrelativo", parameters).Tables[0].Rows[0];
return(row);
}
catch
{
DataRow row = null;
return(row);
}
}
public DataRow ObtenerPerfilBasico(string Username)
{
try
{
SQLParameter[] parameters = new SQLParameter[1];
parameters[0] = new SQLParameter("@NumeroDocumento", Username, SqlDbType.VarChar);
DataRow row = Conexion.ExecuteProcedureD("USP_S_PerfilBasicoUsuario", parameters).Tables[0].Rows[0];
return(row);
}
catch (Exception e)
{
DataRow row = null;
return(row);
}
}
public DataRow ObtenerInformacion(string NumeroDocumento)
{
try
{
SQLParameter[] parameters = new SQLParameter[1];
parameters[0] = new SQLParameter("@NumeroDocumento", NumeroDocumento, SqlDbType.VarChar);
DataRow row = Conexion.ExecuteProcedureD("USP_S_ObtenerInformacionEmpleado", parameters).Tables[0].Rows[0];
return(row);
}
catch
{
DataRow row = null;
return(row);
}
}
public bool ModificarxUsuario(Empleado obj)
{
SQLParameter[] parameters = new SQLParameter[9];
parameters[0] = new SQLParameter("@NumeroDocumento", obj.NumeroDocumento, SqlDbType.VarChar);
parameters[1] = new SQLParameter("@Nombre", obj.Nombre, SqlDbType.VarChar);
parameters[2] = new SQLParameter("@Apellido", obj.Apellido, SqlDbType.VarChar);
parameters[3] = new SQLParameter("@FechaNacimiento", obj.FechaNacimiento, SqlDbType.Date);
parameters[4] = new SQLParameter("@Pais", obj.Pais, SqlDbType.VarChar);
parameters[5] = new SQLParameter("@Ciudad", obj.Ciudad, SqlDbType.VarChar);
parameters[6] = new SQLParameter("@Direccion", obj.Direccion, SqlDbType.VarChar);
parameters[7] = new SQLParameter("@Email", obj.Email, SqlDbType.VarChar);
parameters[8] = new SQLParameter("@Telefono", obj.Telefono, SqlDbType.VarChar);
Response = Conexion.ExecuteProcedureB("USP_U_ModificarEmpleadoUsuario", parameters);
return(Response);
}
public JsonResult GetDayWoStatics(string code, string strDate)
{
strDate = Convert.ToDateTime(strDate).ToString("yyyy-MM-dd");
DataSet ds = new DataSet();
paras.Clear();
SQLParameter dataPara = new SQLParameter();
dataPara.DbType = DbType.String;
dataPara.Name = "@QueryDate";
dataPara.Value = strDate;
paras.Add(dataPara);
SrvProxy.CreateServices <ISqlCommandConfigService>().Query(code, paras, out ds);
return(JsonSMES(ds.Tables[0]));
}
