private void btnSave_Click(object sender, EventArgs e)
{
foreach (var x in DetailGB.Controls.OfType <TextBox>())
{
if (isBlank(x))
{
MessageBox.Show("Please fill the blank field ==\"");
return;
}
}
DateTime start = DateTime.ParseExact(StartTimeTb.Text, "HH:mm:ss", new DateTimeFormatInfo());
DateTime end = DateTime.ParseExact(ArrivalTimeTb.Text, "HH:mm:ss", new DateTimeFormatInfo());
TimeSpan Duration = end.Subtract(start);
string query = default;
if (func == "Edit")
{
if (CheckDriver(SourceTb.Text, LastestPosition(cbIDDriver.Text, DateTripTb.Value.ToString("yyyy-MM-dd")), CheckDate(cbIDDriver.Text, DateTripTb.Value.ToString("yyyy-MM-dd"))) || LastestPosition(cbIDDriver.Text, DateTripTb.Value.ToString("yyyy-MM-dd")).Equals(""))
{
query = string.Format("UPDATE TRIP SET Source = '{0}', Destination = '{1}', Date_Trip = '{2}', Start_Time = '{3}', Arrival_Time = '{4}', " +
"Duration = '{5}', Total_Seat = '{6}', Price = '{7}', Discount = '{8}', ID_Driver = '{9}', ID_Manager = '{10}' " +
"WHERE ID_Trip = '{11}'",
SourceTb.Text, DestinationTb.Text, DateTripTb.Value, start.ToString(), end.ToString(), Duration.ToString(),
TotalSeatTb.Text, PriceTb.Text, DiscountTb.Text, cbIDDriver.Text, this.ID_Mana, this.ID_Trip);
sql.Add(query);
MessageBox.Show("Successfully!!");
}
else if (!CheckDate(cbIDDriver.Text, DateTripTb.Value.ToString("yyyy-MM-dd")))
{
MessageBox.Show("Driver has a trip on this day!");
}
else if (!string.Equals(SourceTb.Text, LastestPosition(cbIDDriver.Text, DateTripTb.Value.ToString("yyyy-MM-dd"))))
{
MessageBox.Show("Driver is not in " + SourceTb.Text.ToString());
}
}
else if (func == "Add")
{
query = string.Format("INSERT INTO TRIP VALUES('{0}', '{1}', '{2}', '{3}', '{4}', " +
"'{5}', {6}, {7}, {8}, {9}, '{10}','{11}') ",
SourceTb.Text, DestinationTb.Text, DateTripTb.Value.ToString(), start.ToString(), end.ToString(), Duration.ToString(),
TotalSeatTb.Text, TotalSeatTb.Text, PriceTb.Text, DiscountTb.Text, cbIDDriver.Text.ToString(), this.ID_Mana);
sql.Add(query);
MessageBox.Show("Successfully!!");
}
DetailGB.Enabled = false;
DataShow.DataSource = sql.Read(default_query).Tables[0];
}
public static AddedView AddedFabricator(DicFabricator fabricator)
{
var tbFabricator = new TextBox()
{
Margin = new Thickness(10, 0, 10, 10)
};
var lblFE = new Label()
{
Content = "Необходимо заполнить Производитель", Foreground = Brushes.Red, Visibility = Visibility.Collapsed
};
var a = new AddedView
{
Controls = new List <Control> {
new Label()
{
Content = "Производитель", Margin = new Thickness(10, 10, 10, 0)
},
tbFabricator,
lblFE
}
};
if (fabricator == null)
{
a.Submit = new SimpleCommand(() =>
{
if (string.IsNullOrEmpty(tbFabricator.Text.Trim()))
{
lblFE.Visibility = Visibility.Visible;
return;
}
SQL.Add(new DicFabricator()
{
Fabricator = tbFabricator.Text
});
a.Close();
});
}
else
{
tbFabricator.Text = fabricator.Fabricator;
a.Submit = new SimpleCommand(() =>
{
if (string.IsNullOrEmpty(tbFabricator.Text.Trim()))
{
lblFE.Visibility = Visibility.Visible;
return;
}
SQL.Update(new DicFabricator()
{
IdFabricator = fabricator.IdFabricator, Fabricator = tbFabricator.Text
});
a.Close();
});
}
a.Init();
mainWindow.ShowAddedWindow(a);
return(a);
}
public WorkViewModel(Orders orders)
{
_orders = orders;
Delete = new SimpleCommand(id =>
{
SQL.Delete(SQL.GetWork().First(w => w.Id == (int)id));
SQL.AddHistory(_orders.IdOrder, String.Format("Удаление работы: {0}", WorkName));
Load();
});
Edit = new SimpleCommand(id =>
{
var a = ShowWin.AddedWork(SQL.GetWork().First(w => w.Id == (int)id));
a.OnClose += Load;
});
AddWork = new SimpleCommand(() =>
{
if (!SQL.GetDicWork().Contains(WorkName))
{
SQL.Add(new DicWork()
{
Work = WorkName, Price = Price
});
}
SQL.Add(new Works()
{
IdOrder = _orders.IdOrder,
IdWork = SQL.GetIdWork(WorkName),
Count = Count == 0 ? 1 : Count,
Price = Price
});
SQL.AddHistory(_orders.IdOrder, String.Format("Добавлена работа: {0}", WorkName));
Load();
});
Load();
DicWorkEntries.CurrentChanged +=
(u, e) =>
{
if (DicWorkEntries.CurrentItem != null)
{
Price =
SQL.GetAllDicWork()
.First(w => w.IdWork == SQL.GetIdWork(DicWorkEntries.CurrentItem.ToString()))
.Price;
}
};
}
public static AddedView AddedExecutors(Executors executors)
{
var tbExecutors = new TextBox()
{
Margin = new Thickness(10, 0, 10, 10)
};
var a = new AddedView {
Controls = new List <Control> {
new Label()
{
Content = "Исполнитель", Margin = new Thickness(10, 10, 10, 0)
}, tbExecutors
}
};
if (executors == null)
{
a.Submit = new SimpleCommand(() =>
{
SQL.Add(new Executors()
{
Name = tbExecutors.Text
});
a.Close();
});
}
else
{
tbExecutors.Text = executors.Name;
a.Submit = new SimpleCommand(() =>
{
SQL.Update(new Executors()
{
IdExecutor = executors.IdExecutor, Name = tbExecutors.Text
});
a.Close();
});
}
a.Init();
mainWindow.ShowAddedWindow(a);
return(a);
}
public static AddedView AddedDicWork(DicWork work)
{
var tbWork = new TextBox()
{
Margin = new Thickness(10, 0, 10, 10)
};
var tbPrice = new TextBox()
{
Margin = new Thickness(10, 0, 10, 10)
};
var tbDescription = new TextBox()
{
Margin = new Thickness(10, 0, 10, 10)
};
var a = new AddedView
{
Controls = new List <Control>
{
new Label()
{
Content = "Работа", Margin = new Thickness(10, 10, 10, 0)
},
tbWork,
new Label()
{
Content = "Цена", Margin = new Thickness(10, 10, 10, 0)
},
tbPrice,
new Label()
{
Content = "Описание", Margin = new Thickness(10, 10, 10, 0)
},
tbDescription
}
};
if (work == null)
{
a.Submit = new SimpleCommand(() =>
{
SQL.Add(new DicWork()
{
Work = tbWork.Text, Price = Int32.Parse(tbPrice.Text), Description = tbDescription.Text
});
a.Close();
});
}
else
{
tbWork.Text = work.Work;
tbPrice.Text = work.Price.ToString();
tbDescription.Text = work.Description;
a.Submit = new SimpleCommand(() =>
{
SQL.Update(new DicWork()
{
Work = tbWork.Text, Price = Int32.Parse(tbPrice.Text), Description = tbDescription.Text
});
a.Close();
});
}
a.Init();
mainWindow.ShowAddedWindow(a);
return(a);
}
public static AddedView AddedTypeDevice(DicTypesDevices type)
{
var tbType = new TextBox()
{
Margin = new Thickness(10, 0, 10, 10)
};
var lblTypeE = new Label()
{
Content = "Необходимо заполнить Тип устройства", Foreground = Brushes.Red, Visibility = Visibility.Collapsed
};
var a = new AddedView
{
Controls = new List <Control>
{
new Label()
{
Content = "Тип устройства", Margin = new Thickness(10, 10, 10, 0)
},
tbType,
lblTypeE
}
};
if (type == null)
{
a.Submit = new SimpleCommand(() =>
{
if (string.IsNullOrEmpty(tbType.Text.Trim()))
{
lblTypeE.Visibility = Visibility.Visible;
return;
}
SQL.Add(new DicTypesDevices()
{
Type = tbType.Text
});
a.Close();
});
}
else
{
tbType.Text = type.Type;
a.Submit = new SimpleCommand(() =>
{
if (string.IsNullOrEmpty(tbType.Text.Trim()))
{
lblTypeE.Visibility = Visibility.Visible;
return;
}
SQL.Update(new DicTypesDevices()
{
IdType = type.IdType, Type = tbType.Text
});
a.Close();
});
}
a.Init();
mainWindow.ShowAddedWindow(a);
return(a);
}
public static AddedView AddedWork(Works works)
{
var cbWork = new ComboBox()
{
Text = SQL.GetWork(works.IdWork),
Margin = new Thickness(10, 0, 10, 10),
ItemsSource = SQL.GetDicWork(),
IsEditable = true
};
var tbPrice = new TextBox()
{
Text = works.Price.ToString(CultureInfo.InvariantCulture),
Margin = new Thickness(10, 0, 10, 10)
};
var tbCount = new TextBox()
{
Text = works.Count.ToString(), Margin = new Thickness(10, 0, 10, 10)
};
var lblW = new Label()
{
Content = "Необходимо заполнить Работу", Foreground = Brushes.Red, Visibility = Visibility.Collapsed
};
var lblP = new Label()
{
Content = "Необходимо заполнить Цену", Foreground = Brushes.Red, Visibility = Visibility.Collapsed
};
var lblPInt = new Label()
{
Content = "Цена должна быть числом", Foreground = Brushes.Red, Visibility = Visibility.Collapsed
};
var lblC = new Label()
{
Content = "Необходимо заполнить Количество", Foreground = Brushes.Red, Visibility = Visibility.Collapsed
};
var lblCInt = new Label()
{
Content = "Количество должно быть числом", Foreground = Brushes.Red, Visibility = Visibility.Collapsed
};
var a = new AddedView
{
Controls = new List <Control>
{
new Label()
{
Content = "Работа", Margin = new Thickness(10, 0, 10, 0)
},
cbWork, lblW,
new Label()
{
Content = "Цена", Margin = new Thickness(10, 0, 10, 0)
},
tbPrice, lblP, lblPInt,
new Label()
{
Content = "Количество", Margin = new Thickness(10, 0, 10, 0)
},
tbCount, lblC, lblCInt
}
};
a.Submit = new SimpleCommand(() =>
{
int res;
lblW.Visibility = (string.IsNullOrEmpty(cbWork.Text.Trim())) ? Visibility.Visible : Visibility.Collapsed;
lblP.Visibility = (string.IsNullOrEmpty(tbPrice.Text.Trim())) ? Visibility.Visible : Visibility.Collapsed;
lblC.Visibility = (string.IsNullOrEmpty(tbCount.Text.Trim())) ? Visibility.Visible : Visibility.Collapsed;
lblPInt.Visibility = (!Int32.TryParse(tbPrice.Text.Trim(), out res)) ? Visibility.Visible : Visibility.Collapsed;
lblCInt.Visibility = (!Int32.TryParse(tbCount.Text.Trim(), out res)) ? Visibility.Visible : Visibility.Collapsed;
if (lblW.Visibility == Visibility.Visible || lblP.Visibility == Visibility.Visible ||
lblC.Visibility == Visibility.Visible || lblPInt.Visibility == Visibility.Visible || lblCInt.Visibility == Visibility.Visible)
{
return;
}
if (!SQL.GetDicWork().Contains(cbWork.Text))
{
SQL.Add(new DicWork()
{
Work = cbWork.Text, Price = Int32.Parse(tbPrice.Text)
});
}
var newW = new Works()
{
Id = works.Id,
IdOrder = works.IdOrder,
IdWork = SQL.GetIdWork(cbWork.Text),
Count = Int32.Parse(tbCount.Text) == 0 ? 1 : Int32.Parse(tbCount.Text),
Price = Int32.Parse(tbPrice.Text)
};
string message = "";
if (works.IdWork != newW.IdWork)
{
message += String.Format("Работа с {0} на {1}; ", SQL.GetWork(works.IdWork), cbWork.Text);
}
if (works.Price != newW.Price)
{
message += String.Format("Цена с {0} на {1};", works.Price, newW.Price);
}
if (works.Count != newW.Count)
{
message += String.Format("Количество с {0} на {1}; ", works.Count, newW.Count);
}
SQL.AddHistory(works.IdOrder, String.Format("Работа {1} изменена: {0}", message, SQL.GetWork(works.IdWork)));
SQL.Update(newW);
a.Close();
});
a.Init();
mainWindow.ShowAddedWindow(a);
return(a);
}
public static AddedView AddedMalfunction(DicMalfunction malfunction)
{
var tbMalfunction = new TextBox()
{
Margin = new Thickness(10, 0, 10, 10)
};
var lblM = new Label()
{
Content = "Необходимо заполнить Неисправность", Foreground = Brushes.Red, Visibility = Visibility.Collapsed
};
var a = new AddedView
{
Controls = new List <Control>
{
new Label()
{
Content = "Неисправность", Margin = new Thickness(10, 0, 10, 0)
},
tbMalfunction
}
};
if (malfunction == null)
{
a.Submit = new SimpleCommand(() =>
{
if (string.IsNullOrEmpty(tbMalfunction.Text.Trim()))
{
lblM.Visibility = Visibility.Visible;
return;
}
SQL.Add(new DicMalfunction()
{
Malfunction = tbMalfunction.Text
});
a.Close();
});
}
else
{
tbMalfunction.Text = malfunction.Malfunction;
a.Submit = new SimpleCommand(() =>
{
if (string.IsNullOrEmpty(tbMalfunction.Text.Trim()))
{
lblM.Visibility = Visibility.Visible;
return;
}
SQL.Update(new DicMalfunction()
{
IdMalfunction = malfunction.IdMalfunction,
Malfunction = tbMalfunction.Text
});
a.Close();
});
}
a.Init();
mainWindow.ShowAddedWindow(a);
return(a);
}
public static AddedView AddedAppearance(DicAppearance appearance)
{
var tbAppearance = new TextBox()
{
Margin = new Thickness(10, 0, 10, 10)
};
var lblA = new Label()
{
Content = "Необходимо заполнить Внешний вид", Foreground = Brushes.Red, Visibility = Visibility.Collapsed
};
var a = new AddedView
{
Controls = new List <Control>
{
new Label()
{
Content = "Внешний вид", Margin = new Thickness(10, 0, 10, 0)
},
tbAppearance,
lblA
}
};
if (appearance == null)
{
a.Submit = new SimpleCommand(() =>
{
if (string.IsNullOrEmpty(tbAppearance.Text.Trim()))
{
lblA.Visibility = Visibility.Visible;
return;
}
SQL.Add(new DicAppearance()
{
Appearance = tbAppearance.Text
});
a.Close();
});
}
else
{
tbAppearance.Text = appearance.Appearance;
a.Submit = new SimpleCommand(() =>
{
if (string.IsNullOrEmpty(tbAppearance.Text.Trim()))
{
lblA.Visibility = Visibility.Visible;
return;
}
SQL.Update(new DicAppearance()
{
IdAppearance = appearance.IdAppearance,
Appearance = tbAppearance.Text
});
a.Close();
});
}
a.Init();
mainWindow.ShowAddedWindow(a);
return(a);
}
public static AddedView AddedEquipment(DicEquipment equipment)
{
var cbType = new ComboBox()
{
Margin = new Thickness(10, 0, 10, 10), ItemsSource = SQL.GetTypesDevices().Select(s => s.Type)
};
var lblT = new Label()
{
Content = "Необходимо заполнить Тип устройства", Foreground = Brushes.Red, Visibility = Visibility.Collapsed
};
var tbEquip = new TextBox()
{
Margin = new Thickness(10, 0, 10, 10)
};
var lblE = new Label()
{
Content = "Необходимо заполнить Комплектацию", Foreground = Brushes.Red, Visibility = Visibility.Collapsed
};
var a = new AddedView
{
Controls = new List <Control>
{
new Label()
{
Content = "Тип устройства", Margin = new Thickness(10, 0, 10, 0)
},
cbType,
lblT,
new Label()
{
Content = "Комплектация", Margin = new Thickness(10, 0, 10, 0)
},
tbEquip,
lblE
}
};
if (equipment == null)
{
a.Submit = new SimpleCommand(() =>
{
if (string.IsNullOrEmpty(cbType.Text.Trim()) || (string.IsNullOrEmpty(tbEquip.Text.Trim())))
{
lblT.Visibility = (string.IsNullOrEmpty(cbType.Text.Trim())) ? Visibility.Visible : Visibility.Collapsed;
lblE.Visibility = (string.IsNullOrEmpty(tbEquip.Text.Trim())) ? Visibility.Visible : Visibility.Collapsed;
return;
}
SQL.Add(new DicEquipment()
{
IdTypeDevices = SQL.GetIdTypeDevice(cbType.SelectedItem.ToString()),
Equipment = tbEquip.Text
});
a.Close();
});
}
else
{
tbEquip.Text = equipment.Equipment;
cbType.SelectedValue = SQL.GetTypesDevices(equipment.IdTypeDevices);
a.Submit = new SimpleCommand(() =>
{
if (string.IsNullOrEmpty(cbType.Text.Trim()) || (string.IsNullOrEmpty(tbEquip.Text.Trim())))
{
lblT.Visibility = (string.IsNullOrEmpty(cbType.Text.Trim())) ? Visibility.Visible : Visibility.Collapsed;
lblE.Visibility = (string.IsNullOrEmpty(tbEquip.Text.Trim())) ? Visibility.Visible : Visibility.Collapsed;
return;
}
SQL.Update(new DicEquipment()
{
IdEquipment = equipment.IdEquipment,
IdTypeDevices = SQL.GetIdTypeDevice(cbType.SelectedItem.ToString()),
Equipment = tbEquip.Text
});
a.Close();
});
}
a.Init();
mainWindow.ShowAddedWindow(a);
return(a);
}
public void SetInitialDataBase(string initialDataBase)
{
sql.Add("DataBase", initialDataBase);
}
public void Test()
{
var insert = "insert into dzfphx VALUES('invoiceNo',@requestId);";
_ = new SQL(insert);
string sql = "select * from fei_users a , fei_data , fei_userdetails b on a.uid=b.uid where a.uid < 100";
SQL sQL = sql;
var sql2 = @"select
replace(ywdjid,' ','') as ddbh
case when not=1 then status else not end
from [dbo].[xsfp]
where ywrq >dateadd(day,-5,getdate())
and ywdjid>'FPXLSY00071582'
and not = 1
and not exists (select ywdjid from cwk where yikaifp!='是')
group by ywdjid
having sum(spje)!=0 ";
_ = new SQL(sql2);
SQL sQL1 = new SQL(@"
/*
Navicat Premium Data Transfer
Source Server : MySQL
Source Server Type : MySQL
Source Server Version : 80013
Source Host : 47.107.124.30:3306
Source Schema : yep.v3.auth
Target Server Type : MySQL
Target Server Version : 80013
File Encoding : 65001
Date: 16/10/2019 09:30:09
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for yep_companys
-- ----------------------------
DROP TABLE IF EXISTS [yep_companys];
-- ----------------------------
-- Table structure for yep_auth_ship
-- ----------------------------
CREATE TABLE IF NOT EXISTS yep_auth_ship (
id bigint(20) NOT NULL,
owner_id bigint(20) UNSIGNED NOT NULL,
auth_id int(11) NOT NULL,
type tinyint(4) NOT NULL,
status int(11) NOT NULL,
created timestamp(0) NULL,
modified timestamp(0) NULL DEFAULT NULL,
PRIMARY KEY (id) USING BTREE,
CONSTRAINT FK_yep_companys_id FOREIGN KEY (owner_id) REFERENCES yep_companys (id) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic
DELETE FROM yep_auth_ship;
-- ----------------------------
-- Table structure for yep_auth_tree
-- ----------------------------
CREATE TABLE IF NOT EXISTS yep_auth_tree (
Id int(11) NOT NULL AUTO_INCREMENT,
parent_id int(11) NOT NULL,
disp_order int(11) NOT NULL,
has_child bit(1) NOT NULL,
code varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
url varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
type tinyint(4) NOT NULL COMMENT '0：项目\r\n1：导航\r\n2：菜单\r\n4：页面\r\n8：功能\r\n16：板块\r\n32：提示\r\n64：标记',
status tinyint(255) NOT NULL,
created timestamp(0) NULL,
modified timestamp(0) NULL,
PRIMARY KEY (Id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 125 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for yep_org_tree
-- ----------------------------
CREATE TABLE IF NOT EXISTS yep_org_tree (
Id bigint(20) UNSIGNED NOT NULL,
parent_id bigint(20) UNSIGNED NOT NULL,
disp_order int(11) NOT NULL,
has_child bit(1) NOT NULL,
code varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
name varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
type tinyint(4) NOT NULL COMMENT '1：集团\r\n2：单位\r\n4：部门\r\n8：商铺\r\n16：虚拟节点',
status tinyint(4) NOT NULL,
created timestamp(0) NULL,
modified timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
PRIMARY KEY (Id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for yep_orm_test
-- ----------------------------
CREATE TABLE IF NOT EXISTS yep_orm_test (
Id bigint(20) NOT NULL,
Name varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
Status varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
Created timestamp(0) NULL,
Modified timestamp(3) NULL,
PRIMARY KEY (Id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for yep_users
-- ----------------------------
CREATE TABLE IF NOT EXISTS yep_users (
Id bigint(20) UNSIGNED NOT NULL,
org_id bigint(20) UNSIGNED NOT NULL COMMENT '所在机构树节点ID',
company_id bigint(20) UNSIGNED NOT NULL COMMENT '所在单位',
account varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '账户',
role int(11) NOT NULL COMMENT '角色',
name varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称',
wechat_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '微信ID',
alipay_id varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '支付宝ID',
tel varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '联系电话',
mail varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '邮箱地址',
avatar varchar(160) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '头像',
sex tinyint(4) NOT NULL COMMENT '性别',
password varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
salt varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '加盐',
extends_enum int(11) NOT NULL COMMENT '扩展信息',
status int(11) NOT NULL COMMENT '状态',
registered timestamp(0) NULL DEFAULT NULL COMMENT '注册日期时间戳',
modified timestamp(3) NULL DEFAULT NULL,
PRIMARY KEY (Id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for yep_tax_code
-- ----------------------------
CREATE TABLE IF NOT EXISTS yep_tax_code (
id varchar(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
parent_id varchar(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
level int(11) NOT NULL,
name varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
short_name varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
specification varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
unit varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
price decimal(18, 2) NOT NULL,
use_policy bit(1) NOT NULL,
policy_type tinyint(4) NOT NULL,
tax_rate double NOT NULL,
free_tax_type tinyint(4) NOT NULL,
has_tax bit(1) NOT NULL,
special_manage varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
introduction varchar(2048) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
status tinyint(4) NOT NULL,
is_last_children bit(1) NOT NULL DEFAULT b'0',
create_time timestamp(0) NULL DEFAULT NULL,
modify_time timestamp(0) NULL DEFAULT NULL,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;");
/**
* SET NAMES utf8mb4;
* SET FOREIGN_KEY_CHECKS = 0;
* DROP TABLE IF EXISTS {DROP#yep_companys};
* CREATE TABLE IF NOT EXISTS {CREATE#yep_auth_ship} (
* [id] bigint(20) NOT NULL,
* [owner_id] bigint(20) UNSIGNED NOT NULL,
* [auth_id] int(11) NOT NULL,
* [type] tinyint(4) NOT NULL,
* [status] int(11) NOT NULL,
* [created] timestamp(0) NULL,
* [modified] timestamp(0) NULL DEFAULT NULL,
* PRIMARY KEY ([id]) USING BTREE,
* CONSTRAINT FK_yep_companys_id FOREIGN KEY ([owner_id]) REFERENCES yep_companys ([id]) ON DELETE SET NULL ON UPDATE CASCADE
* ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic
* DELETE FROM yep_auth_ship;
* CREATE TABLE IF NOT EXISTS {CREATE#yep_auth_tree} (
* [Id] int(11) NOT NULL AUTO_INCREMENT,
* [parent_id] int(11) NOT NULL,
* [disp_order] int(11) NOT NULL,
* [has_child] bit(1) NOT NULL,
* [code] varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [name] varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [url] varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [type] tinyint(4) NOT NULL COMMENT '0：项目\r\n1：导航\r\n2：菜单\r\n4：页面\r\n8：功能\r\n16：板块\r\n32：提示\r\n64：标记',
* [status] tinyint(255) NOT NULL,
* [created] timestamp(0) NULL,
* [modified] timestamp(0) NULL,
* PRIMARY KEY (Id) USING BTREE
* ) ENGINE = InnoDB AUTO_INCREMENT = 125 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
* CREATE TABLE IF NOT EXISTS {CREATE#yep_org_tree} (
* [Id] bigint(20) UNSIGNED NOT NULL,
* [parent_id] bigint(20) UNSIGNED NOT NULL,
* [disp_order] int(11) NOT NULL,
* [has_child] bit(1) NOT NULL,
* [code] varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [name] varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [type] tinyint(4) NOT NULL COMMENT '1：集团\r\n2：单位\r\n4：部门\r\n8：商铺\r\n16：虚拟节点',
* [status] tinyint(4) NOT NULL,
* [created] timestamp(0) NULL,
* [modified] timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
* PRIMARY KEY (Id) USING BTREE
* ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
* CREATE TABLE IF NOT EXISTS {CREATE#yep_orm_test} (
* [Id] bigint(20) NOT NULL,
* [Name] varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [Status] varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [Created] timestamp(0) NULL,
* [Modified] timestamp(3) NULL,
* PRIMARY KEY (Id) USING BTREE
* ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
* CREATE TABLE IF NOT EXISTS {CREATE#yep_users} (
* [Id] bigint(20) UNSIGNED NOT NULL,
* [org_id] bigint(20) UNSIGNED NOT NULL COMMENT '所在机构树节点ID',
* [company_id] bigint(20) UNSIGNED NOT NULL COMMENT '所在单位',
* [account] varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '账户',
* [role] int(11) NOT NULL COMMENT '角色',
* [name] varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称',
* [wechat_id] varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '微信ID',
* [alipay_id] varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '支付宝ID',
* [tel] varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '联系电话',
* [mail] varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '邮箱地址',
* [avatar] varchar(160) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '头像',
* [sex] tinyint(4) NOT NULL COMMENT '性别',
* [password] varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
* [salt] varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '加盐',
* [extends_enum] int(11) NOT NULL COMMENT '扩展信息',
* [status] int(11) NOT NULL COMMENT '状态',
* [registered] timestamp(0) NULL DEFAULT NULL COMMENT '注册日期时间戳',
* [modified] timestamp(3) NULL DEFAULT NULL,
* PRIMARY KEY (Id) USING BTREE
* ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
* CREATE TABLE IF NOT EXISTS {CREATE#yep_tax_code} (
* [id] varchar(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [parent_id] varchar(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [level] int(11) NOT NULL,
* [name] varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [short_name] varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [specification] varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [unit] varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [price] decimal(18, 2) NOT NULL,
* [use_policy] bit(1) NOT NULL,
* [policy_type] tinyint(4) NOT NULL,
* [tax_rate] double NOT NULL,
* [free_tax_type] tinyint(4) NOT NULL,
* [has_tax] bit(1) NOT NULL,
* [special_manage] varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [introduction] varchar(2048) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [status] tinyint(4) NOT NULL,
* [is_last_children] bit(1) NOT NULL DEFAULT b'0',
* [create_time] timestamp(0) NULL DEFAULT NULL,
* [modify_time] timestamp(0) NULL DEFAULT NULL,
* PRIMARY KEY ([id]) USING BTREE
* ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
* SET FOREIGN_KEY_CHECKS = 1;
*/
var settings = new MySqlCorrectSettings();
_ = sQL.Add(sQL1).ToString(settings);
/**
* select * from `fei_users` `a` , `fei_data` , `fei_userdetails` `b` on `a`.`uid`=`b`.`uid` where `a`.`uid` < 100;
* SET NAMES utf8mb4;
* SET FOREIGN_KEY_CHECKS = 0;
* DROP TABLE IF EXISTS `yep_companys`;
* CREATE TABLE IF NOT EXISTS `yep_auth_ship` (
* `id` bigint(20) NOT NULL,
* `owner_id` bigint(20) UNSIGNED NOT NULL,
* `auth_id` int(11) NOT NULL,
* `type` tinyint(4) NOT NULL,
* `status` int(11) NOT NULL,
* `created` timestamp(0) NULL,
* `modified` timestamp(0) NULL DEFAULT NULL,
* PRIMARY KEY (`id`) USING BTREE,
* CONSTRAINT FK_yep_companys_id FOREIGN KEY (`owner_id`) REFERENCES yep_companys (`id`) ON DELETE SET NULL ON UPDATE CASCADE
* ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic
* DELETE FROM yep_auth_ship;
* CREATE TABLE IF NOT EXISTS `yep_auth_tree` (
* `Id` int(11) NOT NULL AUTO_INCREMENT,
* `parent_id` int(11) NOT NULL,
* `disp_order` int(11) NOT NULL,
* `has_child` bit(1) NOT NULL,
* `code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* `type` tinyint(4) NOT NULL COMMENT '0：项目\r\n1：导航\r\n2：菜单\r\n4：页面\r\n8：功能\r\n16：板块\r\n32：提示\r\n64：标记',
* `status` tinyint(255) NOT NULL,
* `created` timestamp(0) NULL,
* `modified` timestamp(0) NULL,
* PRIMARY KEY (Id) USING BTREE
* ) ENGINE = InnoDB AUTO_INCREMENT = 125 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
* CREATE TABLE IF NOT EXISTS `yep_org_tree` (
* `Id` bigint(20) UNSIGNED NOT NULL,
* `parent_id` bigint(20) UNSIGNED NOT NULL,
* `disp_order` int(11) NOT NULL,
* `has_child` bit(1) NOT NULL,
* `code` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* `name` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* `type` tinyint(4) NOT NULL COMMENT '1：集团\r\n2：单位\r\n4：部门\r\n8：商铺\r\n16：虚拟节点',
* `status` tinyint(4) NOT NULL,
* `created` timestamp(0) NULL,
* `modified` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
* PRIMARY KEY (Id) USING BTREE
* ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
* CREATE TABLE IF NOT EXISTS `yep_orm_test` (
* `Id` bigint(20) NOT NULL,
* `Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* `Status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* `Created` timestamp(0) NULL,
* `Modified` timestamp(3) NULL,
* PRIMARY KEY (Id) USING BTREE
* ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
* CREATE TABLE IF NOT EXISTS `yep_users` (
* `Id` bigint(20) UNSIGNED NOT NULL,
* `org_id` bigint(20) UNSIGNED NOT NULL COMMENT '所在机构树节点ID',
* `company_id` bigint(20) UNSIGNED NOT NULL COMMENT '所在单位',
* `account` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '账户',
* `role` int(11) NOT NULL COMMENT '角色',
* `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称',
* `wechat_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '微信ID',
* `alipay_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '支付宝ID',
* `tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '联系电话',
* `mail` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '邮箱地址',
* `avatar` varchar(160) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '头像',
* `sex` tinyint(4) NOT NULL COMMENT '性别',
* `password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
* `salt` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '加盐',
* `extends_enum` int(11) NOT NULL COMMENT '扩展信息',
* `status` int(11) NOT NULL COMMENT '状态',
* `registered` timestamp(0) NULL DEFAULT NULL COMMENT '注册日期时间戳',
* `modified` timestamp(3) NULL DEFAULT NULL,
* PRIMARY KEY (Id) USING BTREE
* ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
* CREATE TABLE IF NOT EXISTS `yep_tax_code` (
* `id` varchar(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* `parent_id` varchar(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* `level` int(11) NOT NULL,
* `name` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* `short_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* `specification` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* `unit` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* `price` decimal(18, 2) NOT NULL,
* `use_policy` bit(1) NOT NULL,
* `policy_type` tinyint(4) NOT NULL,
* `tax_rate` double NOT NULL,
* `free_tax_type` tinyint(4) NOT NULL,
* `has_tax` bit(1) NOT NULL,
* `special_manage` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* `introduction` varchar(2048) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* `status` tinyint(4) NOT NULL,
* `is_last_children` bit(1) NOT NULL DEFAULT b'0',
* `create_time` timestamp(0) NULL DEFAULT NULL,
* `modify_time` timestamp(0) NULL DEFAULT NULL,
* PRIMARY KEY (`id`) USING BTREE
* ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
* SET FOREIGN_KEY_CHECKS = 1;
*/
var sqlSettings = new SqlServerCorrectSettings();
sqlSettings.Formatters.Add(new CreateIfFormatter());
sqlSettings.Formatters.Add(new DropIfFormatter());
_ = sQL.ToString(sqlSettings);
/**
* select * from [fei_users] [a] , [fei_data] , [fei_userdetails] [b] on [a].[uid]=[b].[uid] where [a].[uid] < 100;
* SET NAMES utf8mb4;
* SET FOREIGN_KEY_CHECKS = 0;
* IF EXIXSTS(SELECT * FROM [sysobjects] WHERE [xtype]='U' and [name] ='yep_companys') BEGIN
* DROP TABLE [yep_companys];
* END GO
*
* IF NOT EXIXSTS(SELECT * FROM [sysobjects] WHERE [xtype]='U' AND [name] ='yep_auth_ship') BEGIN
* CREATE TABLE [yep_auth_ship] (
* [id] bigint(20) NOT NULL,
* [owner_id] bigint(20) UNSIGNED NOT NULL,
* [auth_id] int(11) NOT NULL,
* [type] tinyint(4) NOT NULL,
* [status] int(11) NOT NULL,
* [created] timestamp(0) NULL,
* [modified] timestamp(0) NULL DEFAULT NULL,
* PRIMARY KEY ([id]) USING BTREE,
* CONSTRAINT FK_yep_companys_id FOREIGN KEY ([owner_id]) REFERENCES yep_companys ([id]) ON DELETE SET NULL ON UPDATE CASCADE
* ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic
*
* END GO
* DELETE FROM yep_auth_ship;
* IF NOT EXIXSTS(SELECT * FROM [sysobjects] WHERE [xtype]='U' AND [name] ='yep_auth_tree') BEGIN
* CREATE TABLE [yep_auth_tree] (
* [Id] int(11) NOT NULL AUTO_INCREMENT,
* [parent_id] int(11) NOT NULL,
* [disp_order] int(11) NOT NULL,
* [has_child] bit(1) NOT NULL,
* [code] varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [name] varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [url] varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [type] tinyint(4) NOT NULL COMMENT '0：项目\r\n1：导航\r\n2：菜单\r\n4：页面\r\n8：功能\r\n16：板块\r\n32：提示\r\n64：标记',
* [status] tinyint(255) NOT NULL,
* [created] timestamp(0) NULL,
* [modified] timestamp(0) NULL,
* PRIMARY KEY (Id) USING BTREE
* ) ENGINE = InnoDB AUTO_INCREMENT = 125 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
* END GO
*
* IF NOT EXIXSTS(SELECT * FROM [sysobjects] WHERE [xtype]='U' AND [name] ='yep_org_tree') BEGIN
* CREATE TABLE [yep_org_tree] (
* [Id] bigint(20) UNSIGNED NOT NULL,
* [parent_id] bigint(20) UNSIGNED NOT NULL,
* [disp_order] int(11) NOT NULL,
* [has_child] bit(1) NOT NULL,
* [code] varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [name] varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [type] tinyint(4) NOT NULL COMMENT '1：集团\r\n2：单位\r\n4：部门\r\n8：商铺\r\n16：虚拟节点',
* [status] tinyint(4) NOT NULL,
* [created] timestamp(0) NULL,
* [modified] timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
* PRIMARY KEY (Id) USING BTREE
* ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
* END GO
*
* IF NOT EXIXSTS(SELECT * FROM [sysobjects] WHERE [xtype]='U' AND [name] ='yep_orm_test') BEGIN
* CREATE TABLE [yep_orm_test] (
* [Id] bigint(20) NOT NULL,
* [Name] varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [Status] varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [Created] timestamp(0) NULL,
* [Modified] timestamp(3) NULL,
* PRIMARY KEY (Id) USING BTREE
* ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
* END GO
*
* IF NOT EXIXSTS(SELECT * FROM [sysobjects] WHERE [xtype]='U' AND [name] ='yep_users') BEGIN
* CREATE TABLE [yep_users] (
* [Id] bigint(20) UNSIGNED NOT NULL,
* [org_id] bigint(20) UNSIGNED NOT NULL COMMENT '所在机构树节点ID',
* [company_id] bigint(20) UNSIGNED NOT NULL COMMENT '所在单位',
* [account] varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '账户',
* [role] int(11) NOT NULL COMMENT '角色',
* [name] varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称',
* [wechat_id] varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '微信ID',
* [alipay_id] varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '支付宝ID',
* [tel] varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '联系电话',
* [mail] varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '邮箱地址',
* [avatar] varchar(160) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '头像',
* [sex] tinyint(4) NOT NULL COMMENT '性别',
* [password] varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
* [salt] varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '加盐',
* [extends_enum] int(11) NOT NULL COMMENT '扩展信息',
* [status] int(11) NOT NULL COMMENT '状态',
* [registered] timestamp(0) NULL DEFAULT NULL COMMENT '注册日期时间戳',
* [modified] timestamp(3) NULL DEFAULT NULL,
* PRIMARY KEY (Id) USING BTREE
* ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
* END GO
*
* IF NOT EXIXSTS(SELECT * FROM [sysobjects] WHERE [xtype]='U' AND [name] ='yep_tax_code') BEGIN
* CREATE TABLE [yep_tax_code] (
* [id] varchar(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [parent_id] varchar(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [level] int(11) NOT NULL,
* [name] varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [short_name] varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [specification] varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [unit] varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [price] decimal(18, 2) NOT NULL,
* [use_policy] bit(1) NOT NULL,
* [policy_type] tinyint(4) NOT NULL,
* [tax_rate] double NOT NULL,
* [free_tax_type] tinyint(4) NOT NULL,
* [has_tax] bit(1) NOT NULL,
* [special_manage] varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [introduction] varchar(2048) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
* [status] tinyint(4) NOT NULL,
* [is_last_children] bit(1) NOT NULL DEFAULT b'0',
* [create_time] timestamp(0) NULL DEFAULT NULL,
* [modify_time] timestamp(0) NULL DEFAULT NULL,
* PRIMARY KEY ([id]) USING BTREE
* ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
* END GO
*
* SET FOREIGN_KEY_CHECKS = 1;
*/
_ = new SQL("SELECT ywdjid as requestid FROM dzfp GROUP BY ywdjid");
}
private static SQL.SQLSelectTableJoins TableJoinsFromAttributes(TableJoinAttribute[] tableJoinAttributes, SQL.SQLSelectTable primaryTable, SQL.SQLSelectTables tables)
{
SQL.SQLSelectTableJoins tableJoinsCollection = new SQL.SQLSelectTableJoins();
SQL.SQLSelectTableBase leftTable = primaryTable;
string leftTableName = primaryTable.Name;
foreach (var tableJoinAttribute in tableJoinAttributes)
{
SQL.SQLSelectTableBase rightTable = tables.Add(tableJoinAttribute.ToTableName);
var tableJoin = tableJoinsCollection.Add(leftTable, SQL.SQLSelectTableJoin.Type.Inner, rightTable);
tableJoin.Where.Add(new SQL.SQLFieldExpression(new SQL.SQLSelectTable(leftTableName), tableJoinAttribute.FieldName), SQL.ComparisonOperator.EqualTo, new SQL.SQLFieldExpression(new SQL.SQLSelectTable(tableJoinAttribute.ToTableName), tableJoinAttribute.ToFieldName));
leftTable = tableJoin;
leftTableName = tableJoinAttribute.ToTableName;
}
return tableJoinsCollection;
}
static void Main(string[] args)
{
//Inheritance => Kalıtım/Miras Alma
//Interface => Implementation // Class => Inheritance
//Bir class aynı anda birden fazla interface' i implemente edebilirken sadece bir tane class' ı inherit edebilir.
//=> Person.cs
Person customer_p = new Customer();
customer_p.FirstName = "Fikret";
customer_p.LastName = "Gözütok";
customer_p.ID = 0;
Customer customer_n = new Customer();
customer_n.FirstName = "İsmail";
customer_n.LastName = "Demir";
customer_n.ID = 1;
customer_n.Address = "Kütahya";
customer_n.live();
IPerson[] personList = new IPerson[]
{
new Customer
{
FirstName = "Tunahan",
LastName = "İbiroğlu",
ID = 2,
Address = "Balıkesir"
},
new Student
{
FirstName = "Hüseyin",
LastName = "Asma",
ID = 3,
Department = "Lise"
}
};
foreach (IPerson person in personList)
{
person.live();
}
Console.WriteLine("\n\n\n");
//Virtual Methods
//Database.cs
Oracle oracle = new Oracle();
SQL sql = new SQL();
oracle.Add();
sql.Add();
oracle.Delete();
sql.Delete();
Console.Read();
}
public void Create()
{
//Если клиента нет в базе он добавляется
if (SQL.GetClientses().Find(t => t.Name == Name && t.Phone == Phone) == null)
{
SQL.Add(new Clients()
{
Name = Name, Address = Address, Phone = Phone, Email = Email
});
}
//Если типа устройства нет в базе он добавляется
if (TypesDevices != String.Empty)
{
if (!SQL.GetTypesDevices().Select(s => s.Type).Contains(TypesDevices))
{
SQL.Add(new DicTypesDevices()
{
Type = TypesDevices
});
}
}
if (Fabricator != String.Empty)
{
if (!SQL.GetFabricator().Select(f => f.Fabricator).Contains(Fabricator))
{
SQL.Add(new DicFabricator()
{
Fabricator = Fabricator
});
}
}
if (Model != String.Empty)
{
if (!SQL.GetModelInFabricator(SQL.GetIdFabricator(Fabricator)).Contains(Model))
{
SQL.Add(new DicModel()
{
Model = Model, IdFabricator = SQL.GetIdFabricator(Fabricator)
});
}
}
var o = new Orders()
{
IdClient = SQL.GetClientses().First(t => t.Name == Name && t.Phone == Phone).IdClient,
Number = Number,
IdTypeDevice = SQL.GetIdTypeDevice(TypesDevices),
IdFabricator = SQL.GetIdFabricator(Fabricator),
IdModel = SQL.GetIdModel(Model, SQL.GetIdFabricator(Fabricator)),
SerialNumber = SerialNumber,
Appearance = Appearance,
Equipment = Equipment,
Malfunction = Malfunction,
NotesOnAdmission = NotesOnAdmission,
AvailabilityDate = AvailabilityDate,
DateReceipt = DateTime.Now,
EstimatedPrice = EstimatedPrice,
Prepayment = Prepayment,
IdExecutor = SQL.GetIdExecutor(Executors)
};
if (_orders == null)
{
o.IdState = 1;
SQL.Add(o);
SQL.AddHistory(SQL.GetOrders().OrderByDescending(o1 => o1.IdOrder).First().IdOrder, "Заказ принят");
ShowWin.ShowOrders();
}
else
{
o.IdState = _orders.IdState;
o.IdOrder = _orders.IdOrder;
SQL.AddHistory(o.IdOrder, "Редактирование заказа");
SQL.Update(o);
ShowWin.ShowWork(o);
}
}
/************************************************************************************************************************/
internal void ParseSQL(string paras)
{
SQL.Clear();
SQL.Add(paras);
}
public static AddedView AddedModel(DicModel model)
{
var cbFabricator = new ComboBox()
{
Margin = new Thickness(10, 0, 10, 10), ItemsSource = SQL.GetFabricator().Select(s => s.Fabricator)
};
var lblF = new Label()
{
Content = "Необходимо заполнить Производителя", Foreground = Brushes.Red, Visibility = Visibility.Collapsed
};
var tbModel = new TextBox()
{
Margin = new Thickness(10, 0, 10, 10)
};
var lblM = new Label()
{
Content = "Необходимо заполнить Модель", Foreground = Brushes.Red, Visibility = Visibility.Collapsed
};
var a = new AddedView
{
Controls = new List <Control>
{
new Label()
{
Content = "Производитель", Margin = new Thickness(10, 0, 10, 0)
},
cbFabricator,
lblF,
new Label()
{
Content = "Модель", Margin = new Thickness(10, 0, 10, 0)
},
tbModel,
lblM
}
};
if (model == null)
{
a.Submit = new SimpleCommand(() =>
{
if (string.IsNullOrEmpty(cbFabricator.Text.Trim()) || (string.IsNullOrEmpty(tbModel.Text.Trim())))
{
lblF.Visibility = (string.IsNullOrEmpty(cbFabricator.Text.Trim())) ? Visibility.Visible : Visibility.Collapsed;
lblM.Visibility = (string.IsNullOrEmpty(tbModel.Text.Trim())) ? Visibility.Visible : Visibility.Collapsed;
return;
}
SQL.Add(new DicModel()
{
IdFabricator = SQL.GetIdFabricator(cbFabricator.SelectedItem.ToString()),
Model = tbModel.Text
});
a.Close();
});
}
else
{
tbModel.Text = model.Model;
cbFabricator.SelectedValue = SQL.GetFabricator(model.IdFabricator);
a.Submit = new SimpleCommand(() =>
{
if (string.IsNullOrEmpty(cbFabricator.Text.Trim()) || (string.IsNullOrEmpty(tbModel.Text.Trim())))
{
lblF.Visibility = (string.IsNullOrEmpty(cbFabricator.Text.Trim())) ? Visibility.Visible : Visibility.Collapsed;
lblM.Visibility = (string.IsNullOrEmpty(tbModel.Text.Trim())) ? Visibility.Visible : Visibility.Collapsed;
return;
}
SQL.Update(new DicModel()
{
IdModel = model.IdModel,
IdFabricator = SQL.GetIdFabricator(cbFabricator.SelectedItem.ToString()),
Model = tbModel.Text
});
a.Close();
});
}
a.Init();
mainWindow.ShowAddedWindow(a);
return(a);
}
