private SqlDataReader GetCurrentTask(DateTime DateFrom, DateTime?DateTill)
{
SqlHandle sql = new SqlHandle(DataService.connectionString);
sql.SqlStatement = "SP_PL_CurrentTaskQuery";
sql.Connect();
sql.TypeCommand = CommandType.StoredProcedure;
sql.IsResultSet = true;
sql.AddCommandParametr(new SqlParameter {
ParameterName = "@From", Value = DateFrom
});
sql.AddCommandParametr(new SqlParameter {
ParameterName = "@Till", Value = DateTill
});
bool success = sql.Execute();
if (!success)
{
MessageBox.Show(sql.LastError, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(null);
}
return(sql.Reader);
}
public static bool CreateLogin(string Login, string Pswd, bool IsWindowsUser)
{
/*if (IsLoginExist(Login))
* return true;
* SqlHandle sql = new SqlHandle(DataService.connectionString);
*
* StringBuilder sqlStatement = new StringBuilder($"CREATE LOGIN { Login } ");
*
* if (!IsWindowsUser)
* sqlStatement.Append($"WITH PASSWORD = '******';");
* sql.SqlStatement = sqlStatement.ToString();
* sql.Connect();
*
* bool success = sql.Execute();
*
* if (!success)
* MessageBox.Show(sql.LastError, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
* sql.Disconnect();
*
* return success;
*/
SqlHandle sql = new SqlHandle(DataService.connectionString);
sql.Connect();
sql.TypeCommand = CommandType.StoredProcedure;
sql.SqlStatement = "CreateLogin";
sql.AddCommandParametr(new SqlParameter {
ParameterName = "@Login", Value = Login
});
sql.AddCommandParametr(new SqlParameter {
ParameterName = "@Psw", Value = Pswd
});
sql.AddCommandParametr(new SqlParameter {
ParameterName = "@IsWnd", Value = IsWindowsUser
});
bool success = sql.Execute();
if (!success)
{
MessageBox.Show(sql.LastError, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
sql.Disconnect();
return(success);
}
private void PopulateMovementItem()
{
tblMovementItem.AutoGenerateColumns = false;
SqlHandle sqlHandle1 = new SqlHandle(DataService.connectionString);
sqlHandle1.SqlStatement = "SP_PL_GetMovementItems";
sqlHandle1.Connect();
sqlHandle1.TypeCommand = CommandType.StoredProcedure;
sqlHandle1.IsResultSet = true;
SqlHandle sqlHandle2 = sqlHandle1;
SqlParameter sqlParameter = new SqlParameter();
sqlParameter.ParameterName = "@MovementID";
sqlParameter.Value = (object)this._movement.Id;
sqlHandle2.AddCommandParametr(sqlParameter);
if (!sqlHandle1.Execute())
{
int num = (int)MessageBox.Show(sqlHandle1.LastError, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
else
{
DataSet dataSet = new DataSet();
dataSet.Tables.Add();
dataSet.Tables[0].Load((IDataReader)sqlHandle1.Reader);
this.tblMovementItem.DataSource = (object)dataSet.Tables[0];
}
}
public static bool ForceMergeLVAttribute(int ShpId)
{
SqlHandle sql = new SqlHandle(DataService.connectionString);
sql.Connect();
sql.TypeCommand = CommandType.StoredProcedure;
sql.SqlStatement = "SP_PL_ForceMergeLVAttribute";
sql.AddCommandParametr(new SqlParameter {
ParameterName = "@ShpID", Value = ShpId
});
bool success = sql.Execute();
if (!success)
{
MessageBox.Show(sql.LastError, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
sql.Disconnect();
return(success);
}
public void Populate()
{
string UserId = cmbUser.Text;
int ShpType = cmbShpType.SelectedIndex - 1;
SqlHandle sql = new SqlHandle(DataService.connectionString);
#region ДатыОтгрузки
if (_shipmentId >= 0)
{
sql.Connect();
string table_name = !_isShipment ? "movement_log" : "shipments_log";
string field_name = !_isShipment ? "movement_id" : "shipment_id";
sql.TypeCommand = CommandType.Text;
sql.IsResultSet = true;
sql.SqlStatement = $@"select min(dml_date) min_dml_date, max(dml_date) max_dml_date
from {table_name}
where {field_name} = " + _shipmentId;
bool Success = sql.Execute() && sql.Reader != null && sql.Reader.Read() && sql.Reader.HasRows;
if (Success)
{
dtBegin.Value = sql.Reader.IsDBNull(0) ? DateTime.Now: sql.Reader.GetDateTime(0);
dtEnd.Value = sql.Reader.IsDBNull(1) ? DateTime.Now:sql.Reader.GetDateTime(1);
}
sql.Disconnect();
}
#endregion
DateTime DateFrom = dtBegin.Value;
DateTime DateTill = dtEnd.Value;
sql.SqlStatement = "SP_PL_GetShipmentLog";
sql.Connect();
sql.TypeCommand = CommandType.StoredProcedure;
sql.IsResultSet = true;
object shpType = null;
if (ShpType >= 0)
{
shpType = ShpType;
}
sql.AddCommandParametr(new SqlParameter {
ParameterName = "@ShpId", Value = _shipmentId
});
sql.AddCommandParametr(new SqlParameter {
ParameterName = "@From", Value = DateFrom
});
sql.AddCommandParametr(new SqlParameter {
ParameterName = "@Till", Value = DateTill
});
sql.AddCommandParametr(new SqlParameter {
ParameterName = "@In", Value = shpType
});
sql.AddCommandParametr(new SqlParameter {
ParameterName = "@UserId", Value = UserId
});
bool success = sql.Execute();
if (!success)
{
MessageBox.Show(sql.LastError, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
DataSet ds = new DataSet();
ds.Tables.Add();
ds.Tables[0].Load(sql.Reader);
tblShipmentLog.AutoGenerateColumns = false;
tblShipmentLog.DataSource = ds.Tables[0];
sql.Disconnect();
CalcRowColor();
tblShipmentItemLog.AutoGenerateColumns = false;
tblMovementItemLog.AutoGenerateColumns = false;
if (tblShipmentLog.Rows.Count > 0)
{
ShowShipmentLogDetail();
}
/*tblShipmentItemLog.Visible = false;
* tblMovementItemLog.Visible = false;*/
}