public RP MapEaiToRP(Client client)
{
var rPEntity = new RP();
rPEntity.Abn = Client.Abn;
return(rPEntity);
}
public static void StartTasks()
{
foreach (var instance in RP.GetTasksReprository())
{
AddTask(instance.Title, instance.StartSeconds);
}
}
public JsonpResult _TreeViewLoading(int?ID)
{
int parentId = (ID == null ? 0 : (int)ID);
var pages = RP.GetAdminMenuRepository();
string domain = string.Empty;
if (!HttpContext.Request.IsLocal && SF.UseMultiDomain())
{
domain = "http://" + RP.GetAdminCurrentSettingsRepository().Domain;
}
IEnumerable nodes = pages.Where(r => r.ParentID == parentId)
.Select(item => new
{
Text = item.Title,
ID = item.ID.ToString(),
hasChildren = (pages.Count(r2 => r2.ParentID == item.ID) > 0),
imageUrl = domain + Url.Content(item.Image),
Url = (string.IsNullOrEmpty(item.RedirectTo) ? (domain + item.Url) : item.RedirectTo),
SpriteCssClass = "",
expanded = (item.IsLangRoot),
ReportsTo = parentId
});
return(this.Jsonp(nodes));
}
protected override object CreateModel(
ControllerContext controllerContext,
ModelBindingContext bindingContext,
Type modelType)
{
ValueProviderResult result;
result = bindingContext.ValueProvider.GetValue("RouteUrl");
if (result == null)
{
throw new NotImplementedException("RouteUrl must be specified");
}
foreach (Type item in RP.GetPageTypesReprository())
{
if (result.AttemptedValue == SF.GetTypeRouteUrl(item))
{
var model = Activator.CreateInstance(item);
bindingContext.ModelMetadata = ModelMetadataProviders.Current.GetMetadataForType(() => model, item);
return(model);
}
}
throw new NotImplementedException("RouteUrl must be specified");
}
public ActionResult RemoveRule(int ID, int Num, string systemName, string prefix)
{
var rules = DiscountService.GetRules();
if (string.IsNullOrEmpty(systemName) || !rules.ContainsKey(systemName))
{
return(Content(RP.T("Admin.Discount.RuleNotFound").ToString()));
}
var rule = rules[systemName];
var saved = rule.GetConfigItem();
MapModel(saved);
System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer();
var discount = _db.Discounts.FirstOrDefault(x => x.ID == ID);
if (discount != null)
{
for (var i = 1; i <= discount.RuleList.Count; i++)
{
if (i == Num)
{
discount.RuleList.RemoveAt(i - 1);
break;
}
}
}
//js.Serialize();
discount.RulesData = js.Serialize(discount.RuleList);
_db.SaveChanges();
return(Json(new { result = "ok" }));
}
public ActionResult DiscountRuleList(int ID)
{
var discount = _db.Discounts.FirstOrDefault(x => x.ID == ID);
if (discount != null)
{
var list = new List <JsonKeyObject>();
var rules = DiscountService.GetRules();
System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer();
foreach (var r in discount.RuleList)
{
if (rules.ContainsKey(r.Name))
{
var ruleprovider = rules[r.Name];
var confitem = ruleprovider.GetConfigItem();
var o = js.Deserialize(r.Value, confitem.GetType());
list.Add(new JsonKeyObject()
{
Name = r.Name,
Object = o
});
}
}
return(PartialView(list));
}
return(Content(RP.T("Admin.Discount.NotFound").ToString()));
}
public ActionResult SaveNewRule(int ID, string systemName, string prefix)
{
var rules = DiscountService.GetRules();
if (string.IsNullOrEmpty(systemName) || !rules.ContainsKey(systemName))
{
return(Content(RP.T("Admin.Discount.RuleNotFound").ToString()));
}
var rule = rules[systemName];
var saved = rule.GetConfigItem();
MapModel(saved, prefix);
System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer();
var discount = _db.Discounts.FirstOrDefault(x => x.ID == ID);
if (discount != null)
{
discount.RuleList.Add(new JsonKeyValue()
{
Name = systemName,
Value = js.Serialize(saved)
});
}
//js.Serialize();
discount.RulesData = js.Serialize(discount.RuleList);
_db.SaveChanges();
return(Json(new { result = "ok" }));
}
protected override void Dispose(bool disposing)
{
if (disposing && (components != null))
{
components.Dispose();
}
lock (this)
{
if (RazorGFX != null)
{
RazorGFX.Dispose();
}
if (RazorBMP != null)
{
RazorBMP.Dispose();
}
if (hDCGraphics != null)
{
hDCGraphics.Dispose();
}
RP.Dispose();
}
base.Dispose(disposing);
}
public ActionResult Index(int?DomainPageID)
{
ViewBag.MessageRed = TempData["MessageRed"];
ViewBag.MessageYellow = TempData["MessageYellow"];
ViewBag.MessageGreen = TempData["MessageGreen"];
if (DomainPageID == 0 || DomainPageID == null)
{
DomainPageID = RP.GetAdminCurrentSettingsRepository().DomainPageID;
}
Settings s = _db.SettingsAll.FirstOrDefault(r => r.DomainPageID == DomainPageID);
if (s != null)
{
return(View(s));
}
else
{
s = new Settings();
s.DomainPageID = (int)DomainPageID;
_db.SettingsAll.Add(s);
_db.SaveChanges();
return(View(s));
}
}
internal static DataTable GetDataTable(RP.Sistema.Model.Entities.Requisicao requisicao)
{
var _result = new DataTable("table");
_result.Columns.Add("idquisicao", Type.GetType("System.Int32"));
_result.Columns.Add("projeto", Type.GetType("System.String"));
_result.Columns.Add("status", Type.GetType("System.String"));
_result.Columns.Add("funcionario", Type.GetType("System.String"));
_result.Columns.Add("tipo", Type.GetType("System.String"));
_result.Columns.Add("descricao", Type.GetType("System.String"));
_result.Columns.Add("material", Type.GetType("System.String"));
_result.Columns.Add("quantidade", Type.GetType("System.Decimal"));
_result.Columns.Add("unidademedida", Type.GetType("System.String"));
_result.Columns.Add("fabricante", Type.GetType("System.String"));
foreach (var item in requisicao.RequisicaoItens.ToList())
{
var row = _result.NewRow();
row["idquisicao"] = requisicao.idRequisicao;
row["projeto"] = requisicao.Projeto.descricao;
row["status"] = requisicao.Projeto.status;
row["funcionario"] = requisicao.Funcionario.nome;
row["tipo"] = requisicao.Funcionario.tipo;
row["descricao"] = requisicao.dsObservacao;
row["material"] = item.Material.nome;
row["quantidade"] = item.nrQuantidade;
row["unidademedida"] = item.Material.UnidadeMedida.nome;
//row["fabricante"] = item.Material.Fabricante.nome;
_result.Rows.Add(row);
}
return _result;
}
/// <summary>
/// Вызывается при окончании редактирования ячейки с адресом
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
if ((e.ColumnIndex != FIELD_NEWPLACE && e.ColumnIndex != FIELD_NEST) || _dataSet.Rows.Count == 0)
{
return;
}
DataRow rw = _dataSet.Rows[e.RowIndex];
RP r = _replaceList[e.RowIndex];
if (e.ColumnIndex == FIELD_NEWPLACE)
{
r.CurAddress = (string)rw[FIELD_NEWPLACE];
}
if (e.ColumnIndex == FIELD_NEWPLACE && r.Address == r.CurAddress)
{
return;
}
r.CanHaveNest = canHaveNest(e.RowIndex);
if (!r.CanHaveNest)
{
r.SetNest = false;
}
else
{
r.SetNest = (bool)rw[FIELD_NEST];
}
update();
}
public ActionResult CSVExport([DataSourceRequest] DataSourceRequest request)
{
Expression <Func <Order, bool> > predicate = x => true
// && x.OrderStatus != OrderStatus.New
// && x.OrderStatus != OrderStatus.Canceled
// && x.OrderStatus != OrderStatus.Rejected
;
if (request.Filters != null)
{
predicate = GetPredicate(predicate, request.Filters);
}
var items = _db.Orders.Where(predicate).Select(x => new PaymentReportItemModel()
{
ID = x.ID,
ShopID = x.ShopID,
IsPaidUp = x.IsPaidUp,
OrderID = x.ID,
Date = x.CreateOn,
PaymentMethod = x.PaymentMethod,
Total = x.Total
}).ToList();
foreach (var item in items)
{
item.Total = item.Cash + item.Card;
item.TotalStr = ShoppingService.FormatPrice(item.Total);
item.PayedTo = item.Card > 0 ? PayedToType.ToAdmin : PayedToType.ToShop;
item.PayedToStr = RP.T("Enums." + item.PayedTo.ToString()).ToString();
item.PaymentMethodStr = RP.T("Enums." + item.PaymentMethod.ToString()).ToString();
item.DateStr = item.Date.HasValue ? item.Date.Value.ToString("dd/MM HH:mm") : "";
}
// var items = _db.AbstractPages.Where(r => r.Visible == true).OrderBy(r => r.Title).ToList();
MemoryStream output = new MemoryStream();
StreamWriter writer = new StreamWriter(output, Encoding.UTF8);
writer.Write(RP.M("PaymentReportItemModel", "OrderID") + ",");
writer.Write(RP.M("PaymentReportItemModel", "Date") + ",");
writer.Write(RP.M("PaymentReportItemModel", "Total") + ",");
writer.Write(RP.M("PaymentReportItemModel", "PaymentMethod") + ",");
writer.Write(RP.M("PaymentReportItemModel", "PayedTo"));
writer.WriteLine();
var csvQuote = "\"";
foreach (var item in items)
{
writer.Write(item.OrderID); writer.Write(",\"");
writer.Write(item.DateStr.Replace(csvQuote, csvQuote + csvQuote)); writer.Write("\",\"");
writer.Write(item.TotalStr.Replace(csvQuote, csvQuote + csvQuote)); writer.Write("\",\"");
writer.Write(item.PaymentMethodStr.Replace(csvQuote, csvQuote + csvQuote)); writer.Write("\",\"");
writer.Write(item.PayedToStr.Replace(csvQuote, csvQuote + csvQuote)); writer.Write("\"");
writer.WriteLine();
}
writer.Flush();
output.Position = 0;
Encoding heb = Encoding.GetEncoding("windows-1255");
return(File(heb.GetBytes(new StreamReader(output).ReadToEnd()), "text/csv", "PaymentReport_" + (DateTime.Now.ToString("dd/MM HH:mm")) + ".csv"));
}
public string GetStatus()
{
Context.SharedStringBuilder.Clear();
Context.SharedStringBuilder.AppendLine(RP.ToString());
return(Context.SharedStringBuilder.ToString());
}
public ActionResult _AjaxLoadingParent(string text)
{
var l = RP.GetAdminMenuRepository();
return(new JsonResult {
Data = new SelectList(l.ToList(), "ID", "Title")
});
}
private string GetThumbnailUrl(string img, int w, int h)
{
string ext = Path.GetExtension(img);
string imageUrlNoExt = img.Remove(img.Length - ext.Length);
imageUrlNoExt = imageUrlNoExt.Replace("/", "_");
return("/App_Data/cache/images/" + RP.GetCurrentSettings().ID + "/" + imageUrlNoExt + "_" + w + "_" + h + ext);
}
public ActionResult ChangeDomain(int?DomainSelectList)
{
if (DomainSelectList != null)
{
RP.ChangeAdminCurrentSettingsRepository((int)DomainSelectList);
}
return(Redirect(Request.UrlReferrer.ToString()));
}
public void ResetRope()
{
foreach (RopePart RP in Parts)
{
RP.Destroy();
}
Parts.Clear();
Retracted = true;
}
public ActionResult _Banner(int Num, string BannerGroup)
{
var l = RP.GetBannersReprository(BannerGroup);
l = l.OrderBy(r => Guid.NewGuid()).Take(Num).ToList();
return(View(l));
// @Html.Action("_Banner", "PagePart", new { Num = 10, BannerGroup = "SearchPage" })
}
/// <summary>
/// 修改一条奖罚记录
/// hzy
/// </summary>
private void UpdateOneRP()
{
RP rp = (RP)UserGrid.SelectedItem;
UpdateRPWindow updateRPWindow = new UpdateRPWindow(rp.No);
updateRPWindow.ShowDialog();
m_rps = rpBll.GetAllRP();
ManagerBindingRP(rpBll.GetAllRP(), maxnum, 1);
}
public static void PrepareContentUnitMeasure(this ProductOverviewModel model)
{
if (model.ContentUnitPriceMultiplicator > 0 && model.ContentUnitMeasureID > 0)
{
var contentUnitMeasure = RP.GetContentUnitMeasureById(model.ContentUnitMeasureID);
model.ContentUnitName = contentUnitMeasure.DisplayName;
model.ContentUnitPrice = Math.Truncate(model.Price * model.ContentUnitPriceMultiplicator * 100) / 100;
}
}
//显示指定的奖罚记录
private void ShowTheRP()
{
RP rp = rpBll.GetRPByNo(No);
txtBoxNo.Text = Convert.ToString(rp.No);
txtBoxRpName.Text = rp.Rp_name;
txtBoxSal.Text = Convert.ToString(rp.Sal);
txtBoxUserId.Text = Convert.ToString(rp.User_id);
dpRPTime.SelectedDate = rp.Rp_time;
}
public ActionResult _AjaxDelete(ContentUnitMeasure item, [DataSourceRequest] DataSourceRequest request, string Lang)
{
if (ModelState.IsValid)
{
_db.ContentUnitMeasures.Remove(_db.ContentUnitMeasures.First(r => r.ID == item.ID));
_db.SaveChanges();
RP.CleanContentUnitMeasureRepository();
}
return(Json(new[] { item }.ToDataSourceResult(request, ModelState)));
}
public ActionResult _AjaxInsert([DataSourceRequest] DataSourceRequest request, ContentUnitMeasureMap item)
{
if (ModelState.IsValid)
{
_db.ContentUnitMeasureMaps.Add(item);
_db.SaveChanges();
RP.CleanContentUnitMeasureMapRepository();
}
return(Json(new[] { item }.ToDataSourceResult(request, ModelState)));
}
public static List <string> GetMenuGroups()
{
var set = RP.GetCurrentSettings();
if (!string.IsNullOrEmpty(set.MenuGroups))
{
return(set.MenuGroups.Split(',').ToList());
}
return(new List <string>());
}
public ActionResult _AjaxDelete(Translation item, [DataSourceRequest] DataSourceRequest request, string Lang)
{
if (ModelState.IsValid)
{
_db.Translations.Remove(_db.Translations.First(r => r.ID == item.ID && r.LangCode == Lang));
_db.SaveChanges();
RP.CleanTranslationsRepository();
}
return(Json(new[] { item }.ToDataSourceResult(request, ModelState)));
}
public OutEmail()
{
if (RP.GetAdminCurrentSettingsRepository() == null)
{
this.DomainID = 0;
}
else
{
this.DomainID = RP.GetAdminCurrentSettingsRepository().ID;
}
}
/// <summary>
/// 进行破防攻击，附加一定伤害
/// </summary>
/// <param name="harm">原始伤害</param>
/// <param name="attacker">攻击者</param>
/// <param name="defencer">防御者</param>
/// <param name="messageQueue">消息队列，用于输出技能释放消息</param>
/// <returns>标示是否发动成功</returns>
public override bool Onset(ref int harm, IFighter attacker, IFighter defencer, Queue <string> messageQueue)
{
if (attacker.Level >= defencer.Level)
{
harm += (attacker.Level - defencer.Level) + RP.Next(1, 3);
}
base.Onset(ref harm, attacker, defencer, messageQueue);
return(false);
}
public ActionResult RemoveNotMappedShortSku()
{
if (CurrentShop != null)
{
var ShopID = CurrentShop.ID;
var sqlcommand = string.Format("DELETE FROM [ProductSkuMaps] WHERE [ShopID] = {0} AND ([ProductSKU] IS NULL OR [ProductSKU] = N'')", ShopID);
var sqlsay = _db.Database.ExecuteSqlCommand(sqlcommand);
return(Content(RP.S("Member.ProductSkuMap.Removed") + " SQL: " + sqlcommand + " SQLRETURN: " + sqlsay.ToString()));
}
return(Content("Shop not found"));
}
public ActionResult ContentBySeo(string SeoUrl)
{
var CurrentSettings = RP.GetCurrentSettings();
var contentPage = _db.ContentPages.FirstOrDefault(x => x.SeoUrlName == SeoUrl && x.DomainID == CurrentSettings.ID);
if (contentPage != null)
{
return(PartialView(contentPage));
}
return(Content(""));
}
private void LoadMoveSub()
{
string loadplanid = WMSFactory.d_Movesub.GetLoadPlanId(Request["moveid"]);
lbbrand.Text = loadplanid;
DataTable dt = WMSFactory.d_Movesub.GetMoveSub(Request["moveid"]);
lbtotal.Text = dt.Compute("SUM(set_nums)", "").ToString();
RP.DataSource = dt;
RP.DataBind();
}
public ActionResult _AjaxInsert([DataSourceRequest] DataSourceRequest request, Translation item, string Lang)
{
if (ModelState.IsValid)
{
item.LangCode = Lang;
_db.Translations.Add(item);
_db.SaveChanges();
RP.CleanTranslationsRepository();
}
return(Json(new[] { item }.ToDataSourceResult(request, ModelState)));
}
protected void Button2_Click(object sender, EventArgs e)
{
RP rp = new RP();
rp.Update_DOJI(DrList.Text, TextBox1.Text);
if (DrList.Text == "DOJI")
{
rp.Update_DOJI("GUI", "1");
}
if (DrList.Text == "DOJIXH")
{
DateTime dts = DateTime.Now;
DateTime dte = dts;
dte = dte.AddHours(20 - dte.Hour);
dte = dte.AddMinutes(30 - dte.Minute);
rp.Update_DOJI("GUIXH", "1");
rp.Update_DOJI("XHTIMES", dts.ToString());
rp.Update_DOJI("XHTIMEE", dte.ToString());
}
}
protected void Button1_Click(object sender, EventArgs e)
{
RP rp = new RP();
TextBox1.Text = rp.Select_DOJI(DrList.Text);
}
protected void DropDownList1_TextChanged(object sender, EventArgs e)
{
RP rp = new RP();
TextBox1.Text = rp.Select_DOJI(DrList.Text);
//TextBox1.Text = DrList.Text;
}
protected void Button1_Click(object sender, EventArgs e)
{
RP rp = new RP();
rp.Update_soxo2(SX2_DATE.Text,SX2_TINH.Text,SX2_Ketqua.Text);
}
public ActionResult Index(RP.Sistema.Web.Models.Entidade.EntidadeVM viewData, HttpPostedFileBase fuFoto)
{
if (ModelState.IsValid)
{
try
{
var entidade = viewData.VM2E();
using (Context db = new Context())
{
using (var trans = new RP.DataAccess.RPTransactionScope(db))
{
BLL.EntidadeBLL entidadeBLL = new BLL.EntidadeBLL(db, _idUsuario);
if (fuFoto != null)
{
var fileBytes = new byte[fuFoto.ContentLength];
fuFoto.InputStream.Read(fileBytes, 0, fileBytes.Length);
entidade.imLogo = fileBytes;
}
else if (this.HttpContext.Request.Params.AllKeys.Contains("fuFoto"))
{
if (string.IsNullOrEmpty(this.HttpContext.Request.Params["fuFoto"]))
{
entidade.imLogo = null;
}
}
if (viewData.idEntidade != null)
{
entidadeBLL.Update(entidade);
}
else
{
entidadeBLL.Insert(entidade);
}
entidadeBLL.SaveChanges();
if (fuFoto != null)
{
entidadeBLL.UpdateLogo(entidade);
}
else if (this.HttpContext.Request.Params.AllKeys.Contains("fuFoto"))
{
if (string.IsNullOrEmpty(this.HttpContext.Request.Params["fuFoto"]))
{
entidadeBLL.RemoveLogo(entidade);
}
}
entidadeBLL.SaveChanges();
trans.Complete();
viewData.idEntidade = entidade.idEntidade;
this.AddFlashMessage("Os dados da empresa foram salvos com sucesso!", FlashMessage.SUCCESS);
return RedirectToAction("Index");
}
}
}
catch (Exception ex)
{
RP.Util.Entity.ErroLog.Add(ex, Session.SessionID, _idUsuario);
return RedirectToAction("Index", "Erro");
}
}
return View(viewData);
}
internal static DataTable GetDataTable(RP.Sistema.Model.Entities.Funcionario funcionario, DateTime competencia)
{
var _result = new DataTable("table");
_result.Columns.Add("idfuncionario", Type.GetType("System.Int32"));
_result.Columns.Add("nome", Type.GetType("System.String"));
_result.Columns.Add("tipo", Type.GetType("System.String"));
_result.Columns.Add("rg", Type.GetType("System.String"));
_result.Columns.Add("cpf", Type.GetType("System.String"));
_result.Columns.Add("email", Type.GetType("System.String"));
_result.Columns.Add("observacao", Type.GetType("System.String"));
_result.Columns.Add("numero", Type.GetType("System.String"));
_result.Columns.Add("cep", Type.GetType("System.String"));
_result.Columns.Add("logradouro", Type.GetType("System.String"));
_result.Columns.Add("bairro", Type.GetType("System.String"));
_result.Columns.Add("fone", Type.GetType("System.String"));
_result.Columns.Add("celular", Type.GetType("System.String"));
_result.Columns.Add("dtnascimento", Type.GetType("System.DateTime"));
_result.Columns.Add("dtentrada", Type.GetType("System.DateTime"));
_result.Columns.Add("salario", Type.GetType("System.Decimal"));
_result.Columns.Add("comissao", Type.GetType("System.Decimal"));
_result.Columns.Add("dtsaida", Type.GetType("System.DateTime"));
_result.Columns.Add("motivosaida", Type.GetType("System.String"));
_result.Columns.Add("status", Type.GetType("System.String"));
_result.Columns.Add("ctps", Type.GetType("System.String"));
_result.Columns.Add("entradaExtra", Type.GetType("System.String"));
_result.Columns.Add("entradaManha", Type.GetType("System.String"));
_result.Columns.Add("entradaTarde", Type.GetType("System.String"));
_result.Columns.Add("saidaManha", Type.GetType("System.String"));
_result.Columns.Add("saidaTarde", Type.GetType("System.String"));
_result.Columns.Add("saidaExtra", Type.GetType("System.String"));
_result.Columns.Add("dsDia", Type.GetType("System.String"));
_result.Columns.Add("dsObservacao", Type.GetType("System.String"));
_result.Columns.Add("flSituacao", Type.GetType("System.String"));
var inicio = competencia;
var fim = competencia.AddMonths(1);
foreach (var item in funcionario.CartaoPontos.Where(u => u.dtPonto >= inicio && u.dtPonto < fim))
{
string dsDia = competencia.Day + "º - " + new CultureInfo("pt-BR").DateTimeFormat.GetDayName(competencia.DayOfWeek);
competencia = competencia.AddDays(1);
var row = _result.NewRow();
row["idfuncionario"] = funcionario.idFuncionario;
row["nome"] = funcionario.nome;
row["tipo"] = funcionario.tipo;
row["rg"] = funcionario.rg;
row["cpf"] = funcionario.cpf;
row["email"] = funcionario.email;
row["observacao"] = funcionario.observacao;
row["numero"] = funcionario.numero;
row["cep"] = funcionario.cep;
row["logradouro"] = funcionario.logradouro;
row["bairro"] = funcionario.bairro;
row["fone"] = funcionario.fone;
row["celular"] = funcionario.celular;
row["dtnascimento"] = funcionario.dtNascimento;
row["dtentrada"] = funcionario.dtEntrada;
row["ctps"] = funcionario.ctps;
row["entradaExtra"] = item.entradaExtra;
row["entradaManha"] = item.entradaManha;
row["entradaTarde"] = item.entraTarde;
row["saidaManha"] = item.saidaManha;
row["saidaTarde"] = item.saidaTarde;
row["saidaExtra"] = item.saidaExtra;
row["dsObservacao"] = item.dsObservacao;
row["flSituacao"] = item.flSituacao;
row["dsDia"] = dsDia;
_result.Rows.Add(row);
}
return _result;
}
internal static DataTable GetDataTable(RP.Sistema.Model.Entities.FolhaPagamento _folha)
{
var _result = new DataTable("table");
System.Data.DataRow row;
_result.Columns.Add("idfuncionario", Type.GetType("System.Int32"));
_result.Columns.Add("nome", Type.GetType("System.String"));
_result.Columns.Add("tipo", Type.GetType("System.String"));
_result.Columns.Add("rg", Type.GetType("System.String"));
_result.Columns.Add("cpf", Type.GetType("System.String"));
_result.Columns.Add("email", Type.GetType("System.String"));
_result.Columns.Add("observacao", Type.GetType("System.String"));
_result.Columns.Add("numero", Type.GetType("System.String"));
_result.Columns.Add("cep", Type.GetType("System.String"));
_result.Columns.Add("logradouro", Type.GetType("System.String"));
_result.Columns.Add("bairro", Type.GetType("System.String"));
_result.Columns.Add("fone", Type.GetType("System.String"));
_result.Columns.Add("celular", Type.GetType("System.String"));
_result.Columns.Add("dtnascimento", Type.GetType("System.DateTime"));
_result.Columns.Add("dtentrada", Type.GetType("System.DateTime"));
_result.Columns.Add("salario", Type.GetType("System.Decimal"));
_result.Columns.Add("comissao", Type.GetType("System.Decimal"));
_result.Columns.Add("dtsaida", Type.GetType("System.DateTime"));
_result.Columns.Add("motivosaida", Type.GetType("System.String"));
_result.Columns.Add("status", Type.GetType("System.String"));
_result.Columns.Add("ctps", Type.GetType("System.String"));
_result.Columns.Add("total", Type.GetType("System.Decimal"));
_result.Columns.Add("bonificacao", Type.GetType("System.String"));
_result.Columns.Add("outrosDescontos", Type.GetType("System.Decimal"));
_result.Columns.Add("inss", Type.GetType("System.Decimal"));
_result.Columns.Add("vale", Type.GetType("System.Decimal"));
_result.Columns.Add("dtPagamento", Type.GetType("System.DateTime"));
_result.Columns.Add("nrAno", Type.GetType("System.Int32"));
_result.Columns.Add("nrMes", Type.GetType("System.Int32"));
_result.Columns.Add("situacao", Type.GetType("System.String"));
_result.Columns.Add("tipoMovimento", Type.GetType("System.String"));
_result.Columns.Add("descricaoMovimento", Type.GetType("System.String"));
_result.Columns.Add("valorMovimento", Type.GetType("System.Decimal"));
_result.Columns.Add("dataExtenco", Type.GetType("System.String"));
_result.Columns.Add("valorExtenco", Type.GetType("System.String"));
var culture = new CultureInfo("pt-BR");
var dtfi = culture.DateTimeFormat;
string dsMes = culture.TextInfo.ToTitleCase(dtfi.GetMonthName(_folha.nrMes));
var funcionario = _folha.Funcionario;
row = _result.NewRow();
row["idfuncionario"] = funcionario.idFuncionario;
row["nome"] = funcionario.nome;
row["tipo"] = funcionario.tipo;
row["rg"] = funcionario.rg;
row["cpf"] = funcionario.cpf;
row["email"] = funcionario.email;
row["observacao"] = funcionario.observacao;
row["numero"] = funcionario.numero;
row["cep"] = funcionario.cep;
row["logradouro"] = funcionario.logradouro;
row["bairro"] = funcionario.bairro;
row["fone"] = funcionario.fone;
row["celular"] = funcionario.celular;
row["dtnascimento"] = funcionario.dtNascimento;
row["dtentrada"] = funcionario.dtEntrada;
row["ctps"] = funcionario.ctps;
row["valorExtenco"] = RP.Util.Class.Converter.toExtenso(_folha.total);
row["dataExtenco"] = dsMes + " de " + _folha.nrAno;
row["total"] = _folha.total;
if (_folha.salario > 0)
{
row = _result.NewRow();
row["idfuncionario"] = funcionario.idFuncionario;
row["nome"] = funcionario.nome;
row["tipo"] = funcionario.tipo;
row["rg"] = funcionario.rg;
row["cpf"] = funcionario.cpf;
row["email"] = funcionario.email;
row["observacao"] = funcionario.observacao;
row["numero"] = funcionario.numero;
row["cep"] = funcionario.cep;
row["logradouro"] = funcionario.logradouro;
row["bairro"] = funcionario.bairro;
row["fone"] = funcionario.fone;
row["celular"] = funcionario.celular;
row["dtnascimento"] = funcionario.dtNascimento;
row["dtentrada"] = funcionario.dtEntrada;
row["ctps"] = funcionario.ctps;
row["valorExtenco"] = RP.Util.Class.Converter.toExtenso(_folha.total);
row["dataExtenco"] = dsMes + " de " + _folha.nrAno;
row["nrAno"] = _folha.nrAno;
row["nrMes"] = _folha.nrMes;
row["valorMovimento"] = _folha.salario;
row["descricaoMovimento"] = "Salário normal";
row["tipoMovimento"] = "Comissão";
row["total"] = _folha.total;
_result.Rows.Add(row);
}
if (_folha.horaExtra > 0)
{
row = _result.NewRow();
row["idfuncionario"] = funcionario.idFuncionario;
row["nome"] = funcionario.nome;
row["tipo"] = funcionario.tipo;
row["rg"] = funcionario.rg;
row["cpf"] = funcionario.cpf;
row["email"] = funcionario.email;
row["observacao"] = funcionario.observacao;
row["numero"] = funcionario.numero;
row["cep"] = funcionario.cep;
row["logradouro"] = funcionario.logradouro;
row["bairro"] = funcionario.bairro;
row["fone"] = funcionario.fone;
row["celular"] = funcionario.celular;
row["dtnascimento"] = funcionario.dtNascimento;
row["dtentrada"] = funcionario.dtEntrada;
row["ctps"] = funcionario.ctps;
row["valorExtenco"] = RP.Util.Class.Converter.toExtenso(_folha.total);
row["dataExtenco"] = dsMes + " de " + _folha.nrAno;
row["nrAno"] = _folha.nrAno;
row["nrMes"] = _folha.nrMes;
row["valorMovimento"] = _folha.horaExtra;
row["descricaoMovimento"] = "Total de horas extras referente";
row["tipoMovimento"] = "Comissão";
row["total"] = _folha.total;
_result.Rows.Add(row);
}
if (_folha.outrosDescontos > 0)
{
row = _result.NewRow();
row["idfuncionario"] = funcionario.idFuncionario;
row["nome"] = funcionario.nome;
row["tipo"] = funcionario.tipo;
row["rg"] = funcionario.rg;
row["cpf"] = funcionario.cpf;
row["email"] = funcionario.email;
row["observacao"] = funcionario.observacao;
row["numero"] = funcionario.numero;
row["cep"] = funcionario.cep;
row["logradouro"] = funcionario.logradouro;
row["bairro"] = funcionario.bairro;
row["fone"] = funcionario.fone;
row["celular"] = funcionario.celular;
row["dtnascimento"] = funcionario.dtNascimento;
row["dtentrada"] = funcionario.dtEntrada;
row["ctps"] = funcionario.ctps;
row["valorExtenco"] = RP.Util.Class.Converter.toExtenso(_folha.total);
row["dataExtenco"] = dsMes + " de " + _folha.nrAno;
row["nrAno"] = _folha.nrAno;
row["nrMes"] = _folha.nrMes;
row["vale"] = _folha.outrosDescontos;
row["descricaoMovimento"] = _folha.dsOutrosDescontos;
row["tipoMovimento"] = "Vale";
row["total"] = _folha.total;
_result.Rows.Add(row);
}
if (_folha.inss > 0)
{
row = _result.NewRow();
row["idfuncionario"] = funcionario.idFuncionario;
row["nome"] = funcionario.nome;
row["tipo"] = funcionario.tipo;
row["rg"] = funcionario.rg;
row["cpf"] = funcionario.cpf;
row["email"] = funcionario.email;
row["observacao"] = funcionario.observacao;
row["numero"] = funcionario.numero;
row["cep"] = funcionario.cep;
row["logradouro"] = funcionario.logradouro;
row["bairro"] = funcionario.bairro;
row["fone"] = funcionario.fone;
row["celular"] = funcionario.celular;
row["dtnascimento"] = funcionario.dtNascimento;
row["dtentrada"] = funcionario.dtEntrada;
row["ctps"] = funcionario.ctps;
row["valorExtenco"] = RP.Util.Class.Converter.toExtenso(_folha.total);
row["dataExtenco"] = dsMes + " de " + _folha.nrAno;
row["nrAno"] = _folha.nrAno;
row["nrMes"] = _folha.nrMes;
row["total"] = _folha.total;
row["vale"] = _folha.inss;
row["descricaoMovimento"] = "INSS";
row["tipoMovimento"] = "Vale";
_result.Rows.Add(row);
}
if (_folha.inss > 0)
{
row = _result.NewRow();
row["idfuncionario"] = funcionario.idFuncionario;
row["nome"] = funcionario.nome;
row["tipo"] = funcionario.tipo;
row["rg"] = funcionario.rg;
row["cpf"] = funcionario.cpf;
row["email"] = funcionario.email;
row["observacao"] = funcionario.observacao;
row["numero"] = funcionario.numero;
row["cep"] = funcionario.cep;
row["logradouro"] = funcionario.logradouro;
row["bairro"] = funcionario.bairro;
row["fone"] = funcionario.fone;
row["celular"] = funcionario.celular;
row["dtnascimento"] = funcionario.dtNascimento;
row["dtentrada"] = funcionario.dtEntrada;
row["ctps"] = funcionario.ctps;
row["valorExtenco"] = RP.Util.Class.Converter.toExtenso(_folha.total);
row["dataExtenco"] = dsMes + " de " + _folha.nrAno;
row["nrAno"] = _folha.nrAno;
row["nrMes"] = _folha.nrMes;
row["total"] = _folha.total;
row["vale"] = _folha.FGTS;
row["descricaoMovimento"] = "FGTS";
row["tipoMovimento"] = "Vale";
_result.Rows.Add(row);
}
if (_folha.bonificacao > 0)
{
row = _result.NewRow();
row["idfuncionario"] = funcionario.idFuncionario;
row["nome"] = funcionario.nome;
row["tipo"] = funcionario.tipo;
row["rg"] = funcionario.rg;
row["cpf"] = funcionario.cpf;
row["email"] = funcionario.email;
row["observacao"] = funcionario.observacao;
row["numero"] = funcionario.numero;
row["cep"] = funcionario.cep;
row["logradouro"] = funcionario.logradouro;
row["bairro"] = funcionario.bairro;
row["fone"] = funcionario.fone;
row["celular"] = funcionario.celular;
row["dtnascimento"] = funcionario.dtNascimento;
row["dtentrada"] = funcionario.dtEntrada;
row["ctps"] = funcionario.ctps;
row["valorExtenco"] = RP.Util.Class.Converter.toExtenso(_folha.total);
row["dataExtenco"] = dsMes + " de " + _folha.nrAno;
row["nrAno"] = _folha.nrAno;
row["nrMes"] = _folha.nrMes;
row["total"] = _folha.total;
row["valorMovimento"] = _folha.bonificacao;
row["descricaoMovimento"] = _folha.dsBonificacao;
row["tipoMovimento"] = "Comissão";
_result.Rows.Add(row);
}
if (_folha.MovimentoProfissionais.Any())
{
foreach (var movimento in _folha.MovimentoProfissionais.ToList())
{
row = _result.NewRow();
row["idfuncionario"] = funcionario.idFuncionario;
row["nome"] = funcionario.nome;
row["tipo"] = funcionario.tipo;
row["rg"] = funcionario.rg;
row["cpf"] = funcionario.cpf;
row["email"] = funcionario.email;
row["observacao"] = funcionario.observacao;
row["numero"] = funcionario.numero;
row["cep"] = funcionario.cep;
row["logradouro"] = funcionario.logradouro;
row["bairro"] = funcionario.bairro;
row["fone"] = funcionario.fone;
row["celular"] = funcionario.celular;
row["dtnascimento"] = funcionario.dtNascimento;
row["dtentrada"] = funcionario.dtEntrada;
row["ctps"] = funcionario.ctps;
row["valorExtenco"] = RP.Util.Class.Converter.toExtenso(_folha.total);
row["dataExtenco"] = dsMes + " de " + _folha.nrAno;
row["nrAno"] = _folha.nrAno;
row["nrMes"] = _folha.nrMes;
row["total"] = _folha.total;
if (movimento.tipo == MovimentoProfissional.TIPO_VALE)
{
row["vale"] = movimento.valor;
row["descricaoMovimento"] = movimento.descricao + " - " + movimento.dtLancamento.ToString("dd/MM/yyyy");
}
else
{
row["descricaoMovimento"] = movimento.descricao;
row["valorMovimento"] = movimento.valor;
}
row["tipoMovimento"] = movimento.tipo;
_result.Rows.Add(row);
}
}
return _result;
}
protected void Button3_Click(object sender, EventArgs e)
{
RP del = new RP();
del.Delete_Football(DropDownList2.Text, DropDownList1.Text, txt_Stime.Text, txt_Etime.Text);
}
protected void Button2_Click(object sender, EventArgs e)
{
RP upd = new RP();
upd.Update_Football(DropDownList2.Text, DropDownList1.Text, txt_Stime.Text, txt_Etime.Text, txt_Content.Text);
}
protected void Button1_Click(object sender, EventArgs e)
{
RP ins = new RP();
ins.Insert_Football(DropDownList2.Text, DropDownList1.Text, txt_Stime.Text, txt_Etime.Text, txt_Content.Text);
}
protected void Button7_Click(object sender, EventArgs e)
{
RP rp = new RP();
rp.Update_soxo("Dacbiet", txt_sx_8.Text, SX_DATE.Text);
}
protected void Button8_Click(object sender, EventArgs e)
{
RP rp = new RP();
rp.Update_soxo("Tu", txt_sx_4.Text, SX_DATE.Text);
}
public ActionResult Edit(RP.Sistema.Web.Models.Area.AreaVM viewData)
{
try
{
LogBLL.Insert(new LogDado("Edit(RP.Sistema.Web.Models.Area.AreaVM viewData)", "Area", _idUsuario));
if (ModelState.IsValid)
{
var area = viewData.VM2E();
using (Context db = new Context())
{
using (var trans = new RP.DataAccess.RPTransactionScope(db))
{
area.flUsaURL = area.flUsaURL.ToLower() == "true" || area.flUsaURL.ToLower() == "sim" ? "Sim" : "Não";
area.idModulo = area.idModulo;
BLL.AreaBLL areaBLL = new BLL.AreaBLL(db, _idUsuario);
areaBLL.Update(area);
areaBLL.SaveChanges();
trans.Complete();
this.AddFlashMessage(RP.Util.Resource.Message.EDIT_SUCCESS, FlashMessage.SUCCESS);
return RedirectToAction("Index");
}
}
}
return View(viewData);
}
catch (Exception ex)
{
this.AddFlashMessage(RP.Util.Exception.Message.Get(ex), FlashMessage.ERROR); RP.Util.Entity.ErroLog.Add(ex, Session.SessionID, _idUsuario); RP.Util.Entity.ErroLog.Add(ex, Session.SessionID, _idUsuario);
return RedirectToAction("Index");
}
}
protected void Button2_Click(object sender, EventArgs e)
{
RP rp = new RP();
rp.Insert_dichvukhach(DVK_CMD.Text, DVK_Subcmd.Text, DVK_service.Text, DVK_Content.Text, DVK_Date.Text);
}
public ActionResult Edit(RP.Sistema.Web.Models.Modulo.ModuloVM viewData)
{
try
{
if (ModelState.IsValid)
{
var modulo = viewData.VM2E();
using (Context db = new Context())
{
using (var trans = new RP.DataAccess.RPTransactionScope(db))
{
BLL.ModuloBLL moduloBLL = new BLL.ModuloBLL(db, _idUsuario);
moduloBLL.Update(modulo);
moduloBLL.SaveChanges();
trans.Complete();
this.AddFlashMessage(RP.Util.Resource.Message.EDIT_SUCCESS, FlashMessage.SUCCESS);
return RedirectToAction("Index");
}
}
}
return View(viewData);
}
catch (Exception ex)
{
this.AddFlashMessage(RP.Util.Exception.Message.Get(ex), FlashMessage.ERROR); RP.Util.Entity.ErroLog.Add(ex, Session.SessionID, _idUsuario);
return RedirectToAction("Index");
}
}
